Debian Codegraph @

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

raw
1 SET @start_read_only = @@global.read_only;
2 SET @start_super_read_only = @@global.super_read_only;
3 SELECT @start_read_only, @start_super_read_only;
4 @start_read_only @start_super_read_only
5 0 0
6 '#--------------------FN_DYNVARS_139_01------------------------#'
7 SET @@global.super_read_only = 1;
8 SET @@global.super_read_only = DEFAULT;
9 SELECT @@global.super_read_only;
10 @@global.super_read_only
11 0
12 '#---------------------FN_DYNVARS_139_02-------------------------#'
13 SET @@global.super_read_only = @start_super_read_only;
14 SELECT @@global.super_read_only = 0;
15 @@global.super_read_only = 0
16 1
17 '#--------------------FN_DYNVARS_139_03------------------------#'
18 SET @@global.super_read_only = 0;
19 SELECT @@global.super_read_only;
20 @@global.super_read_only
21 0
22 SET @@global.super_read_only = 1;
23 SELECT @@global.super_read_only;
24 @@global.super_read_only
25 1
26 SET @@global.super_read_only = TRUE;
27 SELECT @@global.super_read_only;
28 @@global.super_read_only
29 1
30 SET @@global.super_read_only = FALSE;
31 SELECT @@global.super_read_only;
32 @@global.super_read_only
33 0
34 SET @@global.super_read_only = ON;
35 SELECT @@global.super_read_only;
36 @@global.super_read_only
37 1
38 SET @@global.super_read_only = OFF;
39 SELECT @@global.super_read_only;
40 @@global.super_read_only
41 0
42 '#--------------------FN_DYNVARS_139_04-------------------------#'
43 SET @@global.super_read_only = -1;
44 ERROR 42000: Variable 'super_read_only' can't be set to the value of '-1'
45 SELECT @@global.super_read_only;
46 @@global.super_read_only
47 0
48 SET @@global.super_read_only = 4294967296;
49 ERROR 42000: Variable 'super_read_only' can't be set to the value of '4294967296'
50 SELECT @@global.super_read_only;
51 @@global.super_read_only
52 0
53 SET @@global.super_read_only = 10240022115;
54 ERROR 42000: Variable 'super_read_only' can't be set to the value of '10240022115'
55 SELECT @@global.super_read_only;
56 @@global.super_read_only
57 0
58 SET @@global.super_read_only = 10000.01;
59 ERROR 42000: Incorrect argument type to variable 'super_read_only'
60 SELECT @@global.super_read_only;
61 @@global.super_read_only
62 0
63 SET @@global.super_read_only = -1024;
64 ERROR 42000: Variable 'super_read_only' can't be set to the value of '-1024'
65 SELECT @@global.super_read_only;
66 @@global.super_read_only
67 0
68 SET @@global.super_read_only = 42949672950;
69 ERROR 42000: Variable 'super_read_only' can't be set to the value of '42949672950'
70 SELECT @@global.super_read_only;
71 @@global.super_read_only
72 0
73 SET @@global.super_read_only = 'test';
74 ERROR 42000: Variable 'super_read_only' can't be set to the value of 'test'
75 SELECT @@global.super_read_only;
76 @@global.super_read_only
77 0
78 '#-------------------FN_DYNVARS_139_05----------------------------#'
79 SET @@session.super_read_only = 0;
80 ERROR HY000: Variable 'super_read_only' is a GLOBAL variable and should be set with SET GLOBAL
81 SELECT @@super_read_only;
82 @@super_read_only
83 0
84 '#----------------------FN_DYNVARS_139_06------------------------#'
85 SELECT IF(@@global.super_read_only, "ON", "OFF") = VARIABLE_VALUE
86 FROM performance_schema.global_variables
87 WHERE VARIABLE_NAME='super_read_only';
88 IF(@@global.super_read_only, "ON", "OFF") = VARIABLE_VALUE
89 1
90 SELECT IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE
91 FROM performance_schema.session_variables
92 WHERE VARIABLE_NAME='super_read_only';
93 IF(@@read_only, "ON", "OFF") = VARIABLE_VALUE
94 0
95 '#---------------------FN_DYNVARS_139_07----------------------#'
96 SET @@global.super_read_only = 1;
97 SELECT @@super_read_only = @@global.super_read_only;
98 @@super_read_only = @@global.super_read_only
99 1
100 '#---------------------FN_DYNVARS_139_08----------------------#'
101 SET super_read_only = 1;
102 ERROR HY000: Variable 'super_read_only' is a GLOBAL variable and should be set with SET GLOBAL
103 SELECT @@super_read_only;
104 @@super_read_only
105 1
106 SET local.super_read_only = 1;
107 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'local.super_read_only = 1' at line 1
108 SELECT local.super_read_only;
109 ERROR 42S02: Unknown table 'local' in field list
110 SET global.super_read_only = 1;
111 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'global.super_read_only = 1' at line 1
112 SELECT global.super_read_only;
113 ERROR 42S02: Unknown table 'global' in field list
114 SELECT super_read_only;
115 ERROR 42S22: Unknown column 'super_read_only' in 'field list'
116 SELECT @@session.super_read_only;
117 ERROR HY000: Variable 'super_read_only' is a GLOBAL variable
118 SET @@global.read_only = @start_read_only;
119 SET @@global.super_read_only = @start_super_read_only;
120 SELECT @@global.super_read_only;
121 @@global.super_read_only
122 0
123 SELECT @@global.read_only;
124 @@global.read_only
125 0