mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/mcol-4756.result

DROP DATABASE IF EXISTS `mcol_4756`;
CREATE DATABASE `mcol_4756`;
USE `mcol_4756`;
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);
id	test
1	0
DROP DATABASE `mcol_4756`;