Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
23.10.1
-
None
-
None
-
2024-2
Description
See the example below
CREATE TABLE `manu_test` (
id tinyint unsigned NOT NULL,
test tinyint default null
) ENGINE=Columnstore DEFAULT CHARSET=utf8;
INSERT INTO `manu_test`
(`id`,
`test`)
VALUES
(1,0),
(2,1),
(3,null)
;
select id, test from manu_test having not(test);
"having not" creates an "Error Code: 2013. Lost connection to MySQL server during query"
having, where, where not all work fine