You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-11-03 17:13:17 +03:00
689 lines
55 KiB
Plaintext
689 lines
55 KiB
Plaintext
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 * INTO OUTFILE '/tmp/wide_decimal_ldi.txt' FIELDS TERMINATED BY ',' FROM cs3;
|
|
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 * INTO OUTFILE '/tmp/wide_decimal_ldi.txt' FIELDS TERMINATED BY ',' FROM cs4;
|
|
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;
|