summaryrefslogtreecommitdiff
path: root/mysql-test/t/help.test
diff options
context:
space:
mode:
authorAlexander Barkov <bar@mariadb.org>2016-06-21 21:26:31 +0400
committerAlexander Barkov <bar@mariadb.org>2016-06-21 21:26:31 +0400
commit21479a6bb3cc37ffa1fb4f53a0ab71d22c7ad445 (patch)
tree1e2905aa5c6df07103c0f2e09e70f12b02796ad8 /mysql-test/t/help.test
parent69f1a3215e5062eb6c06ed35ec38e1d824efbef6 (diff)
downloadmariadb-git-21479a6bb3cc37ffa1fb4f53a0ab71d22c7ad445.tar.gz
MDEV-9524 Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH
The patch fixes the problem with loading information from system tables (e.g. event and help related tables) when PAD_CHAR_TO_FULL_LENGTH is enabled, as well as includes some additional minor improvements: - refactoring in get_field() to return an error rather than success if strmake_root() failed - removing of duplicate code in similar functions: char *get_field(MEM_ROOT *mem, Field *field) bool get_field(MEM_ROOT *mem, Field *field, String *res)
Diffstat (limited to 'mysql-test/t/help.test')
-rw-r--r--mysql-test/t/help.test6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/t/help.test b/mysql-test/t/help.test
index 71821e46771..881299a216c 100644
--- a/mysql-test/t/help.test
+++ b/mysql-test/t/help.test
@@ -61,6 +61,12 @@ help '%function_7';
help '%category_2';
help 'impossible_function_1';
help 'impossible_category_1';
+
+--echo # MDEV-9524 Cannot load from mysql.event when sql_mode is set to PAD_CHAR_TO_FULL_LENGTH
+help 'impossible_function_1';
+SET sql_mode=PAD_CHAR_TO_FULL_LENGTH;
+help 'impossible_function_1';
+SET sql_mode=DEFAULT;
##############
--disable_warnings