-- source ../include/have_columnstore.inc

--disable_warnings
DROP DATABASE IF EXISTS `doubles_and_nulls`;
CREATE DATABASE `doubles_and_nulls`;
USE `doubles_and_nulls`;

DROP TABLE IF EXISTS qatablefloat;
--enable_warnings

CREATE TABLE qatablefloat (col float) engine=columnstore;
INSERT INTO qatablefloat VALUES (null);
INSERT INTO qatablefloat VALUES (null);
INSERT INTO qatablefloat VALUES (null);
INSERT INTO qatablefloat VALUES (3.14);
INSERT INTO qatablefloat VALUES (0);
INSERT INTO qatablefloat VALUES (1.44);
DELETE FROM qatablefloat WHERE col IS NULL;
SELECT * FROM qatablefloat;

DROP TABLE qatablefloat;
DROP DATABASE `doubles_and_nulls`;