Debian Codegraph @

mysql-test/suite/x/r/mysql_session_user.result

raw
1 #
2 # Assert the user exist from the start
3 #
4 include/assert.inc [session_user should exist before X plugin install]
5 #
6 # Start X plugin and check all is OK
7 #
8 include/assert.inc [session_user should exist after X plugin install]
9 #
10 # Delete the user
11 #
12 DROP USER "mysql.session"@"localhost";
13 call mtr.add_suppression("Plugin mysqlx reported: 'Unable to switch context to user mysql.session'");
14 #
15 # Recreate the user with an upgrade and see that X plugin works
16 #
17 Run mysql_upgrade
18 # restart:--upgrade=FORCE
19 include/assert.inc [session_user should exist after upgrade]
20 RUN SELECT CURRENT_USER()
21
22 CURRENT_USER()
23 x_root@localhost
24 0 rows affected
25 Mysqlx.Ok {
26 msg: "bye!"
27 }
28 #
29 # Uninstall plugin and verify that user is still there
30 #
31 include/assert.inc [session_user should exist after install]
32 #
33 # Cleaning
34 #
35 call mtr.add_suppression("Unable to use user mysql.session context *.*");
36 call mtr.add_suppression("On plugin shutdown it was not possible to reset the server read mode settings. Try to reset it manually.");