database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-04-18 21:44:02 +03:00
Code
mariadb-columnstore-engine/mysql-test/columnstore/basic/r/mcol641-insert.result
Gagan Goel 78dbf3a7e1 MCOL-641 Move MTR tests from future/ to basic/
2021-07-12 13:01:45 +00:00

693 lines
56 KiB
Plaintext
Raw Permalink Blame History

DROP DATABASE IF EXISTS mcol641_insert_db;
CREATE DATABASE mcol641_insert_db;
USE mcol641_insert_db;
SET SQL_MODE='ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';
CREATE TABLE cs1 (d1 DECIMAL(38), d2 DECIMAL(38,10), d3 DECIMAL(38,38),
d4 DECIMAL(19), d5 DECIMAL(19,10), d6 DECIMAL(19,19)) ENGINE=columnstore;
CREATE TABLE cs2 (d1 DECIMAL(38) UNSIGNED, d2 DECIMAL(38,10) UNSIGNED, d3 DECIMAL(38,38) UNSIGNED,
d4 DECIMAL(19) UNSIGNED, d5 DECIMAL(19,10) UNSIGNED, d6 DECIMAL(19,19) UNSIGNED) ENGINE=columnstore;
CREATE TABLE cs3 (d1 DECIMAL(38), d2 DECIMAL(38,10), d3 DECIMAL(38,38),
d4 DECIMAL(19), d5 DECIMAL(19,10), d6 DECIMAL(19,19)) ENGINE=columnstore;
CREATE TABLE cs4 (d1 DECIMAL(38) UNSIGNED, d2 DECIMAL(38,10) UNSIGNED, d3 DECIMAL(38,38) UNSIGNED,
d4 DECIMAL(19) UNSIGNED, d5 DECIMAL(19,10) UNSIGNED, d6 DECIMAL(19,19) UNSIGNED) ENGINE=columnstore;
INSERT INTO cs1 VALUES (125, 1.25, 0.125, 125, 1.25, 0.125);
INSERT INTO cs1 VALUES (-125, -1.25, -0.125, -125, -1.25, -0.125);
INSERT INTO cs1 VALUES (1.25, 125, 125, 1.25, 125, 125);
Warnings:
Note 1265 Data truncated for column 'd1' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Note 1265 Data truncated for column 'd4' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs1 VALUES (-1.25, -125, -125, -1.25, -125, -125);
Warnings:
Note 1265 Data truncated for column 'd1' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Note 1265 Data truncated for column 'd4' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs1 values (99999999999999999999999999999999999998, 9999999999999999999999999999.9999999998, 0.99999999999999999999999999999999999998, 9999999999999999998, 999999999.9999999998, 0.9999999999999999998);
INSERT INTO cs1 values (99999999999999999999999999999999999999, 9999999999999999999999999999.9999999999, 0.99999999999999999999999999999999999999, 9999999999999999999, 999999999.9999999999, 0.9999999999999999999);
INSERT INTO cs1 values (-99999999999999999999999999999999999998, -9999999999999999999999999999.9999999998, -0.99999999999999999999999999999999999998, -9999999999999999998, -999999999.9999999998, -0.9999999999999999998);
INSERT INTO cs1 values (-99999999999999999999999999999999999999, -9999999999999999999999999999.9999999999, -0.99999999999999999999999999999999999999, -9999999999999999999, -999999999.9999999999, -0.9999999999999999999);
INSERT INTO cs1 VALUES (123456789012345678901234567890123456789, 12345678901234567890123456789.12345678912, 0.123456789012345678901234567890123456789, 12345678901234567890, 1234567890.12345678901, 0.12345678901234567891);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (-123456789012345678901234567890123456789, -12345678901234567890123456789.12345678912, -0.123456789012345678901234567890123456789, -12345678901234567890, -1234567890.12345678901, -0.12345678901234567891);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, 1.12345678919, 0.123456789012345678901234567890123456789, 0, 1.12345678919, 0.12345678901234567899);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, 1.12345678914, 0.123456789012345678901234567890123456784, 0, 1.12345678914, 0.12345678901234567894);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, 1.99999999999, 0.999999999999999999999999999999999999999, 0, 1.99999999999, 0.99999999999999999999);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, 1.99999999994, 0.999999999999999999999999999999999999994, 0, 1.99999999994, 0.99999999999999999994);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, -1.12345678919, -0.123456789012345678901234567890123456789, 0, -1.12345678919, -0.12345678901234567899);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, -1.12345678914, -0.123456789012345678901234567890123456784, 0, -1.12345678914, -0.12345678901234567894);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, -1.99999999999, -0.999999999999999999999999999999999999999, 0, -1.99999999999, -0.99999999999999999999);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, -1.99999999994, -0.999999999999999999999999999999999999994, 0, -1.99999999994, -0.99999999999999999994);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, 1.0000000009, 0.00000000000000000000000000000000000009, 0, 1.0000000009, 0.0000000000000000009);
INSERT INTO cs1 VALUES (0, 1.00000000009, 0.000000000000000000000000000000000000009, 0, 1.00000000009, 0.00000000000000000009);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, -1.0000000009, -0.00000000000000000000000000000000000009, 0, -1.0000000009, -0.0000000000000000009);
INSERT INTO cs1 VALUES (0, -1.00000000009, -0.000000000000000000000000000000000000009, 0, -1.00000000009, -0.00000000000000000009);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs1 VALUES (0, 0, 0, 0, 0, 0);
INSERT INTO cs1 VALUES (NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO cs1 VALUES ();
SELECT "test1", d1, d2, d3, d4, d5, d6 FROM cs1;
test1 d1 d2 d3 d4 d5 d6
test1 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
test1 -125 -1.2500000000 -0.12500000000000000000000000000000000000 -125 -1.2500000000 -0.1250000000000000000
test1 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
test1 -1 -125.0000000000 -0.99999999999999999999999999999999999999 -1 -125.0000000000 -0.9999999999999999999
test1 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
test1 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
test1 -99999999999999999999999999999999999998 -9999999999999999999999999999.9999999998 -0.99999999999999999999999999999999999998 -9999999999999999998 -999999999.9999999998 -0.9999999999999999998
test1 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.99999999999999999999999999999999999999 -9999999999999999999 -999999999.9999999999 -0.9999999999999999999
test1 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
test1 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.12345678901234567890123456789012345679 -9999999999999999999 -999999999.9999999999 -0.1234567890123456789
test1 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
test1 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
test1 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
test1 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
test1 0 -1.1234567892 -0.12345678901234567890123456789012345679 0 -1.1234567892 -0.1234567890123456790
test1 0 -1.1234567891 -0.12345678901234567890123456789012345678 0 -1.1234567891 -0.1234567890123456789
test1 0 -2.0000000000 -0.99999999999999999999999999999999999999 0 -2.0000000000 -0.9999999999999999999
test1 0 -1.9999999999 -0.99999999999999999999999999999999999999 0 -1.9999999999 -0.9999999999999999999
test1 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
test1 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
test1 0 -1.0000000009 -0.00000000000000000000000000000000000009 0 -1.0000000009 -0.0000000000000000009
test1 0 -1.0000000001 -0.00000000000000000000000000000000000001 0 -1.0000000001 -0.0000000000000000001
test1 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test1 NULL NULL NULL NULL NULL NULL
test1 NULL NULL NULL NULL NULL NULL
DROP TABLE IF EXISTS cs1;
CREATE TABLE cs1 (d1 DECIMAL(38), d2 DECIMAL(38,10), d3 DECIMAL(38,38),
d4 DECIMAL(19), d5 DECIMAL(19,10), d6 DECIMAL(19,19)) ENGINE=columnstore;
INSERT INTO cs1 VALUES (125, 1.25, 0.125, 125, 1.25, 0.125),
(-125, -1.25, -0.125, -125, -1.25, -0.125),
(1.25, 125, 125, 1.25, 125, 125),
(-1.25, -125, -125, -1.25, -125, -125);
Warnings:
Note 1265 Data truncated for column 'd1' at row 3
Warning 1264 Out of range value for column 'd3' at row 3
Note 1265 Data truncated for column 'd4' at row 3
Warning 1264 Out of range value for column 'd6' at row 3
Note 1265 Data truncated for column 'd1' at row 4
Warning 1264 Out of range value for column 'd3' at row 4
Note 1265 Data truncated for column 'd4' at row 4
Warning 1264 Out of range value for column 'd6' at row 4
INSERT INTO cs1 values (99999999999999999999999999999999999998, 9999999999999999999999999999.9999999998, 0.99999999999999999999999999999999999998, 9999999999999999998, 999999999.9999999998, 0.9999999999999999998),
(99999999999999999999999999999999999999, 9999999999999999999999999999.9999999999, 0.99999999999999999999999999999999999999, 9999999999999999999, 999999999.9999999999, 0.9999999999999999999),
(-99999999999999999999999999999999999998, -9999999999999999999999999999.9999999998, -0.99999999999999999999999999999999999998, -9999999999999999998, -999999999.9999999998, -0.9999999999999999998),
(-99999999999999999999999999999999999999, -9999999999999999999999999999.9999999999, -0.99999999999999999999999999999999999999, -9999999999999999999, -999999999.9999999999, -0.9999999999999999999);
INSERT INTO cs1 VALUES (123456789012345678901234567890123456789, 12345678901234567890123456789.12345678912, 0.123456789012345678901234567890123456789, 12345678901234567890, 1234567890.12345678901, 0.12345678901234567891),
(-123456789012345678901234567890123456789, -12345678901234567890123456789.12345678912, -0.123456789012345678901234567890123456789, -12345678901234567890, -1234567890.12345678901, -0.12345678901234567891);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
Warning 1264 Out of range value for column 'd1' at row 2
Warning 1264 Out of range value for column 'd2' at row 2
Note 1265 Data truncated for column 'd3' at row 2
Warning 1264 Out of range value for column 'd4' at row 2
Warning 1264 Out of range value for column 'd5' at row 2
Note 1265 Data truncated for column 'd6' at row 2
INSERT INTO cs1 VALUES (0, 1.12345678919, 0.123456789012345678901234567890123456789, 0, 1.12345678919, 0.12345678901234567899),
(0, 1.12345678914, 0.123456789012345678901234567890123456784, 0, 1.12345678914, 0.12345678901234567894),
(0, 1.99999999999, 0.999999999999999999999999999999999999999, 0, 1.99999999999, 0.99999999999999999999),
(0, 1.99999999994, 0.999999999999999999999999999999999999994, 0, 1.99999999994, 0.99999999999999999994),
(0, -1.12345678919, -0.123456789012345678901234567890123456789, 0, -1.12345678919, -0.12345678901234567899),
(0, -1.12345678914, -0.123456789012345678901234567890123456784, 0, -1.12345678914, -0.12345678901234567894),
(0, -1.99999999999, -0.999999999999999999999999999999999999999, 0, -1.99999999999, -0.99999999999999999999),
(0, -1.99999999994, -0.999999999999999999999999999999999999994, 0, -1.99999999994, -0.99999999999999999994);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
Note 1265 Data truncated for column 'd2' at row 2
Note 1265 Data truncated for column 'd3' at row 2
Note 1265 Data truncated for column 'd5' at row 2
Note 1265 Data truncated for column 'd6' at row 2
Note 1265 Data truncated for column 'd2' at row 3
Warning 1264 Out of range value for column 'd3' at row 3
Note 1265 Data truncated for column 'd5' at row 3
Warning 1264 Out of range value for column 'd6' at row 3
Note 1265 Data truncated for column 'd2' at row 4
Note 1265 Data truncated for column 'd3' at row 4
Note 1265 Data truncated for column 'd5' at row 4
Note 1265 Data truncated for column 'd6' at row 4
Note 1265 Data truncated for column 'd2' at row 5
Note 1265 Data truncated for column 'd3' at row 5
Note 1265 Data truncated for column 'd5' at row 5
Note 1265 Data truncated for column 'd6' at row 5
Note 1265 Data truncated for column 'd2' at row 6
Note 1265 Data truncated for column 'd3' at row 6
Note 1265 Data truncated for column 'd5' at row 6
Note 1265 Data truncated for column 'd6' at row 6
Note 1265 Data truncated for column 'd2' at row 7
Warning 1264 Out of range value for column 'd3' at row 7
Note 1265 Data truncated for column 'd5' at row 7
Warning 1264 Out of range value for column 'd6' at row 7
Note 1265 Data truncated for column 'd2' at row 8
Note 1265 Data truncated for column 'd3' at row 8
Note 1265 Data truncated for column 'd5' at row 8
Note 1265 Data truncated for column 'd6' at row 8
INSERT INTO cs1 VALUES (0, 1.0000000009, 0.00000000000000000000000000000000000009, 0, 1.0000000009, 0.0000000000000000009),
(0, 1.00000000009, 0.000000000000000000000000000000000000009, 0, 1.00000000009, 0.00000000000000000009),
(0, -1.0000000009, -0.00000000000000000000000000000000000009, 0, -1.0000000009, -0.0000000000000000009),
(0, -1.00000000009, -0.000000000000000000000000000000000000009, 0, -1.00000000009, -0.00000000000000000009);
Warnings:
Note 1265 Data truncated for column 'd2' at row 2
Note 1265 Data truncated for column 'd3' at row 2
Note 1265 Data truncated for column 'd5' at row 2
Note 1265 Data truncated for column 'd6' at row 2
Note 1265 Data truncated for column 'd2' at row 4
Note 1265 Data truncated for column 'd3' at row 4
Note 1265 Data truncated for column 'd5' at row 4
Note 1265 Data truncated for column 'd6' at row 4
INSERT INTO cs1 VALUES (0, 0, 0, 0, 0, 0),
(NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO cs1 VALUES (12345678901234567890123456789000000001, 1234567890123456789012345678.0010000008, 0.00001000000000000000000000000000000009, 1234567890120000001, 123456789.0020000009, 0.0000000070000000009),
(-12345678901234567890123456789000000001, -1234567890123456789012345678.0010000008, -0.00001000000000000000000000000000000009, -1234567890120000001, -123456789.0020000009, -0.0000000070000000009);
SELECT "test2", d1, d2, d3, d4, d5, d6 FROM cs1;
test2 d1 d2 d3 d4 d5 d6
test2 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
test2 -125 -1.2500000000 -0.12500000000000000000000000000000000000 -125 -1.2500000000 -0.1250000000000000000
test2 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
test2 -1 -125.0000000000 -0.99999999999999999999999999999999999999 -1 -125.0000000000 -0.9999999999999999999
test2 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
test2 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
test2 -99999999999999999999999999999999999998 -9999999999999999999999999999.9999999998 -0.99999999999999999999999999999999999998 -9999999999999999998 -999999999.9999999998 -0.9999999999999999998
test2 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.99999999999999999999999999999999999999 -9999999999999999999 -999999999.9999999999 -0.9999999999999999999
test2 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
test2 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.12345678901234567890123456789012345679 -9999999999999999999 -999999999.9999999999 -0.1234567890123456789
test2 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
test2 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
test2 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
test2 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
test2 0 -1.1234567892 -0.12345678901234567890123456789012345679 0 -1.1234567892 -0.1234567890123456790
test2 0 -1.1234567891 -0.12345678901234567890123456789012345678 0 -1.1234567891 -0.1234567890123456789
test2 0 -2.0000000000 -0.99999999999999999999999999999999999999 0 -2.0000000000 -0.9999999999999999999
test2 0 -1.9999999999 -0.99999999999999999999999999999999999999 0 -1.9999999999 -0.9999999999999999999
test2 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
test2 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
test2 0 -1.0000000009 -0.00000000000000000000000000000000000009 0 -1.0000000009 -0.0000000000000000009
test2 0 -1.0000000001 -0.00000000000000000000000000000000000001 0 -1.0000000001 -0.0000000000000000001
test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test2 NULL NULL NULL NULL NULL NULL
test2 12345678901234567890123456789000000001 1234567890123456789012345678.0010000008 0.00001000000000000000000000000000000009 1234567890120000001 123456789.0020000009 0.0000000070000000009
test2 -12345678901234567890123456789000000001 -1234567890123456789012345678.0010000008 -0.00001000000000000000000000000000000009 -1234567890120000001 -123456789.0020000009 -0.0000000070000000009
INSERT INTO cs3 SELECT * FROM cs1;
SELECT "insert_select_test1", d1, d2, d3, d4, d5, d6 FROM cs3;
insert_select_test1 d1 d2 d3 d4 d5 d6
insert_select_test1 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
insert_select_test1 -125 -1.2500000000 -0.12500000000000000000000000000000000000 -125 -1.2500000000 -0.1250000000000000000
insert_select_test1 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
insert_select_test1 -1 -125.0000000000 -0.99999999999999999999999999999999999999 -1 -125.0000000000 -0.9999999999999999999
insert_select_test1 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
insert_select_test1 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
insert_select_test1 -99999999999999999999999999999999999998 -9999999999999999999999999999.9999999998 -0.99999999999999999999999999999999999998 -9999999999999999998 -999999999.9999999998 -0.9999999999999999998
insert_select_test1 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.99999999999999999999999999999999999999 -9999999999999999999 -999999999.9999999999 -0.9999999999999999999
insert_select_test1 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
insert_select_test1 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.12345678901234567890123456789012345679 -9999999999999999999 -999999999.9999999999 -0.1234567890123456789
insert_select_test1 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
insert_select_test1 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
insert_select_test1 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
insert_select_test1 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
insert_select_test1 0 -1.1234567892 -0.12345678901234567890123456789012345679 0 -1.1234567892 -0.1234567890123456790
insert_select_test1 0 -1.1234567891 -0.12345678901234567890123456789012345678 0 -1.1234567891 -0.1234567890123456789
insert_select_test1 0 -2.0000000000 -0.99999999999999999999999999999999999999 0 -2.0000000000 -0.9999999999999999999
insert_select_test1 0 -1.9999999999 -0.99999999999999999999999999999999999999 0 -1.9999999999 -0.9999999999999999999
insert_select_test1 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
insert_select_test1 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
insert_select_test1 0 -1.0000000009 -0.00000000000000000000000000000000000009 0 -1.0000000009 -0.0000000000000000009
insert_select_test1 0 -1.0000000001 -0.00000000000000000000000000000000000001 0 -1.0000000001 -0.0000000000000000001
insert_select_test1 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test1 NULL NULL NULL NULL NULL NULL
insert_select_test1 12345678901234567890123456789000000001 1234567890123456789012345678.0010000008 0.00001000000000000000000000000000000009 1234567890120000001 123456789.0020000009 0.0000000070000000009
insert_select_test1 -12345678901234567890123456789000000001 -1234567890123456789012345678.0010000008 -0.00001000000000000000000000000000000009 -1234567890120000001 -123456789.0020000009 -0.0000000070000000009
SELECT * FROM cs3 INTO OUTFILE '/tmp/wide_decimal_ldi.txt' FIELDS TERMINATED BY ',';
Warnings:
Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
DELETE FROM cs3;
LOAD DATA LOCAL INFILE '/tmp/wide_decimal_ldi.txt' INTO TABLE cs3 FIELDS TERMINATED BY ',';
SELECT "ldi_test1", d1, d2, d3, d4, d5, d6 FROM cs3;
ldi_test1 d1 d2 d3 d4 d5 d6
ldi_test1 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
ldi_test1 -125 -1.2500000000 -0.12500000000000000000000000000000000000 -125 -1.2500000000 -0.1250000000000000000
ldi_test1 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
ldi_test1 -1 -125.0000000000 -0.99999999999999999999999999999999999999 -1 -125.0000000000 -0.9999999999999999999
ldi_test1 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
ldi_test1 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
ldi_test1 -99999999999999999999999999999999999998 -9999999999999999999999999999.9999999998 -0.99999999999999999999999999999999999998 -9999999999999999998 -999999999.9999999998 -0.9999999999999999998
ldi_test1 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.99999999999999999999999999999999999999 -9999999999999999999 -999999999.9999999999 -0.9999999999999999999
ldi_test1 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
ldi_test1 -99999999999999999999999999999999999999 -9999999999999999999999999999.9999999999 -0.12345678901234567890123456789012345679 -9999999999999999999 -999999999.9999999999 -0.1234567890123456789
ldi_test1 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
ldi_test1 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
ldi_test1 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
ldi_test1 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
ldi_test1 0 -1.1234567892 -0.12345678901234567890123456789012345679 0 -1.1234567892 -0.1234567890123456790
ldi_test1 0 -1.1234567891 -0.12345678901234567890123456789012345678 0 -1.1234567891 -0.1234567890123456789
ldi_test1 0 -2.0000000000 -0.99999999999999999999999999999999999999 0 -2.0000000000 -0.9999999999999999999
ldi_test1 0 -1.9999999999 -0.99999999999999999999999999999999999999 0 -1.9999999999 -0.9999999999999999999
ldi_test1 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
ldi_test1 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
ldi_test1 0 -1.0000000009 -0.00000000000000000000000000000000000009 0 -1.0000000009 -0.0000000000000000009
ldi_test1 0 -1.0000000001 -0.00000000000000000000000000000000000001 0 -1.0000000001 -0.0000000000000000001
ldi_test1 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test1 NULL NULL NULL NULL NULL NULL
ldi_test1 12345678901234567890123456789000000001 1234567890123456789012345678.0010000008 0.00001000000000000000000000000000000009 1234567890120000001 123456789.0020000009 0.0000000070000000009
ldi_test1 -12345678901234567890123456789000000001 -1234567890123456789012345678.0010000008 -0.00001000000000000000000000000000000009 -1234567890120000001 -123456789.0020000009 -0.0000000070000000009
INSERT INTO cs2 VALUES (125, 1.25, 0.125, 125, 1.25, 0.125);
INSERT INTO cs2 VALUES (-125, -1.25, -0.125, -125, -1.25, -0.125);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (1.25, 125, 125, 1.25, 125, 125);
Warnings:
Note 1265 Data truncated for column 'd1' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Note 1265 Data truncated for column 'd4' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (-1.25, -125, -125, -1.25, -125, -125);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 values (99999999999999999999999999999999999998, 9999999999999999999999999999.9999999998, 0.99999999999999999999999999999999999998, 9999999999999999998, 999999999.9999999998, 0.9999999999999999998);
INSERT INTO cs2 values (99999999999999999999999999999999999999, 9999999999999999999999999999.9999999999, 0.99999999999999999999999999999999999999, 9999999999999999999, 999999999.9999999999, 0.9999999999999999999);
INSERT INTO cs2 values (-99999999999999999999999999999999999998, -9999999999999999999999999999.9999999998, -0.99999999999999999999999999999999999998, -9999999999999999998, -999999999.9999999998, -0.9999999999999999998);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 values (-99999999999999999999999999999999999999, -9999999999999999999999999999.9999999999, -0.99999999999999999999999999999999999999, -9999999999999999999, -999999999.9999999999, -0.9999999999999999999);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (123456789012345678901234567890123456789, 12345678901234567890123456789.12345678912, 0.123456789012345678901234567890123456789, 12345678901234567890, 1234567890.12345678901, 0.12345678901234567891);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs2 VALUES (-123456789012345678901234567890123456789, -12345678901234567890123456789.12345678912, -0.123456789012345678901234567890123456789, -12345678901234567890, -1234567890.12345678901, -0.12345678901234567891);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, 1.12345678919, 0.123456789012345678901234567890123456789, 0, 1.12345678919, 0.12345678901234567899);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, 1.12345678914, 0.123456789012345678901234567890123456784, 0, 1.12345678914, 0.12345678901234567894);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, 1.99999999999, 0.999999999999999999999999999999999999999, 0, 1.99999999999, 0.99999999999999999999);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, 1.99999999994, 0.999999999999999999999999999999999999994, 0, 1.99999999994, 0.99999999999999999994);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, -1.12345678919, -0.123456789012345678901234567890123456789, 0, -1.12345678919, -0.12345678901234567899);
Warnings:
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, -1.12345678914, -0.123456789012345678901234567890123456784, 0, -1.12345678914, -0.12345678901234567894);
Warnings:
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, -1.99999999999, -0.999999999999999999999999999999999999999, 0, -1.99999999999, -0.99999999999999999999);
Warnings:
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, -1.99999999994, -0.999999999999999999999999999999999999994, 0, -1.99999999994, -0.99999999999999999994);
Warnings:
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, 1.0000000009, 0.00000000000000000000000000000000000009, 0, 1.0000000009, 0.0000000000000000009);
INSERT INTO cs2 VALUES (0, 1.00000000009, 0.000000000000000000000000000000000000009, 0, 1.00000000009, 0.00000000000000000009);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, -1.0000000009, -0.00000000000000000000000000000000000009, 0, -1.0000000009, -0.0000000000000000009);
Warnings:
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, -1.00000000009, -0.000000000000000000000000000000000000009, 0, -1.00000000009, -0.00000000000000000009);
Warnings:
Warning 1264 Out of range value for column 'd2' at row 1
Warning 1264 Out of range value for column 'd3' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Warning 1264 Out of range value for column 'd6' at row 1
INSERT INTO cs2 VALUES (0, 0, 0, 0, 0, 0);
INSERT INTO cs2 VALUES (NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO cs2 VALUES ();
SELECT "test3", d1, d2, d3, d4, d5, d6 FROM cs2;
test3 d1 d2 d3 d4 d5 d6
test3 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
test3 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
test3 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
test3 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
test3 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
test3 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test3 NULL NULL NULL NULL NULL NULL
test3 NULL NULL NULL NULL NULL NULL
DROP TABLE IF EXISTS cs2;
CREATE TABLE cs2 (d1 DECIMAL(38) UNSIGNED, d2 DECIMAL(38,10) UNSIGNED, d3 DECIMAL(38,38) UNSIGNED,
d4 DECIMAL(19) UNSIGNED, d5 DECIMAL(19,10) UNSIGNED, d6 DECIMAL(19,19) UNSIGNED) ENGINE=columnstore;
INSERT INTO cs2 VALUES (125, 1.25, 0.125, 125, 1.25, 0.125),
(-125, -1.25, -0.125, -125, -1.25, -0.125),
(1.25, 125, 125, 1.25, 125, 125),
(-1.25, -125, -125, -1.25, -125, -125);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 2
Warning 1264 Out of range value for column 'd2' at row 2
Warning 1264 Out of range value for column 'd3' at row 2
Warning 1264 Out of range value for column 'd4' at row 2
Warning 1264 Out of range value for column 'd5' at row 2
Warning 1264 Out of range value for column 'd6' at row 2
Note 1265 Data truncated for column 'd1' at row 3
Warning 1264 Out of range value for column 'd3' at row 3
Note 1265 Data truncated for column 'd4' at row 3
Warning 1264 Out of range value for column 'd6' at row 3
Warning 1264 Out of range value for column 'd1' at row 4
Warning 1264 Out of range value for column 'd2' at row 4
Warning 1264 Out of range value for column 'd3' at row 4
Warning 1264 Out of range value for column 'd4' at row 4
Warning 1264 Out of range value for column 'd5' at row 4
Warning 1264 Out of range value for column 'd6' at row 4
INSERT INTO cs2 values (99999999999999999999999999999999999998, 9999999999999999999999999999.9999999998, 0.99999999999999999999999999999999999998, 9999999999999999998, 999999999.9999999998, 0.9999999999999999998),
(99999999999999999999999999999999999999, 9999999999999999999999999999.9999999999, 0.99999999999999999999999999999999999999, 9999999999999999999, 999999999.9999999999, 0.9999999999999999999),
(-99999999999999999999999999999999999998, -9999999999999999999999999999.9999999998, -0.99999999999999999999999999999999999998, -9999999999999999998, -999999999.9999999998, -0.9999999999999999998),
(-99999999999999999999999999999999999999, -9999999999999999999999999999.9999999999, -0.99999999999999999999999999999999999999, -9999999999999999999, -999999999.9999999999, -0.9999999999999999999);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 3
Warning 1264 Out of range value for column 'd2' at row 3
Warning 1264 Out of range value for column 'd3' at row 3
Warning 1264 Out of range value for column 'd4' at row 3
Warning 1264 Out of range value for column 'd5' at row 3
Warning 1264 Out of range value for column 'd6' at row 3
Warning 1264 Out of range value for column 'd1' at row 4
Warning 1264 Out of range value for column 'd2' at row 4
Warning 1264 Out of range value for column 'd3' at row 4
Warning 1264 Out of range value for column 'd4' at row 4
Warning 1264 Out of range value for column 'd5' at row 4
Warning 1264 Out of range value for column 'd6' at row 4
INSERT INTO cs2 VALUES (123456789012345678901234567890123456789, 12345678901234567890123456789.12345678912, 0.123456789012345678901234567890123456789, 12345678901234567890, 1234567890.12345678901, 0.12345678901234567891),
(-123456789012345678901234567890123456789, -12345678901234567890123456789.12345678912, -0.123456789012345678901234567890123456789, -12345678901234567890, -1234567890.12345678901, -0.12345678901234567891);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 1
Warning 1264 Out of range value for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Warning 1264 Out of range value for column 'd4' at row 1
Warning 1264 Out of range value for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
Warning 1264 Out of range value for column 'd1' at row 2
Warning 1264 Out of range value for column 'd2' at row 2
Warning 1264 Out of range value for column 'd3' at row 2
Warning 1264 Out of range value for column 'd4' at row 2
Warning 1264 Out of range value for column 'd5' at row 2
Warning 1264 Out of range value for column 'd6' at row 2
INSERT INTO cs2 VALUES (0, 1.12345678919, 0.123456789012345678901234567890123456789, 0, 1.12345678919, 0.12345678901234567899),
(0, 1.12345678914, 0.123456789012345678901234567890123456784, 0, 1.12345678914, 0.12345678901234567894),
(0, 1.99999999999, 0.999999999999999999999999999999999999999, 0, 1.99999999999, 0.99999999999999999999),
(0, 1.99999999994, 0.999999999999999999999999999999999999994, 0, 1.99999999994, 0.99999999999999999994),
(0, -1.12345678919, -0.123456789012345678901234567890123456789, 0, -1.12345678919, -0.12345678901234567899),
(0, -1.12345678914, -0.123456789012345678901234567890123456784, 0, -1.12345678914, -0.12345678901234567894),
(0, -1.99999999999, -0.999999999999999999999999999999999999999, 0, -1.99999999999, -0.99999999999999999999),
(0, -1.99999999994, -0.999999999999999999999999999999999999994, 0, -1.99999999994, -0.99999999999999999994);
Warnings:
Note 1265 Data truncated for column 'd2' at row 1
Note 1265 Data truncated for column 'd3' at row 1
Note 1265 Data truncated for column 'd5' at row 1
Note 1265 Data truncated for column 'd6' at row 1
Note 1265 Data truncated for column 'd2' at row 2
Note 1265 Data truncated for column 'd3' at row 2
Note 1265 Data truncated for column 'd5' at row 2
Note 1265 Data truncated for column 'd6' at row 2
Note 1265 Data truncated for column 'd2' at row 3
Warning 1264 Out of range value for column 'd3' at row 3
Note 1265 Data truncated for column 'd5' at row 3
Warning 1264 Out of range value for column 'd6' at row 3
Note 1265 Data truncated for column 'd2' at row 4
Note 1265 Data truncated for column 'd3' at row 4
Note 1265 Data truncated for column 'd5' at row 4
Note 1265 Data truncated for column 'd6' at row 4
Warning 1264 Out of range value for column 'd2' at row 5
Warning 1264 Out of range value for column 'd3' at row 5
Warning 1264 Out of range value for column 'd5' at row 5
Warning 1264 Out of range value for column 'd6' at row 5
Warning 1264 Out of range value for column 'd2' at row 6
Warning 1264 Out of range value for column 'd3' at row 6
Warning 1264 Out of range value for column 'd5' at row 6
Warning 1264 Out of range value for column 'd6' at row 6
Warning 1264 Out of range value for column 'd2' at row 7
Warning 1264 Out of range value for column 'd3' at row 7
Warning 1264 Out of range value for column 'd5' at row 7
Warning 1264 Out of range value for column 'd6' at row 7
Warning 1264 Out of range value for column 'd2' at row 8
Warning 1264 Out of range value for column 'd3' at row 8
Warning 1264 Out of range value for column 'd5' at row 8
Warning 1264 Out of range value for column 'd6' at row 8
INSERT INTO cs2 VALUES (0, 1.0000000009, 0.00000000000000000000000000000000000009, 0, 1.0000000009, 0.0000000000000000009),
(0, 1.00000000009, 0.000000000000000000000000000000000000009, 0, 1.00000000009, 0.00000000000000000009),
(0, -1.0000000009, -0.00000000000000000000000000000000000009, 0, -1.0000000009, -0.0000000000000000009),
(0, -1.00000000009, -0.000000000000000000000000000000000000009, 0, -1.00000000009, -0.00000000000000000009);
Warnings:
Note 1265 Data truncated for column 'd2' at row 2
Note 1265 Data truncated for column 'd3' at row 2
Note 1265 Data truncated for column 'd5' at row 2
Note 1265 Data truncated for column 'd6' at row 2
Warning 1264 Out of range value for column 'd2' at row 3
Warning 1264 Out of range value for column 'd3' at row 3
Warning 1264 Out of range value for column 'd5' at row 3
Warning 1264 Out of range value for column 'd6' at row 3
Warning 1264 Out of range value for column 'd2' at row 4
Warning 1264 Out of range value for column 'd3' at row 4
Warning 1264 Out of range value for column 'd5' at row 4
Warning 1264 Out of range value for column 'd6' at row 4
INSERT INTO cs2 VALUES (0, 0, 0, 0, 0, 0),
(NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO cs2 VALUES (12345678901234567890123456789000000001, 1234567890123456789012345678.0010000008, 0.00001000000000000000000000000000000009, 1234567890120000001, 123456789.0020000009, 0.0000000070000000009),
(-12345678901234567890123456789000000001, -1234567890123456789012345678.0010000008, -0.00001000000000000000000000000000000009, -1234567890120000001, -123456789.0020000009, -0.0000000070000000009);
Warnings:
Warning 1264 Out of range value for column 'd1' at row 2
Warning 1264 Out of range value for column 'd2' at row 2
Warning 1264 Out of range value for column 'd3' at row 2
Warning 1264 Out of range value for column 'd4' at row 2
Warning 1264 Out of range value for column 'd5' at row 2
Warning 1264 Out of range value for column 'd6' at row 2
SELECT "test4", d1, d2, d3, d4, d5, d6 FROM cs2;
test4 d1 d2 d3 d4 d5 d6
test4 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
test4 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
test4 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
test4 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
test4 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
test4 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
test4 NULL NULL NULL NULL NULL NULL
test4 12345678901234567890123456789000000001 1234567890123456789012345678.0010000008 0.00001000000000000000000000000000000009 1234567890120000001 123456789.0020000009 0.0000000070000000009
test4 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
INSERT INTO cs4 SELECT * FROM cs2;
SELECT "insert_select_test2", d1, d2, d3, d4, d5, d6 FROM cs4;
insert_select_test2 d1 d2 d3 d4 d5 d6
insert_select_test2 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
insert_select_test2 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
insert_select_test2 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
insert_select_test2 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
insert_select_test2 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
insert_select_test2 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
insert_select_test2 NULL NULL NULL NULL NULL NULL
insert_select_test2 12345678901234567890123456789000000001 1234567890123456789012345678.0010000008 0.00001000000000000000000000000000000009 1234567890120000001 123456789.0020000009 0.0000000070000000009
insert_select_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
SELECT * FROM cs4 INTO OUTFILE '/tmp/wide_decimal_ldi.txt' FIELDS TERMINATED BY ',';
Warnings:
Warning 1287 '<select expression> INTO <destination>;' is deprecated and will be removed in a future release. Please use 'SELECT <select list> INTO <destination> FROM...' instead
DELETE FROM cs4;
LOAD DATA LOCAL INFILE '/tmp/wide_decimal_ldi.txt' INTO TABLE cs4 FIELDS TERMINATED BY ',';
SELECT "ldi_test2", d1, d2, d3, d4, d5, d6 FROM cs4;
ldi_test2 d1 d2 d3 d4 d5 d6
ldi_test2 125 1.2500000000 0.12500000000000000000000000000000000000 125 1.2500000000 0.1250000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 1 125.0000000000 0.99999999999999999999999999999999999999 1 125.0000000000 0.9999999999999999999
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 99999999999999999999999999999999999998 9999999999999999999999999999.9999999998 0.99999999999999999999999999999999999998 9999999999999999998 999999999.9999999998 0.9999999999999999998
ldi_test2 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.99999999999999999999999999999999999999 9999999999999999999 999999999.9999999999 0.9999999999999999999
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 99999999999999999999999999999999999999 9999999999999999999999999999.9999999999 0.12345678901234567890123456789012345679 9999999999999999999 999999999.9999999999 0.1234567890123456789
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 1.1234567892 0.12345678901234567890123456789012345679 0 1.1234567892 0.1234567890123456790
ldi_test2 0 1.1234567891 0.12345678901234567890123456789012345678 0 1.1234567891 0.1234567890123456789
ldi_test2 0 2.0000000000 0.99999999999999999999999999999999999999 0 2.0000000000 0.9999999999999999999
ldi_test2 0 1.9999999999 0.99999999999999999999999999999999999999 0 1.9999999999 0.9999999999999999999
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 1.0000000009 0.00000000000000000000000000000000000009 0 1.0000000009 0.0000000000000000009
ldi_test2 0 1.0000000001 0.00000000000000000000000000000000000001 0 1.0000000001 0.0000000000000000001
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
ldi_test2 NULL NULL NULL NULL NULL NULL
ldi_test2 12345678901234567890123456789000000001 1234567890123456789012345678.0010000008 0.00001000000000000000000000000000000009 1234567890120000001 123456789.0020000009 0.0000000070000000009
ldi_test2 0 0.0000000000 0.00000000000000000000000000000000000000 0 0.0000000000 0.0000000000000000000
SET SQL_MODE=default;
DROP DATABASE mcol641_insert_db;
View Git Blame Copy Permalink