Incorrect result is returned when comparing with null

[JinheLin]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

 drop table if exists test.t;

 create table test.t (a date);

 insert into test.t values("2024-08-26"),("2024-08-25"),("2024-08-24"),("2024-08-23");

 alter table test.t set tiflash replica 1;

 alter table test.t compact tiflash replica;

 set session tidb_isolation_read_engines='tiflash'; select * from test.t where not (a between NULL and '2024-08-25');

2. What did you expect to see? (Required)

+------------+
| a          |
+------------+
| 2024-08-26 |
+------------+

3. What did you see instead (Required)

+------------+
| a          |
+------------+
| 2024-08-26 |
| 2024-08-25 |
| 2024-08-24 |
| 2024-08-23 |
+------------+

4. What is your TiFlash version? (Required)

f0a4087

[JinheLin]

MinMaxIndex does not handle compare in correct ways:

tiflash/dbms/src/Storages/DeltaMerge/Index/MinMaxIndex.cpp

Lines 422 to 426 in 81cd947

	RSResults MinMaxIndex::checkCmp(size_t start_pack, size_t pack_count, const Field & value, const DataTypePtr & type)
	{
	RSResults results(pack_count, RSResult::None);
	if (value.isNull())
	return results;

tiflash/dbms/src/Storages/DeltaMerge/Index/RoughCheck.h

Lines 76 to 78 in 81cd947

	// skip null value
	if (v.isNull())
	continue;