--source ../include/have_columnstore.inc
--disable_warnings
DROP DATABASE IF EXISTS `mcol_4756`;
--enable_warnings
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);

# cleanup
DROP DATABASE `mcol_4756`;