summaryrefslogtreecommitdiff
path: root/mysql-test/t/view_grant.test
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/t/view_grant.test
parent63817720b41a9daa5d792d517c58ae29130cc254 (diff)
downloadmariadb-git-80164ae9a08041e67c65460d9bb2a6b0e1aeb277.tar.gz
Move test case. Embedded server does not support privilege
related bits.
Diffstat (limited to 'mysql-test/t/view_grant.test')
-rw-r--r--mysql-test/t/view_grant.test14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/view_grant.test b/mysql-test/t/view_grant.test
index 175468db702..ba603bde7f8 100644
--- a/mysql-test/t/view_grant.test
+++ b/mysql-test/t/view_grant.test
@@ -1532,3 +1532,17 @@ SELECT a FROM v2;
--disconnect mysqluser1
DROP USER mysqluser1;
DROP DATABASE mysqltest1;
+USE test;
+
+--echo #
+--echo # Bug#47734: Assertion failed: ! is_set() when locking a view with non-existing definer
+--echo #
+
+--disable_warnings
+DROP VIEW IF EXISTS v1;
+--enable_warnings
+
+CREATE DEFINER=`unknown`@`unknown` SQL SECURITY DEFINER VIEW v1 AS SELECT 1;
+--error ER_NO_SUCH_USER
+LOCK TABLES v1 READ;
+DROP VIEW v1;