Debian Codegraph @

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

raw
1 CREATE DATABASE xtest;
2 CREATE USER 'user1'@'127.0.0.1' IDENTIFIED BY 'user1_pass';
3 CREATE USER 'user2'@'127.0.0.1' IDENTIFIED BY 'user2_pass';
4 GRANT SELECT ON xtest.* TO user1@'127.0.0.1';
5 GRANT SELECT ON xtest.* TO user2@'127.0.0.1';
6
7 ############################################################
8 ## Verify mysqlxtests variables at first connection
9 ##
10 #
11 # Command line options must be unchange, on unauthenticated connection
12 # on every session or authenticated account
13 #
14 # Authenticating on existing connection
15 Login OK
16 # * SOCKET_ID must be the same as before
17 # * CLIENT_ID must have a expected value
18 #
19 # Command line options must be unchange, on authenticated connection
20 # on every session or authenticated account
21 #
22 # New connection:
23 connecting...
24 active session is now 'second_session'
25 #
26 # Command line options must be unchange, on second session
27 # on every session or authenticated account
28 # * SOCKET_ID must have a new value
29 # * CLIENT_ID must have a new value
30 ok
31
32 ############################################################
33 ## Verify mysqlxtests variables at second connection
34 ##
35 #
36 # Command line options must be unchange, on unauthenticated connection
37 # on every session or authenticated account
38 #
39 # Authenticating on existing connection
40 Login OK
41 # * SOCKET_ID must be the same as before
42 # * CLIENT_ID must have a expected value
43 #
44 # Command line options must be unchange, on authenticated connection
45 # on every session or authenticated account
46 #
47 # New connection:
48 connecting...
49 active session is now 'second_session'
50 #
51 # Command line options must be unchange, on second session
52 # on every session or authenticated account
53 # * SOCKET_ID must have a new value
54 # * CLIENT_ID must have a new value
55 ok
56 DROP USER 'user1'@'127.0.0.1';
57 DROP USER 'user2'@'127.0.0.1';