summaryrefslogtreecommitdiff
path: root/mysql-test/t/view.test
diff options
context:
space:
mode:
authorcmiller@zippy.cornsilk.net <>2006-09-05 13:35:13 -0400
committercmiller@zippy.cornsilk.net <>2006-09-05 13:35:13 -0400
commit469e85e3f2759abd10b38a3dc2ffe76f5bfc7d4f (patch)
treeb705b902cbc6cc29959c7f97e21996da2de1c447 /mysql-test/t/view.test
parentddbbc7fd47b8c3cb704d047fa8e4ed95309c507c (diff)
parentc7431de4310abb62083803bb1654a5a8a903225c (diff)
downloadmariadb-git-469e85e3f2759abd10b38a3dc2ffe76f5bfc7d4f.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
Diffstat (limited to 'mysql-test/t/view.test')
-rw-r--r--mysql-test/t/view.test27
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test
index 9f818a4c9f2..a1433fb1296 100644
--- a/mysql-test/t/view.test
+++ b/mysql-test/t/view.test
@@ -2600,6 +2600,33 @@ CREATE TABLE t2 SELECT * FROM v1;
SELECT * FROM t2;
DROP VIEW v1;
+
+
+#
+# Test for BUG#16899: Possible buffer overflow in handling of DEFINER-clause.
+#
+
+# Prepare.
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+DROP VIEW IF EXISTS v1;
+DROP VIEW IF EXISTS v2;
+--enable_warnings
+
+CREATE TABLE t1(a INT, b INT);
+
+--error ER_WRONG_STRING_LENGTH
+CREATE DEFINER=1234567890abcdefGHIKL@localhost
+ VIEW v1 AS SELECT a FROM t1;
+
+--error ER_WRONG_STRING_LENGTH
+CREATE DEFINER=some_user_name@1234567890abcdefghij1234567890abcdefghij1234567890abcdefghijQWERTY
+ VIEW v2 AS SELECT b FROM t1;
+
+# Cleanup.
+
+DROP TABLE t1;
DROP TABLE t1,t2;
#