summaryrefslogtreecommitdiff
path: root/mysql-test/r/view.result
diff options
context:
space:
mode:
authorunknown <cmiller@zippy.cornsilk.net>2006-09-05 13:35:13 -0400
committerunknown <cmiller@zippy.cornsilk.net>2006-09-05 13:35:13 -0400
commit91d44bc2f09d3f0bc188ccae8702bcd8d93659cd (patch)
treeb705b902cbc6cc29959c7f97e21996da2de1c447 /mysql-test/r/view.result
parent51384e2168cb29417f5da970690c680b16f42ae2 (diff)
parentd3926ea6571c52d1c52212dbfac4bbdeb92d9b6a (diff)
downloadmariadb-git-91d44bc2f09d3f0bc188ccae8702bcd8d93659cd.tar.gz
Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-maint
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-maint mysql-test/r/trigger.result: Auto merged mysql-test/t/trigger.test: Auto merged sql/mysql_priv.h: Auto merged sql/share/errmsg.txt: Auto merged mysql-test/r/grant.result: Manual merge. mysql-test/r/sp.result: Manual merge. mysql-test/r/view.result: Manual merge. mysql-test/t/grant.test: Manual merge. mysql-test/t/sp.test: Manual merge. mysql-test/t/view.test: manual merge. sql/sql_acl.cc: manual merge. sql/sql_parse.cc: manual merge. sql/sql_yacc.yy: manual merge.
Diffstat (limited to 'mysql-test/r/view.result')
-rw-r--r--mysql-test/r/view.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result
index 08f51494e20..61a83ce5fde 100644
--- a/mysql-test/r/view.result
+++ b/mysql-test/r/view.result
@@ -2735,6 +2735,17 @@ m e
4 a
1 b
DROP VIEW v1;
+DROP TABLE IF EXISTS t1;
+DROP VIEW IF EXISTS v1;
+DROP VIEW IF EXISTS v2;
+CREATE TABLE t1(a INT, b INT);
+CREATE DEFINER=1234567890abcdefGHIKL@localhost
+VIEW v1 AS SELECT a FROM t1;
+ERROR HY000: String '1234567890abcdefGHIKL' is too long for user name (should be no longer than 16)
+CREATE DEFINER=some_user_name@1234567890abcdefghij1234567890abcdefghij1234567890abcdefghijQWERTY
+VIEW v2 AS SELECT b FROM t1;
+ERROR HY000: String '1234567890abcdefghij1234567890abcdefghij1234567890abcdefghijQWERTY' is too long for host name (should be no longer than 60)
+DROP TABLE t1;
DROP TABLE t1,t2;
CREATE TABLE t1 (a INT NOT NULL, b INT NULL DEFAULT NULL);
CREATE VIEW v1 AS SELECT a, b FROM t1;