diff options
| author | Alexander Barkov <bar@mariadb.com> | 2022-02-09 17:59:38 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.com> | 2022-03-22 14:42:54 +0400 |
| commit | d25b10fede8926f63203dfd2040ec60549d10936 (patch) | |
| tree | 3e9b0da676e1a3e54f562d9f7e9552fc2ebdcdb3 /storage/rocksdb | |
| parent | ab1a7925714727743e5dd7bb1b83014044fc5660 (diff) | |
| download | mariadb-git-d25b10fede8926f63203dfd2040ec60549d10936.tar.gz | |
MDEV-27712 Reduce the size of Lex_length_and_dec_st from 16 to 8
User visible change:
Removing the length specified by user from error messages:
ER_TOO_BIG_SCALE and ER_TOO_BIG_PRECISION
as discussed with Sergei.
Diffstat (limited to 'storage/rocksdb')
5 files changed, 16 insertions, 16 deletions
diff --git a/storage/rocksdb/mysql-test/rocksdb/r/col_opt_not_null.result b/storage/rocksdb/mysql-test/rocksdb/r/col_opt_not_null.result index a3a138555ee..4a1fc17395d 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/col_opt_not_null.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/col_opt_not_null.result @@ -1423,11 +1423,11 @@ d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 ALTER TABLE t1 ADD COLUMN n66 NUMERIC(66) NOT NULL; -ERROR 42000: Too big precision 66 specified for 'n66'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(66,6) NOT NULL; -ERROR 42000: Too big precision 66 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(66,66) NOT NULL; -ERROR 42000: Too big scale 66 specified for 'n66_66'. Maximum is 38 +ERROR 42000: Too big scale specified for 'n66_66'. Maximum is 38 DROP TABLE t1; DROP TABLE IF EXISTS t1; #---------------------------------- @@ -1825,7 +1825,7 @@ r1_1 0.9 r1_1 0.9 ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0) NOT NULL; ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(256,1) NOT NULL; -ERROR 42000: Too big precision 256 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(40,35) NOT NULL; DROP TABLE t1; DROP TABLE IF EXISTS t1; diff --git a/storage/rocksdb/mysql-test/rocksdb/r/col_opt_null.result b/storage/rocksdb/mysql-test/rocksdb/r/col_opt_null.result index f0d377890c5..d97fb8a2481 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/col_opt_null.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/col_opt_null.result @@ -1232,11 +1232,11 @@ d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 ALTER TABLE t1 ADD COLUMN n66 NUMERIC(66) NULL; -ERROR 42000: Too big precision 66 specified for 'n66'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(66,6) NULL; -ERROR 42000: Too big precision 66 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(66,66) NULL; -ERROR 42000: Too big scale 66 specified for 'n66_66'. Maximum is 38 +ERROR 42000: Too big scale specified for 'n66_66'. Maximum is 38 DROP TABLE t1; DROP TABLE IF EXISTS t1; CREATE TABLE t1 ( @@ -1612,7 +1612,7 @@ r1_1 0.9 r1_1 0.9 ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0) NULL; ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(256,1) NULL; -ERROR 42000: Too big precision 256 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(40,35) NULL; DROP TABLE t1; DROP TABLE IF EXISTS t1; diff --git a/storage/rocksdb/mysql-test/rocksdb/r/col_opt_unsigned.result b/storage/rocksdb/mysql-test/rocksdb/r/col_opt_unsigned.result index 13445fc9326..0a8f49ebf36 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/col_opt_unsigned.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/col_opt_unsigned.result @@ -148,11 +148,11 @@ d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 ALTER TABLE t1 ADD COLUMN n66 NUMERIC(66) UNSIGNED; -ERROR 42000: Too big precision 66 specified for 'n66'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(66,6) UNSIGNED; -ERROR 42000: Too big precision 66 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(66,66) UNSIGNED; -ERROR 42000: Too big scale 66 specified for 'n66_66'. Maximum is 38 +ERROR 42000: Too big scale specified for 'n66_66'. Maximum is 38 DROP TABLE t1; CREATE TABLE t1 ( a DECIMAL UNSIGNED, @@ -499,7 +499,7 @@ r1_1 0.9 r1_1 0.9 ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0) UNSIGNED; ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(256,1) UNSIGNED; -ERROR 42000: Too big precision 256 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(40,35) UNSIGNED; DROP TABLE t1; CREATE TABLE t1 ( diff --git a/storage/rocksdb/mysql-test/rocksdb/r/type_fixed.result b/storage/rocksdb/mysql-test/rocksdb/r/type_fixed.result index 055952ea55f..fcbef547891 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/type_fixed.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/type_fixed.result @@ -123,9 +123,9 @@ d d0 d1_1 d10_2 d60_10 n n0_0 n1 n20_4 n65_4 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 9999999999 9999999999 0.9 99999999.99 99999999999999999999999999999999999999999999999999.9999999999 9999999999 9999999999 9 9999999999999999.9999 9999999999999999999999999999999999999999999999999999999999999.9999 ALTER TABLE t1 ADD COLUMN n66 NUMERIC(66) ; -ERROR 42000: Too big precision 66 specified for 'n66'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(66,6) ; -ERROR 42000: Too big precision 66 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(66,66) ; -ERROR 42000: Too big scale 66 specified for 'n66_66'. Maximum is 38 +ERROR 42000: Too big scale specified for 'n66_66'. Maximum is 38 DROP TABLE t1; diff --git a/storage/rocksdb/mysql-test/rocksdb/r/type_float.result b/storage/rocksdb/mysql-test/rocksdb/r/type_float.result index 371b550d4ab..0cf5c5e0496 100644 --- a/storage/rocksdb/mysql-test/rocksdb/r/type_float.result +++ b/storage/rocksdb/mysql-test/rocksdb/r/type_float.result @@ -309,6 +309,6 @@ r1_1 0.9 r1_1 0.9 ALTER TABLE t1 ADD COLUMN d0_0 DOUBLE(0,0) ; ALTER TABLE t1 ADD COLUMN n66_6 DECIMAL(256,1) ; -ERROR 42000: Too big precision 256 specified for 'n66_6'. Maximum is 65 +ERROR 42000: Too big precision specified for 'n66_6'. Maximum is 65 ALTER TABLE t1 ADD COLUMN n66_66 DECIMAL(40,35) ; DROP TABLE t1; |