Debian Codegraph @

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

raw
1 SET @start_global_value = @@global.low_priority_updates;
2 SELECT @start_global_value;
3 @start_global_value
4 0
5 SET @start_session_value = @@session.low_priority_updates;
6 SELECT @start_session_value;
7 @start_session_value
8 0
9 '#--------------------FN_DYNVARS_069_01-------------------------#'
10 SET @@global.low_priority_updates = ON;
11 SET @@global.low_priority_updates = DEFAULT;
12 SELECT @@global.low_priority_updates;
13 @@global.low_priority_updates
14 0
15 SET @@session.low_priority_updates = ON;
16 SET @@session.low_priority_updates = DEFAULT;
17 SELECT @@session.low_priority_updates;
18 @@session.low_priority_updates
19 0
20 '#--------------------FN_DYNVARS_069_02-------------------------#'
21 SET @@global.low_priority_updates = DEFAULT;
22 SELECT @@global.low_priority_updates = 'FALSE';
23 @@global.low_priority_updates = 'FALSE'
24 1
25 Warnings:
26 Warning 1292 Truncated incorrect DOUBLE value: 'FALSE'
27 SET @@session.low_priority_updates = DEFAULT;
28 SELECT @@session.low_priority_updates = 'FALSE';
29 @@session.low_priority_updates = 'FALSE'
30 1
31 Warnings:
32 Warning 1292 Truncated incorrect DOUBLE value: 'FALSE'
33 '#--------------------FN_DYNVARS_069_03-------------------------#'
34 SET @@global.low_priority_updates = ON;
35 SELECT @@global.low_priority_updates;
36 @@global.low_priority_updates
37 1
38 SET @@global.low_priority_updates = OFF;
39 SELECT @@global.low_priority_updates;
40 @@global.low_priority_updates
41 0
42 SET @@global.low_priority_updates = 0;
43 SELECT @@global.low_priority_updates;
44 @@global.low_priority_updates
45 0
46 SET @@global.low_priority_updates = 1;
47 SELECT @@global.low_priority_updates;
48 @@global.low_priority_updates
49 1
50 SET @@global.low_priority_updates = TRUE;
51 SELECT @@global.low_priority_updates;
52 @@global.low_priority_updates
53 1
54 SET @@global.low_priority_updates = FALSE;
55 SELECT @@global.low_priority_updates;
56 @@global.low_priority_updates
57 0
58 '#--------------------FN_DYNVARS_069_04-------------------------#'
59 SET @@session.low_priority_updates = ON;
60 SELECT @@session.low_priority_updates;
61 @@session.low_priority_updates
62 1
63 SET @@session.low_priority_updates = OFF;
64 SELECT @@session.low_priority_updates;
65 @@session.low_priority_updates
66 0
67 SET @@session.low_priority_updates = 0;
68 SELECT @@session.low_priority_updates;
69 @@session.low_priority_updates
70 0
71 SET @@session.low_priority_updates = 1;
72 SELECT @@session.low_priority_updates;
73 @@session.low_priority_updates
74 1
75 SET @@session.low_priority_updates = TRUE;
76 SELECT @@session.low_priority_updates;
77 @@session.low_priority_updates
78 1
79 SET @@session.low_priority_updates = FALSE;
80 SELECT @@session.low_priority_updates;
81 @@session.low_priority_updates
82 0
83 '#------------------FN_DYNVARS_069_05-----------------------#'
84 SET @@global.low_priority_updates = 'ONN';
85 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'ONN'
86 SET @@global.low_priority_updates = "OFFF";
87 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'OFFF'
88 SET @@global.low_priority_updates = TTRUE;
89 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'TTRUE'
90 SET @@global.low_priority_updates = FELSE;
91 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'FELSE'
92 SET @@global.low_priority_updates = -1024;
93 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '-1024'
94 SET @@global.low_priority_updates = 65536;
95 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '65536'
96 SET @@global.low_priority_updates = 65530.34;
97 ERROR 42000: Incorrect argument type to variable 'low_priority_updates'
98 SET @@global.low_priority_updates = test;
99 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'test'
100 SET @@session.low_priority_updates = ONN;
101 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'ONN'
102 SET @@session.low_priority_updates = ONF;
103 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'ONF'
104 SET @@session.low_priority_updates = OF;
105 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 'OF' at line 1
106 SET @@session.low_priority_updates = 'OFN';
107 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'OFN'
108 SET @@session.low_priority_updates = -2;
109 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '-2'
110 SET @@session.low_priority_updates = 65530.34;
111 ERROR 42000: Incorrect argument type to variable 'low_priority_updates'
112 SET @@session.low_priority_updates = 65550;
113 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of '65550'
114 SET @@session.low_priority_updates = test;
115 ERROR 42000: Variable 'low_priority_updates' can't be set to the value of 'test'
116 '#------------------FN_DYNVARS_069_06-----------------------#'
117 SELECT IF(@@global.low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
118 FROM performance_schema.global_variables
119 WHERE VARIABLE_NAME='low_priority_updates';
120 IF(@@global.low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
121 1
122 '#------------------FN_DYNVARS_069_07-----------------------#'
123 SELECT IF(@@session.low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
124 FROM performance_schema.session_variables
125 WHERE VARIABLE_NAME='low_priority_updates';
126 IF(@@session.low_priority_updates, "ON", "OFF") = VARIABLE_VALUE
127 1
128 '#---------------------FN_DYNVARS_069_08----------------------#'
129 SET @@low_priority_updates = FALSE;
130 SET @@global.low_priority_updates = TRUE;
131 SELECT @@low_priority_updates = @@global.low_priority_updates;
132 @@low_priority_updates = @@global.low_priority_updates
133 0
134 '#---------------------FN_DYNVARS_069_09----------------------#'
135 SET @@low_priority_updates = ON;
136 SELECT @@low_priority_updates = @@local.low_priority_updates;
137 @@low_priority_updates = @@local.low_priority_updates
138 1
139 SELECT @@local.low_priority_updates = @@session.low_priority_updates;
140 @@local.low_priority_updates = @@session.low_priority_updates
141 1
142 '#---------------------FN_DYNVARS_069_10----------------------#'
143 SET low_priority_updates = 1;
144 SELECT @@low_priority_updates;
145 @@low_priority_updates
146 1
147 SELECT local.low_priority_updates;
148 ERROR 42S02: Unknown table 'local' in field list
149 SELECT session.low_priority_updates;
150 ERROR 42S02: Unknown table 'session' in field list
151 SELECT low_priority_updates = @@session.low_priority_updates;
152 ERROR 42S22: Unknown column 'low_priority_updates' in 'field list'
153 SET @@global.low_priority_updates = @start_global_value;
154 SELECT @@global.low_priority_updates;
155 @@global.low_priority_updates
156 0
157 SET @@session.low_priority_updates = @start_session_value;
158 SELECT @@session.low_priority_updates;
159 @@session.low_priority_updates
160 0