Debian Codegraph @

mysql-test/suite/auth_sec/t/atomic_alter_user_no_warning.test

raw
1 --source include/have_log_bin.inc
2 --source include/save_binlog_position.inc
3
4 # Save the initial number of concurrent sessions
5 --source include/count_sessions.inc
6
7 --echo # -----------------------------------------------------------------------
8
9 --echo # Begin : Tests for ALTER USER
10
11 CREATE USER userX, userY, userZ;
12 --source include/save_binlog_position.inc
13
14 # This should not produce any warning in server log because none of the
15 # non-existing users are using default authentication plugin.
16 # We have not added mtr.add_suppression() call for such a warning. So,
17 # if below mentioned DDL logs a warning, mtr would complain.
18
19 ALTER USER IF EXISTS userX, userY, userZ,
20 userW IDENTIFIED WITH 'mysql_native_password' BY 'abcd'
21 ACCOUNT LOCK;
22
23 --let $event= !Q(ALTER USER.*userX.*userY.*userZ.*userW.*ACCOUNT LOCK.*)
24 --source ../include/auth_sec_assert_binlog_events.inc
25 --source include/save_binlog_position.inc
26
27 DROP USER userX, userY, userZ;
28
29 --echo # End : Tests for ALTER USER IF EXISTS
30
31 --echo # -----------------------------------------------------------------------
32
33 # Wait till we reached the initial number of concurrent sessions
34 --source include/wait_until_count_sessions.inc