Debian Codegraph @

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

raw
1 SET @session_start_value = @@session.sql_buffer_result;
2 SELECT @session_start_value;
3 @session_start_value
4 0
5 '#--------------------FN_DYNVARS_155_01------------------------#'
6 SET @@session.sql_buffer_result = 0;
7 SET @@session.sql_buffer_result = DEFAULT;
8 SELECT @@session.sql_buffer_result;
9 @@session.sql_buffer_result
10 0
11 SET @@session.sql_buffer_result = 1;
12 SET @@session.sql_buffer_result = DEFAULT;
13 SELECT @@session.sql_buffer_result;
14 @@session.sql_buffer_result
15 0
16 '#---------------------FN_DYNVARS_155_02-------------------------#'
17 SET sql_buffer_result = 1;
18 SELECT @@sql_buffer_result;
19 @@sql_buffer_result
20 1
21 SELECT session.sql_buffer_result;
22 ERROR 42S02: Unknown table 'session' in field list
23 SELECT local.sql_buffer_result;
24 ERROR 42S02: Unknown table 'local' in field list
25 SET session sql_buffer_result = 0;
26 SELECT @@session.sql_buffer_result;
27 @@session.sql_buffer_result
28 0
29 '#--------------------FN_DYNVARS_155_03------------------------#'
30 SET @@session.sql_buffer_result = 0;
31 SELECT @@session.sql_buffer_result;
32 @@session.sql_buffer_result
33 0
34 SET @@session.sql_buffer_result = 1;
35 SELECT @@session.sql_buffer_result;
36 @@session.sql_buffer_result
37 1
38 '#--------------------FN_DYNVARS_155_04-------------------------#'
39 SET @@session.sql_buffer_result = -1;
40 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '-1'
41 SET @@session.sql_buffer_result = 2;
42 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '2'
43 SET @@session.sql_buffer_result = "TRU";
44 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'TRU'
45 SET @@session.sql_buffer_result = 0.4;
46 ERROR 42000: Incorrect argument type to variable 'sql_buffer_result'
47 SET @@session.sql_buffer_result = TRÜE;
48 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'TRÜE'
49 SET @@session.sql_buffer_result = ÕN;
50 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'ÕN'
51 SET @@session.sql_buffer_result = OF;
52 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
53 SET @@session.sql_buffer_result = ÓFF;
54 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'ÓFF'
55 SET @@session.sql_buffer_result = '¹';
56 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '¹'
57 SET @@session.sql_buffer_result = NO;
58 ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'NO'
59 '#-------------------FN_DYNVARS_155_05----------------------------#'
60 SET @@global.sql_buffer_result = 1-@@global.sql_buffer_result;
61 SELECT @@global.sql_buffer_result;
62 @@global.sql_buffer_result
63 1
64 SET @@global.sql_buffer_result = 1-@@global.sql_buffer_result;
65 SELECT @@global.sql_buffer_result;
66 @@global.sql_buffer_result
67 0
68 '#----------------------FN_DYNVARS_155_06------------------------#'
69 SELECT count(VARIABLE_VALUE)
70 FROM performance_schema.global_variables
71 WHERE VARIABLE_NAME='sql_buffer_result';
72 count(VARIABLE_VALUE)
73 1
74 '#----------------------FN_DYNVARS_155_07------------------------#'
75 SELECT IF(@@session.sql_buffer_result, "ON", "OFF") = VARIABLE_VALUE
76 FROM performance_schema.session_variables
77 WHERE VARIABLE_NAME='sql_buffer_result';
78 IF(@@session.sql_buffer_result, "ON", "OFF") = VARIABLE_VALUE
79 1
80 SELECT @@session.sql_buffer_result;
81 @@session.sql_buffer_result
82 1
83 SELECT VARIABLE_VALUE
84 FROM performance_schema.session_variables
85 WHERE VARIABLE_NAME='sql_buffer_result';
86 VARIABLE_VALUE
87 ON
88 '#---------------------FN_DYNVARS_155_08-------------------------#'
89 SET @@session.sql_buffer_result = OFF;
90 SELECT @@session.sql_buffer_result;
91 @@session.sql_buffer_result
92 0
93 SET @@session.sql_buffer_result = ON;
94 SELECT @@session.sql_buffer_result;
95 @@session.sql_buffer_result
96 1
97 '#---------------------FN_DYNVARS_155_09----------------------#'
98 SET @@session.sql_buffer_result = TRUE;
99 SELECT @@session.sql_buffer_result;
100 @@session.sql_buffer_result
101 1
102 SET @@session.sql_buffer_result = FALSE;
103 SELECT @@session.sql_buffer_result;
104 @@session.sql_buffer_result
105 0
106 SET @@session.sql_buffer_result = @session_start_value;
107 SELECT @@session.sql_buffer_result;
108 @@session.sql_buffer_result
109 0