Debian Codegraph @

mysql-test/suite/x/t/performance_schema_threads.test

raw
1 ## Tests detecting presence of xplugin objects in PERFORMANCE_SCHEMA.
2
3 ## Preamble
4 --source ../include/have_performance_schema_threads.inc
5 --source include/xplugin_preamble.inc
6 --source include/xplugin_create_user.inc
7
8 # Tests
9
10 --write_file $MYSQL_TMP_DIR/verify_process_data_in_thread_table.xpl
11 -->import connection.macro
12 -->callmacro Verify_its_xprotocol_connection
13 -->login %ARG_USER% %ARG_PASS% %ARG_DB% mysql41
14
15 -->macro Verify_column_in_thread_table %COLUMN% %EXPECTED_VALUE%
16 -->echo Verify [Current process needs to have %EXPECTED_VALUE% in %COLUMN% column]
17 -->quiet
18 -->stmtsql SELECT %COLUMN% FROM performance_schema.threads WHERE processlist_id = connection_id();;
19 -->noquiet
20 -->recvtovar %VALUE%
21 -->assert_eq %EXPECTED_VALUE% %VALUE%
22 -->endmacro
23
24 -->callmacro Verify_column_in_thread_table PROCESSLIST_USER %ARG_USER%
25 -->callmacro Verify_column_in_thread_table PROCESSLIST_HOST %ARG_HOST%
26 -->callmacro Verify_column_in_thread_table PROCESSLIST_DB %ARG_DB%
27 -->callmacro Verify_column_in_thread_table PROCESSLIST_DB %ARG_DB%
28 -->callmacro Verify_column_in_thread_table CONNECTION_TYPE TCP/IP
29 -->callmacro Verify_column_in_thread_table CONNECTION_TYPE TCP/IP
30 -->callmacro Verify_column_in_thread_table PROCESSLIST_COMMAND Query
31
32 EOF
33
34 CREATE USER 'user_on_localhost'@localhost;
35 CREATE USER 'user_on_127_0_0_1'@127.0.0.1;
36
37 GRANT SELECT ON *.* TO 'user_on_localhost'@localhost;
38 GRANT SELECT ON *.* TO 'user_on_127_0_0_1'@127.0.0.1;
39
40 --source ../include/performance_schema_assert_empty_worker_threads.inc
41
42 exec $MYSQLXTEST --file=$MYSQL_TMP_DIR/verify_process_data_in_thread_table.xpl --no-auth
43 -v%ARG_USER%=x_root -v%ARG_PASS%= -v%ARG_HOST%=localhost -v%ARG_DB%=performance_schema
44 2>&1;
45
46 exec $MYSQLXTEST --file=$MYSQL_TMP_DIR/verify_process_data_in_thread_table.xpl --no-auth
47 -v%ARG_USER%=user_on_127_0_0_1 -v%ARG_PASS%= -v%ARG_HOST%=localhost -v%ARG_DB%=mysql
48 2>&1;
49
50 exec $MYSQLXTEST --file=$MYSQL_TMP_DIR/verify_process_data_in_thread_table.xpl --no-auth
51 -v%ARG_USER%=user_on_localhost -v%ARG_PASS%= -v%ARG_HOST%=localhost -v%ARG_DB%=sys
52 2>&1;
53
54 --source ../include/performance_schema_assert_empty_worker_threads.inc
55
56 ## Cleanup
57 DROP USER 'user_on_localhost'@localhost;
58 DROP USER 'user_on_127_0_0_1'@127.0.0.1;
59 --source ../include/xplugin_cleanup.inc