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