DROP DATABASE IF EXISTS `doubles_and_nulls`;
CREATE DATABASE `doubles_and_nulls`;
USE `doubles_and_nulls`;
DROP TABLE IF EXISTS qatablefloat;
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;
col
3.14
0
1.44
DROP TABLE qatablefloat;
DROP DATABASE `doubles_and_nulls`;