diff options
author | Alexander Barkov <bar@mariadb.com> | 2019-08-09 14:18:13 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2019-08-09 14:18:13 +0400 |
commit | 43882e764d6867c6855b1ff057758a3f08b25c55 (patch) | |
tree | 002b065eb90bc438c56ee6ff321b86c4941eec61 /mysql-test/main/func_str.result | |
parent | 2dac1235150681433bdf6480e479e2f787b40f8b (diff) | |
download | mariadb-git-43882e764d6867c6855b1ff057758a3f08b25c55.tar.gz |
MDEV-20303 SPACE(-1) returns a wrong data type
Diffstat (limited to 'mysql-test/main/func_str.result')
-rw-r--r-- | mysql-test/main/func_str.result | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/mysql-test/main/func_str.result b/mysql-test/main/func_str.result index eb00837eaaf..2d86d384288 100644 --- a/mysql-test/main/func_str.result +++ b/mysql-test/main/func_str.result @@ -5073,16 +5073,84 @@ DROP TABLE t1; CREATE OR REPLACE TABLE t1 (i BIGINT); INSERT INTO t1 VALUES (42); CREATE OR REPLACE TABLE t2 AS SELECT +REPEAT(i,NULL) AS cn, REPEAT(i,0) AS c0, REPEAT(i,-1) AS c1 FROM t1; SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( + `cn` char(0) CHARACTER SET utf8 DEFAULT NULL, `c0` char(0) CHARACTER SET utf8 DEFAULT NULL, `c1` char(0) CHARACTER SET utf8 DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 DROP TABLE t1, t2; # +# MDEV-20303 SPACE(-1) returns a wrong data type +# +CREATE TABLE t1 (i BIGINT); +INSERT INTO t1 VALUES (42); +CREATE TABLE t2 AS SELECT +SPACE(NULL) AS cn, +SPACE(0) AS c0, +SPACE(-1) AS c1 +FROM t1; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `cn` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c0` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c1` char(0) CHARACTER SET utf8 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1, t2; +CREATE TABLE t1 (i BIGINT); +INSERT INTO t1 VALUES (42); +CREATE TABLE t2 AS SELECT +LPAD(i,NULL,'a') AS cn, +LPAD(i,0,'a') AS c0, +LPAD(i,-1,'a') AS c1 +FROM t1; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `cn` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c0` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c1` char(0) CHARACTER SET utf8 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1, t2; +CREATE TABLE t1 (i BIGINT); +INSERT INTO t1 VALUES (42); +CREATE TABLE t2 AS SELECT +RPAD(i,NULL,'a') AS cn, +RPAD(i,0,'a') AS c0, +RPAD(i,-1,'a') AS c1 +FROM t1; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `cn` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c0` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c1` char(0) CHARACTER SET utf8 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1, t2; +CREATE TABLE t1 (i BIGINT); +INSERT INTO t1 VALUES (42); +CREATE TABLE t2 AS SELECT +LEFT(i,NULL) AS cn, +LEFT(i,0) AS c0, +LEFT(i,18446744073709551615) AS c1 +FROM t1; +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `cn` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c0` char(0) CHARACTER SET utf8 DEFAULT NULL, + `c1` varchar(20) CHARACTER SET utf8 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +SELECT c1 FROM t2; +c1 +42 +DROP TABLE t1, t2; +# # End of 10.3 tests # |