summaryrefslogtreecommitdiff
path: root/mysql-test/r
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/r
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/r')
-rw-r--r--mysql-test/r/grant5.result7
1 files changed, 7 insertions, 0 deletions
diff --git a/mysql-test/r/grant5.result b/mysql-test/r/grant5.result
index d7f3b6812bb..8c32d90a640 100644
--- a/mysql-test/r/grant5.result
+++ b/mysql-test/r/grant5.result
@@ -16,3 +16,10 @@ show grants for foo@'%';
ERROR 42000: Access denied for user 'test'@'%' to database 'mysql'
drop user test, foo;
drop role foo;
+CREATE TABLE t1 (a INT);
+LOCK TABLE t1 WRITE;
+REVOKE EXECUTE ON PROCEDURE sp FROM u;
+ERROR HY000: Table 'user' was not locked with LOCK TABLES
+REVOKE PROCESS ON *.* FROM u;
+ERROR HY000: Table 'user' was not locked with LOCK TABLES
+DROP TABLE t1;