diff options
author | Roman Nozdrin <roman.nozdrin@mariadb.com> | 2019-10-09 03:13:13 -0500 |
---|---|---|
committer | Roman Nozdrin <roman.nozdrin@mariadb.com> | 2019-10-31 02:26:04 -0500 |
commit | ad8266a5c2f087b8164bb2270108412608719daf (patch) | |
tree | e2bc1d47f9ff5e51b5795bb6c0f7d11e14c95ffd /mysql-test/main/func_str.result | |
parent | 65358278859f3fd7704434b55fa2d414c570e8f6 (diff) | |
download | mariadb-git-ad8266a5c2f087b8164bb2270108412608719daf.tar.gz |
MDEV-20732 MDB now correctly estimates a length of the FORMAT() result for
doubles in scientific notation with a big integer part.
Diffstat (limited to 'mysql-test/main/func_str.result')
-rw-r--r-- | mysql-test/main/func_str.result | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/main/func_str.result b/mysql-test/main/func_str.result index 5fca53def04..5de77f18a24 100644 --- a/mysql-test/main/func_str.result +++ b/mysql-test/main/func_str.result @@ -745,7 +745,7 @@ t1 CREATE TABLE `t1` ( `conv(130,16,10)` varchar(64) DEFAULT NULL, `hex(130)` varchar(6) DEFAULT NULL, `char(130)` varbinary(4) DEFAULT NULL, - `format(130,10)` varchar(45) DEFAULT NULL, + `format(130,10)` varchar(25) DEFAULT NULL, `left(_latin2'a',1)` varchar(1) CHARACTER SET latin2 DEFAULT NULL, `right(_latin2'a',1)` varchar(1) CHARACTER SET latin2 DEFAULT NULL, `lcase(_latin2'a')` varchar(1) CHARACTER SET latin2 DEFAULT NULL, @@ -2708,7 +2708,7 @@ create table t1(a float); insert into t1 values (1.33); select format(a, 2) from t1; Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr -def format(a, 2) 253 57 4 Y 0 39 8 +def format(a, 2) 253 4 4 Y 0 39 8 format(a, 2) 1.33 drop table t1; @@ -3042,7 +3042,7 @@ CREATE TABLE t1 AS SELECT format(123,2,'no_NO'); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( - `format(123,2,'no_NO')` varchar(45) DEFAULT NULL + `format(123,2,'no_NO')` varchar(17) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 SELECT * FROM t1; format(123,2,'no_NO') |