You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
100 lines
4.2 KiB
Plaintext
100 lines
4.2 KiB
Plaintext
#
|
|
# Some double/float tests moved from regr.
|
|
# DML, DQL w/without filters
|
|
#
|
|
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS `double_float`;
|
|
--enable_warnings
|
|
CREATE DATABASE `double_float`;
|
|
USE `double_float`;
|
|
|
|
SET default_storage_engine=Columnstore;
|
|
SELECT @@default_storage_engine;
|
|
|
|
set autocommit=0;
|
|
|
|
CREATE TABLE test1 (dkey int);
|
|
INSERT INTO test1 VALUES (1), (2), (3);
|
|
SELECT test1.dkey FROM test1 ORDER BY test1.dkey;
|
|
|
|
CREATE TABLE qatabledouble (col DOUBLE) ;
|
|
CREATE TABLE qatablefloat (col float) ;
|
|
INSERT INTO qatabledouble VALUES (-2.225073858507201E-307); # Changed -308 to -307, -308 errors on qaftest7.
|
|
INSERT INTO qatabledouble VALUES (-1.807302187774382E-127);
|
|
INSERT INTO qatabledouble VALUES (0);
|
|
INSERT INTO qatabledouble VALUES (1.993777023789432E+21);
|
|
INSERT INTO qatabledouble VALUES (1.797693134862315E+38);
|
|
INSERT INTO qatabledouble VALUES (-19937770237894323221);
|
|
INSERT INTO qatabledouble VALUES (17976931348623158);
|
|
SELECT * FROM qatabledouble;
|
|
INSERT INTO qatabledouble VALUES (null);
|
|
INSERT INTO qatabledouble VALUES (null);
|
|
INSERT INTO qatabledouble VALUES (null);
|
|
SELECT * FROM qatabledouble;
|
|
INSERT INTO qatablefloat VALUES (null);
|
|
INSERT INTO qatablefloat VALUES (null);
|
|
INSERT INTO qatablefloat VALUES (null);
|
|
SELECT * FROM qatablefloat;
|
|
DELETE FROM qatabledouble WHERE col IS NULL;
|
|
SELECT * FROM qatabledouble;
|
|
delete FROM qatablefloat WHERE col IS NULL;
|
|
SELECT * FROM qatablefloat;
|
|
CREATE TABLE qatabledouble_v2 (col1 DOUBLE, col2 DOUBLE, col3 DOUBLE) ;
|
|
INSERT INTO qatabledouble_v2 VALUES (-0.50, -0.50, -0.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (-0.49, -0.49, -0.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (0.49, 0.49, 0.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (0.50, 0.50, 0.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (+8,+8,+8);
|
|
INSERT INTO qatabledouble_v2 VALUES (+0.50,+0.50,+0.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (+0.49,+0.49,+0.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (+0.0,+0.0,+0.0);
|
|
INSERT INTO qatabledouble_v2 VALUES (+.50,+.50,+.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (+.49,+.49,+.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (+.0,+.0,+.0);
|
|
INSERT INTO qatabledouble_v2 VALUES (-.0,-.0,-.0);
|
|
INSERT INTO qatabledouble_v2 VALUES (-.49,-.49,-.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (-.50,-.50,-.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (-0.0,-0.0,-0.0);
|
|
INSERT INTO qatabledouble_v2 VALUES (-0.49,-0.49,-0.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (-0.50,-0.50,-0.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (-8,-8,-8);
|
|
INSERT INTO qatabledouble_v2 VALUES (8,8,8);
|
|
INSERT INTO qatabledouble_v2 VALUES (0.50,0.50,0.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (0.49,0.49,0.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (0.0,0.0,0.0);
|
|
INSERT INTO qatabledouble_v2 VALUES (.50,.50,.50);
|
|
INSERT INTO qatabledouble_v2 VALUES (.49,.49,.49);
|
|
INSERT INTO qatabledouble_v2 VALUES (.0,.0,.0);
|
|
SELECT * FROM qatabledouble_v2;
|
|
CREATE TABLE qatablefloat_v3 (col1 float, col2 float, col3 float) ;
|
|
INSERT INTO qatablefloat_v3 VALUES (-0.50, -0.50, -0.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (-0.49, -0.49, -0.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (0.49, 0.49, 0.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (0.50, 0.50, 0.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (+8,+8,+8);
|
|
INSERT INTO qatablefloat_v3 VALUES (+0.50,+0.50,+0.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (+0.49,+0.49,+0.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (+0.0,+0.0,+0.0);
|
|
INSERT INTO qatablefloat_v3 VALUES (+.50,+.50,+.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (+.49,+.49,+.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (+.0,+.0,+.0);
|
|
INSERT INTO qatablefloat_v3 VALUES (-.0,-.0,-.0);
|
|
INSERT INTO qatablefloat_v3 VALUES (-.49,-.49,-.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (-.50,-.50,-.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (-0.0,-0.0,-0.0);
|
|
INSERT INTO qatablefloat_v3 VALUES (-0.49,-0.49,-0.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (-0.50,-0.50,-0.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (-8,-8,-8);
|
|
INSERT INTO qatablefloat_v3 VALUES (8,8,8);
|
|
INSERT INTO qatablefloat_v3 VALUES (0.50,0.50,0.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (0.49,0.49,0.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (0.0,0.0,0.0);
|
|
INSERT INTO qatablefloat_v3 VALUES (.50,.50,.50);
|
|
INSERT INTO qatablefloat_v3 VALUES (.49,.49,.49);
|
|
INSERT INTO qatablefloat_v3 VALUES (.0,.0,.0);
|
|
SELECT * FROM qatablefloat_v3;
|
|
|
|
DROP DATABASE `double_float`; |