summaryrefslogtreecommitdiff
path: root/mysql-test/t/grant5.test
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2018-12-19 15:23:54 +0100
committerSergei Golubchik <serg@mariadb.org>2018-12-20 08:39:54 +0100
commit8ede9b3ae542068cc02ca27ab32eb76fcfab942f (patch)
tree4320f8c01fdc8206a2645d53457a4041e246a724 /mysql-test/t/grant5.test
parentdd72d7d561d36c2d1f5d3ccad2b388d886230392 (diff)
downloadmariadb-git-8ede9b3ae542068cc02ca27ab32eb76fcfab942f.tar.gz
MDEV-17975 Assertion `! is_set()' or `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed upon REVOKE under LOCK TABLE
open_grant_tables() returns -1/0/1, where -1 is an error, while 1 is not. Don't store it's return value in bool
Diffstat (limited to 'mysql-test/t/grant5.test')
-rw-r--r--mysql-test/t/grant5.test10
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/grant5.test b/mysql-test/t/grant5.test
index 14f2fd65020..649bba7d1ca 100644
--- a/mysql-test/t/grant5.test
+++ b/mysql-test/t/grant5.test
@@ -23,3 +23,13 @@ show grants for foo@'%'; # user
drop user test, foo;
drop role foo;
+#
+# MDEV-17975 Assertion `! is_set()' or `!is_set() || (m_status == DA_OK_BULK && is_bulk_op())' failed upon REVOKE under LOCK TABLE
+#
+CREATE TABLE t1 (a INT);
+LOCK TABLE t1 WRITE;
+--error ER_TABLE_NOT_LOCKED
+REVOKE EXECUTE ON PROCEDURE sp FROM u;
+--error ER_TABLE_NOT_LOCKED
+REVOKE PROCESS ON *.* FROM u;
+DROP TABLE t1;