index_lookup_join return empty result if it is Out Of Memory Quota

[ChenPeng2013]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

oom-action = "cancel"

use test;
drop table if exists t1, t2;
create table t1(a int, index(a));
create table t2(a int, index(a));
insert into t1 values(1),(2);
insert into t2 values(1),(1),(2),(2);
set @@tidb_mem_quota_query=8000;
set tidb_index_join_batch_size = 1;
select /*+ inl_join(t1) */ * from t1 join t2 on t1.a = t2.a;

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

mysql> select /*+ inl_join(t1) */ * from t1 join t2 on t1.a = t2.a;
+------+------+
| a    | a    |
+------+------+
|    1 |    1 |
|    1 |    1 |
|    2 |    2 |
|    2 |    2 |
+------+------+
4 rows in set (0.00 sec)

3. What did you see instead (Required)

mysql> select /*+ inl_join(t1) */ * from t1 join t2 on t1.a = t2.a;
Empty set (0.00 sec)

4. What is your TiDB version? (Required)

Release Version: v5.4.0-alpha-245-g6d7a32064
Edition: Community
Git Commit Hash: 6d7a32064159ab6924ef0d0d095933e80293b478
Git Branch: master
UTC Build Time: 2021-11-29 03:11:31
GoVersion: go1.16.5
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

[XuHuaiyu]

Caused by the mistaken delete

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.