| 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 |