diff options
| author | Sergei Golubchik <serg@mariadb.org> | 2021-01-04 12:35:52 +0100 |
|---|---|---|
| committer | Sergei Golubchik <serg@mariadb.org> | 2021-01-12 10:25:03 +0100 |
| commit | f7ff8f5dd9e99aa480bc7d56dff1a2a642f12b77 (patch) | |
| tree | 89ff0980925130fb9605d966a67d6fafe9a1140b /mysql-test/main/sp-ucs2.result | |
| parent | de5e5ab2106fe37b857eed424f12d197d2c32082 (diff) | |
| download | mariadb-git-f7ff8f5dd9e99aa480bc7d56dff1a2a642f12b77.tar.gz | |
MDEV-24524 Assertion `ls->length < 0xFFFFFFFFL && ((ls->length == 0 && !ls->str) || ls->length == strlen(ls->str))' failed in String::append on SELECT from I_S
don't expect return type of a stored function to be valid.
it's read from a table, so can be messed with.
it even can contain \0 bytes in the middle of the type name
Diffstat (limited to 'mysql-test/main/sp-ucs2.result')
| -rw-r--r-- | mysql-test/main/sp-ucs2.result | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/main/sp-ucs2.result b/mysql-test/main/sp-ucs2.result index ca448efa535..0f5624314d7 100644 --- a/mysql-test/main/sp-ucs2.result +++ b/mysql-test/main/sp-ucs2.result @@ -115,7 +115,6 @@ RETURN 'str'; END| ERROR 42000: COLLATION 'ucs2_unicode_ci' is not valid for CHARACTER SET 'latin1' SET NAMES utf8; -DROP FUNCTION IF EXISTS bug48766; CREATE FUNCTION bug48766 () RETURNS ENUM( 'w' ) CHARACTER SET ucs2 RETURN 0; @@ -140,3 +139,10 @@ WHERE ROUTINE_NAME='bug48766'; DTD_IDENTIFIER enum('а','б','в','г') DROP FUNCTION bug48766; +call mtr.add_suppression('invalid value in column mysql.proc.'); +set collation_connection=ucs2_general_ci; +insert into mysql.proc (db, name, type, specific_name, language, sql_data_access, is_deterministic, security_type, param_list, returns, body, definer, created, modified, sql_mode, comment, character_set_client, collation_connection, db_collation, body_utf8 ) values ( 'a', 'a', 'function', 'bug14233_1', 'sql', 'reads_sql_data', 'no', 'definer', '', 'int(10)', 'select * from mysql.user', 'root@localhost', now(), '0000-00-00 00:00:00', '', '', '', '', '', 'select * from mysql.user' ); +select * from information_schema.routines where routine_name='a'; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 +set collation_connection=default; +delete from mysql.proc where name='a'; |