You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-10-30 07:25:34 +03:00
20 lines
585 B
Plaintext
20 lines
585 B
Plaintext
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`;
|