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

bug: query result wrong: NATURAL LEFT JOIN #1957

Open
2 of 3 tasks
zhenglin-charlie-li opened this issue Jul 19, 2023 · 0 comments
Open
2 of 3 tasks

bug: query result wrong: NATURAL LEFT JOIN #1957

zhenglin-charlie-li opened this issue Jul 19, 2023 · 0 comments
Labels
A-bug Something isn't working

Comments

@zhenglin-charlie-li
Copy link

zhenglin-charlie-li commented Jul 19, 2023

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

SQLancer find that StoneDB's query result does not meet expectation:

image

Expected behavior

image

How To Reproduce

CREATE TABLE t0(c0 INT);
CREATE TABLE t2 LIKE t0;
INSERT INTO t2(c0) VALUE (DEFAULT);
DELETE  FROM t2;

SELECT * FROM t2 NATURAL LEFT JOIN t0 WHERE ((t2.c0) IS NULL);

# wait 3 seconds
SELECT * FROM t2 NATURAL LEFT JOIN t0 WHERE ((t2.c0) IS NULL);

Environment

docker latest version with tianmu_insert_delayed=0

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!
@zhenglin-charlie-li zhenglin-charlie-li added the A-bug Something isn't working label Jul 19, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
A-bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant