Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

indexHashJoin should return oom error instead of empty set #18572

Closed
XuHuaiyu opened this issue Jul 15, 2020 · 0 comments · Fixed by #18573
Closed

indexHashJoin should return oom error instead of empty set #18572

XuHuaiyu opened this issue Jul 15, 2020 · 0 comments · Fixed by #18573

Comments

@XuHuaiyu
Copy link
Contributor

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

use test;
drop table if exists t1;
create table t1(a int, b int, index idx(b));
Set tidb_mem_quota_query=0;
insert into t1 values(1, 1);
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;
insert into t1 select * from t1;

Set tidb_mem_quota_query=1024;
select /*+ inl_hash_join(t1) */ * from t1 right join t1 t2 on t1.b=t2.b;

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

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

3. What did you see instead (Required)

select /*+ inl_hash_join(t1) */ * from t1 right join t1 t2 on t1.b=t2.b;
Empty set (0.01 sec)

4. Affected version (Required)

v4.0.x

5. Root Cause Analysis

@XuHuaiyu XuHuaiyu added type/bug This issue is a bug. sig/execution SIG execution labels Jul 15, 2020
@github-actions github-actions bot added this to Issue Backlog: Need Triage in SIG Runtime Kanban Jul 15, 2020
@github-actions github-actions bot added this to Need Triage in Question and Bug Reports Jul 15, 2020
Question and Bug Reports automation moved this from Need Triage to Closed(This Week) Jul 15, 2020
SIG Runtime Kanban automation moved this from Issue Backlog: Need Triage to Develop Finished (This Week) Jul 15, 2020
@SunRunAway SunRunAway moved this from Develop Finished (This Week) to Need QA Test in SIG Runtime Kanban Jul 18, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
severity/critical sig/execution SIG execution type/bug This issue is a bug.
Projects
No open projects
Question and Bug Reports
  
Closed(Archived Every Week)
SIG Runtime Kanban
  
Need QA Test
Development

Successfully merging a pull request may close this issue.

2 participants