bug: query result wrong: INSERT, DELETE, UNION ALL

[zhenglin-charlie-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

The query result does not meet expectation

StoneDB V1.0.4 Result

Expected behavior

MySQL 5.7 Result

How To Reproduce

CREATE TABLE t0(c0 INT, c1 CHAR) ;
INSERT INTO t0(c1) VALUE (1);
DELETE  FROM t0;

SELECT * FROM t0 WHERE t0.c1 IS TRUE UNION ALL SELECT * FROM t0 WHERE (t0.c1 IS NOT TRUE);

Environment

Docker v1.0.4

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

• Yes, I will!