bug: query result wrong: CASE WHEN THEN ELSE

[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

MySQL 5.7 Result

Expected behavior

No response

How To Reproduce

CREATE TABLE t0(c0 INT NULL);
INSERT INTO t0(c0) VALUES (DEFAULT);
SELECT * FROM t0 WHERE (CASE (t0.c0 IN (t0.c0)) WHEN TRUE THEN 'TRUE' ELSE 'FALSE' END );

Environment

Docker v1.0.4

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

• Yes, I will!