1SET @session_start_value = @@session.sql_buffer_result;
2SELECT @session_start_value;
3@session_start_value
40
5'#--------------------FN_DYNVARS_155_01------------------------#'
6SET @@session.sql_buffer_result = 0;
7SET @@session.sql_buffer_result = DEFAULT;
8SELECT @@session.sql_buffer_result;
9@@session.sql_buffer_result
100
11SET @@session.sql_buffer_result = 1;
12SET @@session.sql_buffer_result = DEFAULT;
13SELECT @@session.sql_buffer_result;
14@@session.sql_buffer_result
150
16'#---------------------FN_DYNVARS_155_02-------------------------#'
17SET sql_buffer_result = 1;
18SELECT @@sql_buffer_result;
19@@sql_buffer_result
201
21SELECT session.sql_buffer_result;
22ERROR 42S02: Unknown table 'session' in field list
23SELECT local.sql_buffer_result;
24ERROR 42S02: Unknown table 'local' in field list
25SET session sql_buffer_result = 0;
26SELECT @@session.sql_buffer_result;
27@@session.sql_buffer_result
280
29'#--------------------FN_DYNVARS_155_03------------------------#'
30SET @@session.sql_buffer_result = 0;
31SELECT @@session.sql_buffer_result;
32@@session.sql_buffer_result
330
34SET @@session.sql_buffer_result = 1;
35SELECT @@session.sql_buffer_result;
36@@session.sql_buffer_result
371
38'#--------------------FN_DYNVARS_155_04-------------------------#'
39SET @@session.sql_buffer_result = -1;
40ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '-1'
41SET @@session.sql_buffer_result = 2;
42ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '2'
43SET @@session.sql_buffer_result = "TRU";
44ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'TRU'
45SET @@session.sql_buffer_result = 0.4;
46ERROR 42000: Incorrect argument type to variable 'sql_buffer_result'
47SET @@session.sql_buffer_result = TR�E;
48ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'TR�E'
49SET @@session.sql_buffer_result = �N;
50ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '�N'
51SET @@session.sql_buffer_result = OF;
52ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'OF'
53SET @@session.sql_buffer_result = �FF;
54ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '�FF'
55SET @@session.sql_buffer_result = '�';
56ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of '�'
57SET @@session.sql_buffer_result = NO;
58ERROR 42000: Variable 'sql_buffer_result' can't be set to the value of 'NO'
59'#-------------------FN_DYNVARS_155_05----------------------------#'
60SET @@global.sql_buffer_result = 1-@@global.sql_buffer_result;
61SELECT @@global.sql_buffer_result;
62@@global.sql_buffer_result
631
64SET @@global.sql_buffer_result = 1-@@global.sql_buffer_result;
65SELECT @@global.sql_buffer_result;
66@@global.sql_buffer_result
670
68'#----------------------FN_DYNVARS_155_06------------------------#'
69SELECT count(VARIABLE_VALUE)
70FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
71WHERE VARIABLE_NAME='sql_buffer_result';
72count(VARIABLE_VALUE)
731
74'#----------------------FN_DYNVARS_155_07------------------------#'
75SELECT IF(@@session.sql_buffer_result, "ON", "OFF") = VARIABLE_VALUE
76FROM INFORMATION_SCHEMA.SESSION_VARIABLES
77WHERE VARIABLE_NAME='sql_buffer_result';
78IF(@@session.sql_buffer_result, "ON", "OFF") = VARIABLE_VALUE
791
80SELECT @@session.sql_buffer_result;
81@@session.sql_buffer_result
821
83SELECT VARIABLE_VALUE
84FROM INFORMATION_SCHEMA.SESSION_VARIABLES
85WHERE VARIABLE_NAME='sql_buffer_result';
86VARIABLE_VALUE
87ON
88'#---------------------FN_DYNVARS_155_08-------------------------#'
89SET @@session.sql_buffer_result = OFF;
90SELECT @@session.sql_buffer_result;
91@@session.sql_buffer_result
920
93SET @@session.sql_buffer_result = ON;
94SELECT @@session.sql_buffer_result;
95@@session.sql_buffer_result
961
97'#---------------------FN_DYNVARS_155_09----------------------#'
98SET @@session.sql_buffer_result = TRUE;
99SELECT @@session.sql_buffer_result;
100@@session.sql_buffer_result
1011
102SET @@session.sql_buffer_result = FALSE;
103SELECT @@session.sql_buffer_result;
104@@session.sql_buffer_result
1050
106SET @@session.sql_buffer_result = @session_start_value;
107SELECT @@session.sql_buffer_result;
108@@session.sql_buffer_result
1090
110