Join result is inconsistent with TiDB #6393
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
use go-randgen generate data.
cmd: go-randgen gendata --dsns "root:@tcp(127.0.0.1:4000)/test"
set tidb_isolation_read_engines=tikv;
SELECT /*+ inl_hash_join (t1,t2) */ count(*) FROM table_90_utf8_undef t1 left outer join table_20_latin1_undef t2 on t1. `col_bigint_undef_unsigned` / t2. `col_decimal(40, 20)_key_signed` right join table_30_latin1_6 t3 on t2. `col_double_undef_unsigned` >= t3. `col_enum_key_signed`;
set tidb_isolation_read_engines=tiflash;
set tidb_enforce_mpp=on;
SELECT /*+ inl_hash_join (t1,t2) */ count(*) FROM table_90_utf8_undef t1 left outer join table_20_latin1_undef t2 on t1. `col_bigint_undef_unsigned` / t2. `col_decimal(40, 20)_key_signed` right join table_30_latin1_6 t3 on t2. `col_double_undef_unsigned` >= t3. `col_enum_key_signed`;2. What did you expect to see? (Required)
+----------+
| count(*) |
+----------+
| 8334 |
+----------+
+----------+
| count(*) |
+----------+
| 8334 |
+----------+3. What did you see instead (Required)
+----------+
| count(*) |
+----------+
| 8334 |
+----------+
+----------+
| count(*) |
+----------+
| 7902 |
+----------+
4. What is your TiFlash version? (Required)
nightly