1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
|
--echo #
--echo # WL#9787: Allow SET PERSIST to set read-only variables too
--echo # Extended Test case to cover all the static server variables including
--echo # plugin variables.
--echo #
#############################
# Creation Date: 2017-05-23 #
# Test Author: Mohit Joshi #
#############################
# This test is also meant to check read-only persisted value of log-replica-updates,
# thus, it makes sense to run this test when log-bin and log-replica-updates are enabled.
-- source include/have_log_bin.inc
--echo # Check there are no existing persistent variables
--echo # Must return 0 rows.
SELECT * FROM performance_schema.persisted_variables;
SELECT VARIABLE_NAME FROM performance_schema.variables_info WHERE VARIABLE_SOURCE = 'PERSISTED';
# clang/UBSAN needs to override the small thread stack in the .sql file
call mtr.add_suppression("option 'thread_stack':");
--echo # Filtering out the warning as open_files_limit value is calculated at runtime
CALL mtr.add_suppression("Could not increase number of max_open_files to more than *");
--echo # Allow SET PERSIST to set all the read only variables excluding plugin
--echo # variables.
--echo #
--disable_warnings
--source include/persist_only_variables.sql
--enable_warnings
let $MYSQLD_DATADIR= `select @@datadir`;
--echo # Must return 100 rows.
SELECT count(*) from performance_schema.persisted_variables;
--echo # Restart server
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
CALL mtr.add_suppression("Plugin audit_log reported *");
--echo # Both queries must return 101 rows.
SELECT * FROM performance_schema.persisted_variables ORDER BY VARIABLE_NAME;
SELECT VARIABLE_NAME FROM performance_schema.variables_info WHERE VARIABLE_SOURCE = 'PERSISTED' ORDER BY VARIABLE_NAME;
RESET PERSIST;
--echo # Restart server
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
--echo # Install version token plugin
--echo ##################
--replace_regex /\.dll/.so/
eval INSTALL PLUGIN version_tokens SONAME '$VERSION_TOKEN';
SELECT @@version_tokens_session_number;
--error ER_INCORRECT_GLOBAL_LOCAL_VAR
SET @@persist_only.version_tokens_session_number=3;
--echo # return 0 row
SELECT * FROM performance_schema.persisted_variables;
--echo # Restart server
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
--echo # return 0 row
SELECT * FROM performance_schema.persisted_variables;
SELECT VARIABLE_NAME FROM performance_schema.variables_info WHERE VARIABLE_SOURCE = 'PERSISTED';
UNINSTALL PLUGIN version_tokens;
RESET PERSIST;
--remove_file $MYSQLD_DATADIR/mysqld-auto.cnf
--echo # Restart server
--exec echo "wait" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--shutdown_server
--source include/wait_until_disconnected.inc
--exec echo "restart" > $MYSQLTEST_VARDIR/tmp/mysqld.1.expect
--enable_reconnect
--source include/wait_until_connected_again.inc
|
