Debian Codegraph @

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

raw
1 ## Test of general functionality of session resource group
2
3 ## Preamble
4 --source ../include/have_performance_schema_threads.inc
5 --source include/not_mac_os.inc
6 --source include/xplugin_preamble.inc
7 --source include/xplugin_create_user.inc
8 ## Test starts here
9
10
11 --write_file $MYSQL_TMP_DIR/session_resource_group.xpl
12
13 -->macro Assert_resource_group %EXPECT_GROUP%
14 -->stmtsql SELECT RESOURCE_GROUP FROM performance_schema.threads WHERE THREAD_ID = PS_CURRENT_THREAD_ID()
15 -->recvtovar %GROUP% RESOURCE_GROUP
16 -->echo Verify [Resource group needs to be '%EXPECT_GROUP%']
17 -->assert_eq %GROUP% %EXPECT_GROUP%
18 -->endmacro
19
20
21 -->macro Select_with_optimizer_hint %GROUP%
22 -->stmtsql SELECT /*+ RESOURCE_GROUP(%GROUP%) */ 1 AS value
23 -->recvresult
24 -->endmacro
25
26 -->title =%WORKER_RESOURCE_GROUP%
27
28 -->stmtsql SET RESOURCE GROUP %WORKER_RESOURCE_GROUP%
29 -->recvresult
30
31 -->callmacro Assert_resource_group %WORKER_RESOURCE_GROUP%
32
33 -->callmacro Select_with_optimizer_hint SYS_default
34 -->callmacro Assert_resource_group %WORKER_RESOURCE_GROUP%
35
36 -->callmacro Select_with_optimizer_hint my_group
37 -->callmacro Assert_resource_group %WORKER_RESOURCE_GROUP%
38
39 -->callmacro Select_with_optimizer_hint USR_default
40 -->callmacro Assert_resource_group %WORKER_RESOURCE_GROUP%
41
42 EOF
43
44 CREATE RESOURCE GROUP my_group TYPE=USER;
45
46 # SET RESOURCE GROUP... statements are currently not supported in the X protocol
47 # Need removal '--fatal-errors=0' and record result file after fixing BUG#30900411
48
49 --replace_regex /thread id \([0-9]+\)/thread id (ID)/
50 exec $MYSQLXTEST
51 --fatal-errors=0
52 -ux_root --password=''
53 -v%WORKER_RESOURCE_GROUP%=USR_default
54 --file=$MYSQL_TMP_DIR/session_resource_group.xpl 2>&1;
55
56 --replace_regex /thread id \([0-9]+\)/thread id (ID)/
57 exec $MYSQLXTEST
58 --fatal-errors=0
59 -ux_root --password=''
60 -v%WORKER_RESOURCE_GROUP%=my_group
61 --file=$MYSQL_TMP_DIR/session_resource_group.xpl 2>&1;
62
63 ## Cleanup
64 DROP RESOURCE GROUP my_group FORCE;
65 --source ../include/xplugin_cleanup.inc