bug: after altering operation, NULL values is evlauated to be TRUE in StoneDB

[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 found that, after altering operation, NULL values is evlauated to be TRUE in StoneDB.

However, accroding to link: In MySQL, 0 or NULL means false and anything else means true. The default truth value from a boolean operation is 1.

Result in StoneDB:

Result in MySQL 5.7:

Expected behavior

No response

How To Reproduce

CREATE TABLE t0(c0 DATE);
INSERT INTO t0(c0) VALUES (DATE '1970-01-04'), (DEFAULT);
ALTER TABLE t0 CHANGE c0 c0 TEXT ;
SELECT * FROM t0 WHERE t0.c0 IS TRUE;
SELECT t0.c0 IS TRUE FROM t0;

Environment

Docker image v:1.0.4

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

• Yes, I will!