stonedb
stonedb copied to clipboard
bug: query result wrong: NATURAL LEFT JOIN
Have you read the Contributing Guidelines on issues?
- [X] I have read the Contributing Guidelines on issues.
Please confirm if bug report does NOT exists already ?
- [X] I confirm there is no existing issue for this
Describe the problem
SQLancer find that StoneDB's query result does not meet expectation:
Expected behavior
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!