"Out Of Memory Quota" return wrong results

[ChenPeng2013]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
[test.txt](https://github.com/pingcap/tidb/files/7836737/test.txt)
set tidb_mem_quota_query=2097152;
# please execute many times
select /*+ inl_join(t1) */ * from t1 right join t2 on t1.b=t2.b;

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

mysql> select /*+ inl_join(t1) */ * from t1 right join t2 on t1.b=t2.b;
....
32771 rows in set (0.05 sec)

or

mysql> select /*+ inl_join(t1) */ * from t1 right join t2 on t1.b=t2.b;
ERROR 1105 (HY000): Out Of Memory Quota![conn_id=7]

3. What did you see instead (Required)

mysql> select /*+ inl_join(t1) */ * from t1 right join t2 on t1.b=t2.b;
....
| NULL | NULL | 8187 | 8187 | 8187 |
| NULL | NULL | 8188 | 8188 | 8188 |
| NULL | NULL | 8189 | 8189 | 8189 |
| NULL | NULL | 8190 | 8190 | 8190 |
+------+------+------+------+------+
8194 rows in set (0.03 sec)

4. What is your TiDB version? (Required)

Release Version: v5.5.0-alpha-22-ge0157f4a8
Edition: Community
Git Commit Hash: e0157f4a8cd86108acb2e14cd74e81c1f56f93e2
Git Branch: release-5.4
UTC Build Time: 2022-01-10 03:51:15
GoVersion: go1.16.5
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

[wshwsh12]

/assign @XuHuaiyu

[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.