stonedb icon indicating copy to clipboard operation
stonedb copied to clipboard

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

Open ZhengLin-Li opened this issue 11 months ago • 0 comments

Have you 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

image

Expected behavior

MySQL 5.7 Example

image

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!

ZhengLin-Li avatar Jul 19 '23 03:07 ZhengLin-Li