summaryrefslogtreecommitdiff
path: root/mysql-test/main/grant_repair.result
diff options
context:
space:
mode:
authorSergei Golubchik <serg@mariadb.org>2020-04-25 12:49:47 +0200
committerSergei Golubchik <serg@mariadb.org>2020-04-27 09:22:36 +0200
commit6dab094fbd31ef93a1d51b1b9c867188b2f958c3 (patch)
treebdecc2f8afe50c4c0e1c444e941c8a457efd47a8 /mysql-test/main/grant_repair.result
parenta58b2b3b2b564bff9a521c90ab23f850ee9888d3 (diff)
downloadmariadb-git-6dab094fbd31ef93a1d51b1b9c867188b2f958c3.tar.gz
MDEV-20257 Server crashes in Grant_table_base::init_read_record upon crash-upgrade
when opening the `user` table separately, reset `thd->open_tables` for the duration of open, otherwise auto-repair fallback-and-retry will close *all* tables (but reopen only `user`)
Diffstat (limited to 'mysql-test/main/grant_repair.result')
-rw-r--r--mysql-test/main/grant_repair.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/main/grant_repair.result b/mysql-test/main/grant_repair.result
new file mode 100644
index 00000000000..afadca78db7
--- /dev/null
+++ b/mysql-test/main/grant_repair.result
@@ -0,0 +1,9 @@
+call mtr.add_suppression("/mysql/user");
+# switching from mysql.global_priv to mysql.user
+flush tables;
+flush privileges;
+Warnings:
+Error 145 Table './mysql/user' is marked as crashed and should be repaired
+Warning 1034 12544 clients are using or haven't closed the table properly
+Note 1034 Table is fixed
+# switching back from mysql.user to mysql.global_priv