crash: StoneDB crash: PRIMARY KEY, HAVING, IS NULL - Githubissues

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

862 stars 140 forks source link

crash: StoneDB crash: PRIMARY KEY, HAVING, IS NULL #1952

Open zhenglin-charlie-li opened 1 year ago

zhenglin-charlie-li commented 1 year ago

Have you read the Contributing Guidelines on issues?

[X] I have read the Contributing Guidelines on issues.

Please confirm if bug report does NOT exists already ?

[X] I confirm there is no existing issue for this

Describe the problem

StoneDB V1.0.4 Example

Expected behavior

MySQL 5.7 Example

How To Reproduce

Example

CREATE TABLE t0(c0 INT PRIMARY KEY);

SELECT * FROM t0 HAVING (t0.c0 IS NULL);

Environment

Docker image StoneDB V1.0.4

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

[ ] Yes, I will!