1DROP TABLE IF EXISTS t1;
2CREATE TABLE t1 (
3d DECIMAL ,
4d0 DECIMAL(0) ,
5d1_1 DECIMAL(1,1) ,
6d10_2 DECIMAL(10,2) ,
7d60_10 DECIMAL(60,10) ,
8n NUMERIC ,
9n0_0 NUMERIC(0,0) ,
10n1 NUMERIC(1) ,
11n20_4 NUMERIC(20,4) ,
12n65_4 NUMERIC(65,4) ,
13pk NUMERIC  PRIMARY KEY
14) ENGINE=rocksdb;
15SHOW COLUMNS IN t1;
16Field	Type	Null	Key	Default	Extra
17d	decimal(10,0)	YES		NULL
18d0	decimal(10,0)	YES		NULL
19d1_1	decimal(1,1)	YES		NULL
20d10_2	decimal(10,2)	YES		NULL
21d60_10	decimal(60,10)	YES		NULL
22n	decimal(10,0)	YES		NULL
23n0_0	decimal(10,0)	YES		NULL
24n1	decimal(1,0)	YES		NULL
25n20_4	decimal(20,4)	YES		NULL
26n65_4	decimal(65,4)	YES		NULL
27pk	decimal(10,0)	NO	PRI	NULL
28INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (100,123456,0.3,40000.25,123456789123456789.10001,1024,7000.0,8.0,999999.9,9223372036854775807,1);
29INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (0,0,0,0,0,0,0,0,0,0,2);
30INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (9999999999.0,9999999999.0,0.9,99999999.99,99999999999999999999999999999999999999999999999999.9999999999,9999999999.0,9999999999.0,9.0,9999999999999999.9999,9999999999999999999999999999999999999999999999999999999999999.9999,3);
31SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
32d	d0	d1_1	d10_2	d60_10	n	n0_0	n1	n20_4	n65_4
330	0	0.0	0.00	0.0000000000	0	0	0	0.0000	0.0000
34100	123456	0.3	40000.25	123456789123456789.1000100000	1024	7000	8	999999.9000	9223372036854775807.0000
359999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
36INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (-100,-123456,-0.3,-40000.25,-123456789123456789.10001,-1024,-7000.0,-8.0,-999999.9,-9223372036854775807,4);
37INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (-9999999999.0,-9999999999.0,-0.9,-99999999.99,-99999999999999999999999999999999999999999999999999.9999999999,-9999999999.0,-9999999999.0,-9.0,-9999999999999999.9999,-9999999999999999999999999999999999999999999999999999999999999.9999,5);
38SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
39d	d0	d1_1	d10_2	d60_10	n	n0_0	n1	n20_4	n65_4
40-100	-123456	-0.3	-40000.25	-123456789123456789.1000100000	-1024	-7000	-8	-999999.9000	-9223372036854775807.0000
41-9999999999	-9999999999	-0.9	-99999999.99	-99999999999999999999999999999999999999999999999999.9999999999	-9999999999	-9999999999	-9	-9999999999999999.9999	-9999999999999999999999999999999999999999999999999999999999999.9999
420	0	0.0	0.00	0.0000000000	0	0	0	0.0000	0.0000
43100	123456	0.3	40000.25	123456789123456789.1000100000	1024	7000	8	999999.9000	9223372036854775807.0000
449999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
45SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1 WHERE n20_4 = 9999999999999999.9999 OR d < 100;
46d	d0	d1_1	d10_2	d60_10	n	n0_0	n1	n20_4	n65_4
47-100	-123456	-0.3	-40000.25	-123456789123456789.1000100000	-1024	-7000	-8	-999999.9000	-9223372036854775807.0000
48-9999999999	-9999999999	-0.9	-99999999.99	-99999999999999999999999999999999999999999999999999.9999999999	-9999999999	-9999999999	-9	-9999999999999999.9999	-9999999999999999999999999999999999999999999999999999999999999.9999
490	0	0.0	0.00	0.0000000000	0	0	0	0.0000	0.0000
509999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
51INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (
529999999999999999999999999999999999999999999999999999999999999.9999,
539999999999999999999999999999999999999999999999999999999999999.9999,
549999999999999999999999999999999999999999999999999999999999999.9999,
559999999999999999999999999999999999999999999999999999999999999.9999,
569999999999999999999999999999999999999999999999999999999999999.9999,
579999999999999999999999999999999999999999999999999999999999999.9999,
589999999999999999999999999999999999999999999999999999999999999.9999,
599999999999999999999999999999999999999999999999999999999999999.9999,
609999999999999999999999999999999999999999999999999999999999999.9999,
619999999999999999999999999999999999999999999999999999999999999.9999,
626
63);
64Warnings:
65Warning	1264	Out of range value for column 'd' at row 1
66Warning	1264	Out of range value for column 'd0' at row 1
67Warning	1264	Out of range value for column 'd1_1' at row 1
68Warning	1264	Out of range value for column 'd10_2' at row 1
69Warning	1264	Out of range value for column 'd60_10' at row 1
70Warning	1264	Out of range value for column 'n' at row 1
71Warning	1264	Out of range value for column 'n0_0' at row 1
72Warning	1264	Out of range value for column 'n1' at row 1
73Warning	1264	Out of range value for column 'n20_4' at row 1
74SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
75d	d0	d1_1	d10_2	d60_10	n	n0_0	n1	n20_4	n65_4
76-100	-123456	-0.3	-40000.25	-123456789123456789.1000100000	-1024	-7000	-8	-999999.9000	-9223372036854775807.0000
77-9999999999	-9999999999	-0.9	-99999999.99	-99999999999999999999999999999999999999999999999999.9999999999	-9999999999	-9999999999	-9	-9999999999999999.9999	-9999999999999999999999999999999999999999999999999999999999999.9999
780	0	0.0	0.00	0.0000000000	0	0	0	0.0000	0.0000
79100	123456	0.3	40000.25	123456789123456789.1000100000	1024	7000	8	999999.9000	9223372036854775807.0000
809999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
819999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
82INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (10000000000.0,10000000000.0,1.1,100000000.99,100000000000000000000000000000000000000000000000000.0,10000000000.0,10000000000.0,10.0,10000000000000000.9999,10000000000000000000000000000000000000000000000000000000000000.9999,7);
83Warnings:
84Warning	1264	Out of range value for column 'd' at row 1
85Warning	1264	Out of range value for column 'd0' at row 1
86Warning	1264	Out of range value for column 'd1_1' at row 1
87Warning	1264	Out of range value for column 'd10_2' at row 1
88Warning	1264	Out of range value for column 'd60_10' at row 1
89Warning	1264	Out of range value for column 'n' at row 1
90Warning	1264	Out of range value for column 'n0_0' at row 1
91Warning	1264	Out of range value for column 'n1' at row 1
92Warning	1264	Out of range value for column 'n20_4' at row 1
93Warning	1264	Out of range value for column 'n65_4' at row 1
94SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
95d	d0	d1_1	d10_2	d60_10	n	n0_0	n1	n20_4	n65_4
96-100	-123456	-0.3	-40000.25	-123456789123456789.1000100000	-1024	-7000	-8	-999999.9000	-9223372036854775807.0000
97-9999999999	-9999999999	-0.9	-99999999.99	-99999999999999999999999999999999999999999999999999.9999999999	-9999999999	-9999999999	-9	-9999999999999999.9999	-9999999999999999999999999999999999999999999999999999999999999.9999
980	0	0.0	0.00	0.0000000000	0	0	0	0.0000	0.0000
99100	123456	0.3	40000.25	123456789123456789.1000100000	1024	7000	8	999999.9000	9223372036854775807.0000
1009999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
1019999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
1029999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
103INSERT INTO t1 (d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4,pk) VALUES (9999999999.1,9999999999.1,1.9,99999999.001,99999999999999999999999999999999999999999999999999.99999999991,9999999999.1,9999999999.1,9.1,9999999999999999.00001,9999999999999999999999999999999999999999999999999999999999999.11111,8);
104Warnings:
105Note	1265	Data truncated for column 'd' at row 1
106Note	1265	Data truncated for column 'd0' at row 1
107Warning	1264	Out of range value for column 'd1_1' at row 1
108Note	1265	Data truncated for column 'd10_2' at row 1
109Note	1265	Data truncated for column 'd60_10' at row 1
110Note	1265	Data truncated for column 'n' at row 1
111Note	1265	Data truncated for column 'n0_0' at row 1
112Note	1265	Data truncated for column 'n1' at row 1
113Note	1265	Data truncated for column 'n20_4' at row 1
114Note	1265	Data truncated for column 'n65_4' at row 1
115SELECT d,d0,d1_1,d10_2,d60_10,n,n0_0,n1,n20_4,n65_4 FROM t1;
116d	d0	d1_1	d10_2	d60_10	n	n0_0	n1	n20_4	n65_4
117-100	-123456	-0.3	-40000.25	-123456789123456789.1000100000	-1024	-7000	-8	-999999.9000	-9223372036854775807.0000
118-9999999999	-9999999999	-0.9	-99999999.99	-99999999999999999999999999999999999999999999999999.9999999999	-9999999999	-9999999999	-9	-9999999999999999.9999	-9999999999999999999999999999999999999999999999999999999999999.9999
1190	0	0.0	0.00	0.0000000000	0	0	0	0.0000	0.0000
120100	123456	0.3	40000.25	123456789123456789.1000100000	1024	7000	8	999999.9000	9223372036854775807.0000
1219999999999	9999999999	0.9	99999999.00	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.0000	9999999999999999999999999999999999999999999999999999999999999.1111
1229999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
1239999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
1249999999999	9999999999	0.9	99999999.99	99999999999999999999999999999999999999999999999999.9999999999	9999999999	9999999999	9	9999999999999999.9999	9999999999999999999999999999999999999999999999999999999999999.9999
125ALTER TABLE t1 ADD COLUMN n66 NUMERIC(66) ;
126ERROR 42000: Too big precision 66 specified for 'n66'. Maximum is 65
127ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(66,6) ;
128ERROR 42000: Too big precision 66 specified for 'n66_6'. Maximum is 65
129ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(66,66) ;
130ERROR 42000: Too big scale 66 specified for 'n66_66'. Maximum is 38
131DROP TABLE t1;
132