stoneatom / stonedb

StoneDB is an Open-Source MySQL HTAP and MySQL-Native DataBase for OLTP, Real-Time Analytics, a counterpart of MySQLHeatWave. (https://stonedb.io)
https://stonedb.io/
GNU General Public License v2.0
866 stars 141 forks source link

crash: StoneDB crash: HAVING, IS NULL #1954

Open zhenglin-charlie-li opened 1 year ago

zhenglin-charlie-li commented 1 year ago

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

Describe the problem

StoneDB V1.0.4 Example

image

Expected behavior

MySQL 5.7 Example

image

How To Reproduce

CREATE TABLE t0(c0 INT);
SELECT * FROM t0 HAVING (1 IS NULL);

Environment

Docker image StoneDB V1.0.4

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