executor: wrong results for not in clause #24071
Labels
duplicate
Issues or pull requests already exists.
severity/critical
sig/execution
SIG execution
type/bug
The issue is confirmed as a bug.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
part of #23889 and the pr only fixs the first case. I create another issue to trace the second case.
mysql -h172.16.5.85 -P52324 -uroot -D subquery_agg10000
2. What did you expect to see? (Required)
+--------+
| field1 |
+--------+
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
| NULL |
+--------+
3. What did you see instead (Required)
+--------+
| field1 |
+--------+
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
| 1 |
4. What is your TiDB version? (Required)
master
The text was updated successfully, but these errors were encountered: