diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-11 17:52:49 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-03-11 17:52:49 +0100 |
| commit | fad47df9957d754bec12d4d327c77ae04f71d903 (patch) | |
| tree | 58aaf6077adcb0bc0003228d30bed59687527650 /mysql-test/main/func_str.result | |
| parent | 9d7ed94f6a526748eff29dae2939a3fd341f118b (diff) | |
| parent | b7362d5fbc37dec340aeacd1fb0967c4226c022a (diff) | |
| download | mariadb-git-fad47df9957d754bec12d4d327c77ae04f71d903.tar.gz | |
Merge branch '10.4' into 10.5
Diffstat (limited to 'mysql-test/main/func_str.result')
| -rw-r--r-- | mysql-test/main/func_str.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/main/func_str.result b/mysql-test/main/func_str.result index 18ae4d0aee0..6fc61dc0f5f 100644 --- a/mysql-test/main/func_str.result +++ b/mysql-test/main/func_str.result @@ -5159,6 +5159,21 @@ DROP TABLE t1, t2; # Start of 10.4 tests # # +# MDEV-21841 CONV() function truncates the result type to 21 symbol. +# +CREATE TABLE t1(i BIGINT); +INSERT INTO t1 VALUES (-1); +CREATE TABLE t2 AS SELECT conv(i,16,2) from t1; +SELECT * FROM t2; +conv(i,16,2) +1111111111111111111111111111111111111111111111111111111111111111 +SHOW CREATE TABLE t2; +Table Create Table +t2 CREATE TABLE `t2` ( + `conv(i,16,2)` varchar(64) CHARACTER SET utf8 DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +DROP TABLE t1,t2; +# # MDEV-18205 Assertion `str_length < len' failed in Binary_string::realloc_raw # SELECT GROUP_CONCAT( UpdateXML( '<a>new year</a>', '/a', '2019-01-01 00:00:00' ), ENCODE('text','pass') ) AS f; |