diff options
| author | Alexander Barkov <bar@mariadb.org> | 2014-09-04 08:50:06 +0400 |
|---|---|---|
| committer | Alexander Barkov <bar@mariadb.org> | 2014-09-04 08:50:06 +0400 |
| commit | 58eb51d1cfb50058ce52dda5ef95fb7f2144467d (patch) | |
| tree | d232bc58d654228a2ddcefe0eb60382c5cc3ad6f /mysql-test/r | |
| parent | 1e66871713b7196daf1e9416823d57d5bbac85a1 (diff) | |
| download | mariadb-git-58eb51d1cfb50058ce52dda5ef95fb7f2144467d.tar.gz | |
MDEV-6044 MySQL BUG#12735829 - SPACE() FUNCTION WARNING REFERS TO REPEAT() IN ER_WARN_ALLOWED_PACKET_OVERFLOWED
Merged from 5.6
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ctype_utf16.result | 2 | ||||
| -rw-r--r-- | mysql-test/r/func_str.result | 31 |
2 files changed, 25 insertions, 8 deletions
diff --git a/mysql-test/r/ctype_utf16.result b/mysql-test/r/ctype_utf16.result index b772c0e4370..074fc28a6b7 100644 --- a/mysql-test/r/ctype_utf16.result +++ b/mysql-test/r/ctype_utf16.result @@ -1549,7 +1549,7 @@ SELECT space(date_add(101, INTERVAL CHAR('1' USING utf16) hour_second)); space(date_add(101, INTERVAL CHAR('1' USING utf16) hour_second)) NULL Warnings: -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated # # Bug#11750518 41090: ORDER BY TRUNCATES GROUP_CONCAT RESULT # diff --git a/mysql-test/r/func_str.result b/mysql-test/r/func_str.result index 44a67fe6b27..bc5f6951184 100644 --- a/mysql-test/r/func_str.result +++ b/mysql-test/r/func_str.result @@ -845,7 +845,7 @@ explain extended select concat('*',space(5),'*'); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used Warnings: -Note 1003 select concat('*',repeat(' ',5),'*') AS `concat('*',space(5),'*')` +Note 1003 select concat('*',space(5),'*') AS `concat('*',space(5),'*')` explain extended select reverse('abc'); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used @@ -2083,7 +2083,7 @@ select space(4294967295); space(4294967295) NULL Warnings: -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated select space(-4294967296); space(-4294967296) @@ -2091,7 +2091,7 @@ select space(4294967296); space(4294967296) NULL Warnings: -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated select space(-4294967297); space(-4294967297) @@ -2099,7 +2099,7 @@ select space(4294967297); space(4294967297) NULL Warnings: -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated select space(-18446744073709551615); space(-18446744073709551615) @@ -2110,7 +2110,7 @@ select space(18446744073709551615); space(18446744073709551615) NULL Warnings: -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated select space(-18446744073709551616); space(-18446744073709551616) @@ -2123,7 +2123,7 @@ NULL Warnings: Warning 1916 Got overflow when converting '18446744073709551616' to INT. Value truncated. Warning 1916 Got overflow when converting '18446744073709551616' to INT. Value truncated. -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated select space(-18446744073709551617); space(-18446744073709551617) @@ -2136,7 +2136,7 @@ NULL Warnings: Warning 1916 Got overflow when converting '18446744073709551617' to INT. Value truncated. Warning 1916 Got overflow when converting '18446744073709551617' to INT. Value truncated. -Warning 1301 Result of repeat() was larger than max_allowed_packet (1048576) - truncated +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated select rpad('hello', -1, '1'); rpad('hello', -1, '1') NULL @@ -4513,3 +4513,20 @@ SELECT FROM_BASE64(TO_BASE64(dt1)) FROM t1; FROM_BASE64(TO_BASE64(dt1)) 2011-01-01 02:03:04 DROP TABLE t1; +SELECT SPACE(@@global.max_allowed_packet*2); +SPACE(@@global.max_allowed_packet*2) +NULL +Warnings: +Warning 1301 Result of space() was larger than max_allowed_packet (1048576) - truncated +SET NAMES latin1; +PREPARE stmt FROM "SELECT COLLATION(space(2))"; +EXECUTE stmt; +COLLATION(space(2)) +latin1_swedish_ci +SET NAMES latin2; +EXECUTE stmt; +COLLATION(space(2)) +latin2_general_ci +# +# End of 5.6 tests +# |