bug: query result wrong: NATURAL LEFT JOIN

[ZhengLin-Li]

Have you read the Contributing Guidelines on issues?

• I have 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:

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!