summaryrefslogtreecommitdiff
path: root/mysql-test/r/create.result
diff options
context:
space:
mode:
authorSergey Glukhov <Sergey.Glukhov@sun.com>2008-10-02 16:57:52 +0500
committerSergey Glukhov <Sergey.Glukhov@sun.com>2008-10-02 16:57:52 +0500
commitd51e2c0760f5dca2aff03aa16b77bf70e0b06dbc (patch)
tree080bb32fe11caa26d06b5fd11bdf84560d383d59 /mysql-test/r/create.result
parent7e60f71001595df62b92a089869dd67fcc15a1ee (diff)
downloadmariadb-git-d51e2c0760f5dca2aff03aa16b77bf70e0b06dbc.tar.gz
Bug#35924 DEFINER should be stored 'quoted' in I_S
The '@' symbol can not be used in the host name according to rfc952. The fix: added function check_host_name(LEX_STRING *str) which checks that all symbols in host name string are valid and host name length is not more than max host name length (just moved check_string_length() function from the parser into check_host_name()). mysql-test/r/create.result: test result mysql-test/t/create.test: test case sql/mysql_priv.h: added function check_host_name(LEX_STRING *str) sql/sql_parse.cc: added function check_host_name(LEX_STRING *str) which checks that all symbols in host name string are valid and host name length is not more than max host name length(HOSTNAME_LENGTH). sql/sql_yacc.yy: using newly added function check_host_name()
Diffstat (limited to 'mysql-test/r/create.result')
-rw-r--r--mysql-test/r/create.result2
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/r/create.result b/mysql-test/r/create.result
index 2d668499df3..d37c1a04daa 100644
--- a/mysql-test/r/create.result
+++ b/mysql-test/r/create.result
@@ -1546,6 +1546,8 @@ SHOW INDEX FROM t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment
t1 1 c1 1 c1 A NULL NULL NULL YES BTREE
DROP TABLE t1;
+create user mysqltest_1@'test@test';
+ERROR HY000: Malformed hostname (illegal symbol: '@')
CREATE TABLE t1 (a INTEGER AUTO_INCREMENT PRIMARY KEY, b INTEGER NOT NULL);
INSERT IGNORE INTO t1 (b) VALUES (5);
CREATE TABLE IF NOT EXISTS t2 (a INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY)