Debian Codegraph @

mysql-test/suite/sys_vars/t/rpl_semi_sync_source_wait_point_basic.test

raw
1 ################################################################################
2 # rpl_semi_sync_source
3 #
4 # It is a global variable only and can be set dynamically.
5 # It has ENUM type and only accepts 'AFTER_COMMIT' and 'AFTER_SYNC' two values.
6 #
7 # This test verifies the variable can be set, selected and showed correctly.
8 ################################################################################
9 source include/have_semisync_plugin.inc;
10
11 --echo #
12 --echo # Initialization
13 --echo #
14 # The following is to prevent a mis-match on windows that has the name of the
15 # lib ending with 'dll'
16 --replace_regex /\.dll/.so/
17 eval INSTALL PLUGIN rpl_semi_sync_source SONAME '$SEMISYNC_SOURCE_PLUGIN';
18
19 --echo #
20 --echo # Verify it can set selected and showed correctly
21 --echo #
22 SELECT @@GLOBAL.rpl_semi_sync_source_wait_point;
23
24 SHOW GLOBAL VARIABLES LIKE 'rpl_semi_sync_source_wait_point';
25
26 --disable_warnings
27 SELECT * FROM performance_schema.global_variables WHERE
28 VARIABLE_NAME = 'rpl_semi_sync_source_wait_point';
29 --enable_warnings
30
31 --echo #
32 --echo # Verify it is not a session variable
33 --echo #
34 --error ER_INCORRECT_GLOBAL_LOCAL_VAR
35 SELECT @@SESSION.rpl_semi_sync_source_wait_point;
36
37 SHOW SESSION VARIABLES LIKE 'rpl_semi_sync_source_wait_point';
38
39 --disable_warnings
40 SELECT * FROM performance_schema.session_variables WHERE
41 VARIABLE_NAME ='rpl_semi_sync_source_wait_point';
42 --enable_warnings
43
44 --echo #
45 --echo # Verify it can be set correctly
46 --echo #
47 SET GLOBAL rpl_semi_sync_source_wait_point = AFTER_COMMIT;
48 SELECT @@GLOBAL.rpl_semi_sync_source_wait_point;
49
50 SET GLOBAL rpl_semi_sync_source_wait_point = AFTER_SYNC;
51 SELECT @@GLOBAL.rpl_semi_sync_source_wait_point;
52
53 # 1 is same to AFTER_COMMIT
54 SET GLOBAL rpl_semi_sync_source_wait_point = 1;
55 SELECT @@GLOBAL.rpl_semi_sync_source_wait_point;
56
57 # 0 is same to AFTER_SYNC
58 SET GLOBAL rpl_semi_sync_source_wait_point = 0;
59 SELECT @@GLOBAL.rpl_semi_sync_source_wait_point;
60
61 --error ER_GLOBAL_VARIABLE
62 SET SESSION rpl_semi_sync_source_wait_point = AFTER_COMMIT;
63 SHOW SESSION VARIABLES LIKE 'rpl_semi_sync_source_wait_point';
64
65 --echo #
66 --echo # Verify it could not bet set with invalid values
67 --echo #
68 --error ER_WRONG_VALUE_FOR_VAR
69 SET GLOBAL rpl_semi_sync_source_wait_point = 2;
70
71 --error ER_WRONG_VALUE_FOR_VAR
72 SET GLOBAL rpl_semi_sync_source_wait_point = blabla;
73
74 --error ER_WRONG_VALUE_FOR_VAR
75 SET GLOBAL rpl_semi_sync_source_wait_point = "blabla";
76
77 --error ER_WRONG_VALUE_FOR_VAR
78 SET GLOBAL rpl_semi_sync_source_wait_point = "";
79
80 --error ER_WRONG_VALUE_FOR_VAR
81 SET GLOBAL rpl_semi_sync_source_wait_point = NULL;
82
83 --error ER_WRONG_TYPE_FOR_VAR
84 SET GLOBAL rpl_semi_sync_source_wait_point = 0.1;
85
86 --echo #
87 --echo # Cleanup
88 --echo #
89 UNINSTALL PLUGIN rpl_semi_sync_source;
90