Debian Codegraph @

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

raw
1 # Variable: innodb_redo_log_archive_dirs
2 # Default : NULL
3 # Scope : GLOBAL
4 # Dynamic : Yes
5
6 ## Save variable
7 SET @innodb_redo_log_archive_dirs_sav= @@global.innodb_redo_log_archive_dirs;
8
9 ## Show default value
10 SELECT @@global.innodb_redo_log_archive_dirs;
11
12 ## Valid cases
13 ## Syntax: semi-colon separated list of labeled path names.
14 ## Path names are not checked when the variable is set.
15 #
16 SET @@global.innodb_redo_log_archive_dirs="label1:/dir1";
17 SELECT @@global.innodb_redo_log_archive_dirs;
18 #
19 SET @@global.innodb_redo_log_archive_dirs="label1:/dir1;label2:dir2";
20 SELECT @@global.innodb_redo_log_archive_dirs;
21 #
22 ## A single trailing semi-colon is allowed.
23 #
24 SET @@global.innodb_redo_log_archive_dirs="label1:/dir1;";
25 SELECT @@global.innodb_redo_log_archive_dirs;
26 #
27 SET @@global.innodb_redo_log_archive_dirs="label1:dir1;label2:/dir2;";
28 SELECT @@global.innodb_redo_log_archive_dirs;
29 #
30 ## Label can be empty, but colon must exist.
31 #
32 SET @@global.innodb_redo_log_archive_dirs=":/dir1";
33 SELECT @@global.innodb_redo_log_archive_dirs;
34 #
35 ## Labels are not checked for uniqueness. Nor are path names.
36 #
37 SET @@global.innodb_redo_log_archive_dirs=":dir1;:dir1";
38 SELECT @@global.innodb_redo_log_archive_dirs;
39 #
40 ## Label can contain every character, but colon. Example label ";;;".
41 #
42 SET @@global.innodb_redo_log_archive_dirs=";;;:/dir1";
43 SELECT @@global.innodb_redo_log_archive_dirs;
44 #
45 ## Path can contain every character, but semi-colon. Example path ":::".
46 #
47 SET @@global.innodb_redo_log_archive_dirs="label::::";
48 SELECT @@global.innodb_redo_log_archive_dirs;
49 #
50 ## Example: Two times in a row label ";;;", path ":::", trailing semi-colon.
51 #
52 SET @@global.innodb_redo_log_archive_dirs=";;;::::;;;;::::;";
53 SELECT @@global.innodb_redo_log_archive_dirs;
54 #
55 ## Variable can be empty.
56 #
57 SET @@global.innodb_redo_log_archive_dirs="";
58 SELECT @@global.innodb_redo_log_archive_dirs;
59 #
60 ## Variable can be NULL.
61 #
62 SET @@global.innodb_redo_log_archive_dirs=NULL;
63 SELECT @@global.innodb_redo_log_archive_dirs;
64 #
65 ## Variable can be persisted.
66 #
67 SET PERSIST innodb_redo_log_archive_dirs="label1:/dir1";
68 SELECT @@global.innodb_redo_log_archive_dirs;
69 RESET PERSIST innodb_redo_log_archive_dirs;
70
71 ## Invalid cases
72 --error ER_GLOBAL_VARIABLE
73 SET innodb_redo_log_archive_dirs="label1:/dir1";
74 --error ER_GLOBAL_VARIABLE
75 SET @@local.innodb_redo_log_archive_dirs="label1:/dir1";
76 --error ER_GLOBAL_VARIABLE
77 SET @@innodb_redo_log_archive_dirs="label1:/dir1";
78 --error ER_GLOBAL_VARIABLE
79 SET @@session.innodb_redo_log_archive_dirs="label1:/dir1";
80
81 ## Invalid cases
82 # Label missing
83 --error ER_WRONG_VALUE_FOR_VAR
84 SET @@global.innodb_redo_log_archive_dirs="/dir1";
85 ## Path missing.
86 --error ER_WRONG_VALUE_FOR_VAR
87 SET @@global.innodb_redo_log_archive_dirs=":";
88 --error ER_WRONG_VALUE_FOR_VAR
89 SET @@global.innodb_redo_log_archive_dirs="l1:";
90 # (Second) Label missing
91 --error ER_WRONG_VALUE_FOR_VAR
92 SET @@global.innodb_redo_log_archive_dirs=":d1;;";
93 --error ER_WRONG_VALUE_FOR_VAR
94 SET @@global.innodb_redo_log_archive_dirs=":d1;d2";
95 # (Second) Path missing
96 --error ER_WRONG_VALUE_FOR_VAR
97 SET @@global.innodb_redo_log_archive_dirs="l1:d1;l2:";
98 # (Second) Path missing
99 --error ER_WRONG_VALUE_FOR_VAR
100 SET @@global.innodb_redo_log_archive_dirs="l1:d1;l2:;";
101
102 # Repeated execution of SET @@global.innodb_redo_log_archive_dirs
103 --disable_warnings
104 DROP PROCEDURE IF EXISTS test.innodb_redo_log_archive_dirs;
105 --enable_warnings
106 DELIMITER |;
107 CREATE PROCEDURE test.innodb_redo_log_archive_dirs (IN start BIGINT, IN nam CHAR(20))
108 BEGIN
109 DECLARE CONTINUE HANDLER FOR 13178 SET @x2 = 1;
110 SET @idx=start;
111 SET @n=nam;
112 WHILE (@idx > 0) DO
113 SET @s=CONCAT("SET @@global.innodb_redo_log_archive_dirs='1:../www/",@n,@idx,"'");
114 Prepare stmt from @s;
115 Execute stmt;
116 SET @@global.innodb_redo_log_archive_dirs="";
117 SET @idx = @idx - 1;
118 END WHILE;
119 END|
120 DELIMITER ;|
121 CALL test.innodb_redo_log_archive_dirs(100,'s');
122 DROP PROCEDURE test.innodb_redo_log_archive_dirs;
123
124 ## Restore variable
125 SET @@global.innodb_redo_log_archive_dirs= @innodb_redo_log_archive_dirs_sav;