You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-06-10 17:41:44 +03:00
23 lines
652 B
Plaintext
23 lines
652 B
Plaintext
-- 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`;
|