summaryrefslogtreecommitdiff
path: root/mysql-test/r/view_grant.result
diff options
context:
space:
mode:
authorDavi Arnaut <Davi.Arnaut@Sun.COM>2010-02-12 00:54:14 -0200
committerDavi Arnaut <Davi.Arnaut@Sun.COM>2010-02-12 00:54:14 -0200
commit80164ae9a08041e67c65460d9bb2a6b0e1aeb277 (patch)
tree628ef22be817336dec02f9407bfcc26fa378dda6 /mysql-test/r/view_grant.result
parent63817720b41a9daa5d792d517c58ae29130cc254 (diff)
downloadmariadb-git-80164ae9a08041e67c65460d9bb2a6b0e1aeb277.tar.gz
Move test case. Embedded server does not support privilege
related bits.
Diffstat (limited to 'mysql-test/r/view_grant.result')
-rw-r--r--mysql-test/r/view_grant.result11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/view_grant.result b/mysql-test/r/view_grant.result
index 2d5c515d0b5..52c8bc8a3d5 100644
--- a/mysql-test/r/view_grant.result
+++ b/mysql-test/r/view_grant.result
@@ -1237,3 +1237,14 @@ SELECT a FROM v2;
a
DROP USER mysqluser1;
DROP DATABASE mysqltest1;
+USE test;
+#
+# Bug#47734: Assertion failed: ! is_set() when locking a view with non-existing definer
+#
+DROP VIEW IF EXISTS v1;
+CREATE DEFINER=`unknown`@`unknown` SQL SECURITY DEFINER VIEW v1 AS SELECT 1;
+Warnings:
+Note 1449 The user specified as a definer ('unknown'@'unknown') does not exist
+LOCK TABLES v1 READ;
+ERROR HY000: The user specified as a definer ('unknown'@'unknown') does not exist
+DROP VIEW v1;