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