Debian Codegraph @

mysql-test/suite/sys_vars/r/innodb_redo_log_archive_dirs_basic.result

raw
1 SET @innodb_redo_log_archive_dirs_sav= @@global.innodb_redo_log_archive_dirs;
2 SELECT @@global.innodb_redo_log_archive_dirs;
3 @@global.innodb_redo_log_archive_dirs
4 NULL
5 SET @@global.innodb_redo_log_archive_dirs="label1:/dir1";
6 SELECT @@global.innodb_redo_log_archive_dirs;
7 @@global.innodb_redo_log_archive_dirs
8 label1:/dir1
9 SET @@global.innodb_redo_log_archive_dirs="label1:/dir1;label2:dir2";
10 SELECT @@global.innodb_redo_log_archive_dirs;
11 @@global.innodb_redo_log_archive_dirs
12 label1:/dir1;label2:dir2
13 SET @@global.innodb_redo_log_archive_dirs="label1:/dir1;";
14 SELECT @@global.innodb_redo_log_archive_dirs;
15 @@global.innodb_redo_log_archive_dirs
16 label1:/dir1;
17 SET @@global.innodb_redo_log_archive_dirs="label1:dir1;label2:/dir2;";
18 SELECT @@global.innodb_redo_log_archive_dirs;
19 @@global.innodb_redo_log_archive_dirs
20 label1:dir1;label2:/dir2;
21 SET @@global.innodb_redo_log_archive_dirs=":/dir1";
22 SELECT @@global.innodb_redo_log_archive_dirs;
23 @@global.innodb_redo_log_archive_dirs
24 :/dir1
25 SET @@global.innodb_redo_log_archive_dirs=":dir1;:dir1";
26 SELECT @@global.innodb_redo_log_archive_dirs;
27 @@global.innodb_redo_log_archive_dirs
28 :dir1;:dir1
29 SET @@global.innodb_redo_log_archive_dirs=";;;:/dir1";
30 SELECT @@global.innodb_redo_log_archive_dirs;
31 @@global.innodb_redo_log_archive_dirs
32 ;;;:/dir1
33 SET @@global.innodb_redo_log_archive_dirs="label::::";
34 SELECT @@global.innodb_redo_log_archive_dirs;
35 @@global.innodb_redo_log_archive_dirs
36 label::::
37 SET @@global.innodb_redo_log_archive_dirs=";;;::::;;;;::::;";
38 SELECT @@global.innodb_redo_log_archive_dirs;
39 @@global.innodb_redo_log_archive_dirs
40 ;;;::::;;;;::::;
41 SET @@global.innodb_redo_log_archive_dirs="";
42 SELECT @@global.innodb_redo_log_archive_dirs;
43 @@global.innodb_redo_log_archive_dirs
44
45 SET @@global.innodb_redo_log_archive_dirs=NULL;
46 SELECT @@global.innodb_redo_log_archive_dirs;
47 @@global.innodb_redo_log_archive_dirs
48 NULL
49 SET PERSIST innodb_redo_log_archive_dirs="label1:/dir1";
50 SELECT @@global.innodb_redo_log_archive_dirs;
51 @@global.innodb_redo_log_archive_dirs
52 label1:/dir1
53 RESET PERSIST innodb_redo_log_archive_dirs;
54 SET innodb_redo_log_archive_dirs="label1:/dir1";
55 ERROR HY000: Variable 'innodb_redo_log_archive_dirs' is a GLOBAL variable and should be set with SET GLOBAL
56 SET @@local.innodb_redo_log_archive_dirs="label1:/dir1";
57 ERROR HY000: Variable 'innodb_redo_log_archive_dirs' is a GLOBAL variable and should be set with SET GLOBAL
58 SET @@innodb_redo_log_archive_dirs="label1:/dir1";
59 ERROR HY000: Variable 'innodb_redo_log_archive_dirs' is a GLOBAL variable and should be set with SET GLOBAL
60 SET @@session.innodb_redo_log_archive_dirs="label1:/dir1";
61 ERROR HY000: Variable 'innodb_redo_log_archive_dirs' is a GLOBAL variable and should be set with SET GLOBAL
62 SET @@global.innodb_redo_log_archive_dirs="/dir1";
63 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of '/dir1'
64 SET @@global.innodb_redo_log_archive_dirs=":";
65 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of ':'
66 SET @@global.innodb_redo_log_archive_dirs="l1:";
67 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of 'l1:'
68 SET @@global.innodb_redo_log_archive_dirs=":d1;;";
69 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of ':d1;;'
70 SET @@global.innodb_redo_log_archive_dirs=":d1;d2";
71 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of ':d1;d2'
72 SET @@global.innodb_redo_log_archive_dirs="l1:d1;l2:";
73 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of 'l1:d1;l2:'
74 SET @@global.innodb_redo_log_archive_dirs="l1:d1;l2:;";
75 ERROR 42000: Variable 'innodb_redo_log_archive_dirs' can't be set to the value of 'l1:d1;l2:;'
76 DROP PROCEDURE IF EXISTS test.innodb_redo_log_archive_dirs;
77 CREATE PROCEDURE test.innodb_redo_log_archive_dirs (IN start BIGINT, IN nam CHAR(20))
78 BEGIN
79 DECLARE CONTINUE HANDLER FOR 13178 SET @x2 = 1;
80 SET @idx=start;
81 SET @n=nam;
82 WHILE (@idx > 0) DO
83 SET @s=CONCAT("SET @@global.innodb_redo_log_archive_dirs='1:../www/",@n,@idx,"'");
84 Prepare stmt from @s;
85 Execute stmt;
86 SET @@global.innodb_redo_log_archive_dirs="";
87 SET @idx = @idx - 1;
88 END WHILE;
89 END|
90 CALL test.innodb_redo_log_archive_dirs(100,'s');
91 DROP PROCEDURE test.innodb_redo_log_archive_dirs;
92 SET @@global.innodb_redo_log_archive_dirs= @innodb_redo_log_archive_dirs_sav;