1SET @start_global_value = @@global.completion_type;
2SELECT @start_global_value;
3@start_global_value
4NO_CHAIN
5SET @start_session_value = @@session.completion_type;
6SELECT @start_session_value;
7@start_session_value
8NO_CHAIN
9'#--------------------FN_DYNVARS_017_01-------------------------#'
10SET @@global.completion_type = 2;
11SET @@global.completion_type = DEFAULT;
12SELECT @@global.completion_type;
13@@global.completion_type
14NO_CHAIN
15SET @@session.completion_type = 1;
16SET @@session.completion_type = DEFAULT;
17SELECT @@session.completion_type;
18@@session.completion_type
19NO_CHAIN
20'#--------------------FN_DYNVARS_017_03-------------------------#'
21SET @@global.completion_type = 0;
22SELECT @@global.completion_type;
23@@global.completion_type
24NO_CHAIN
25SET @@global.completion_type = 1;
26SELECT @@global.completion_type;
27@@global.completion_type
28CHAIN
29SET @@global.completion_type = 2;
30SELECT @@global.completion_type;
31@@global.completion_type
32RELEASE
33SET @@global.completion_type = NO_CHAIN;
34SELECT @@global.completion_type;
35@@global.completion_type
36NO_CHAIN
37SET @@global.completion_type = CHAIN;
38SELECT @@global.completion_type;
39@@global.completion_type
40CHAIN
41SET @@global.completion_type = 'RELEASE';
42SELECT @@global.completion_type;
43@@global.completion_type
44RELEASE
45'#--------------------FN_DYNVARS_017_04-------------------------#'
46SET @@session.completion_type = 0;
47SELECT @@session.completion_type;
48@@session.completion_type
49NO_CHAIN
50SET @@session.completion_type = 1;
51SELECT @@session.completion_type;
52@@session.completion_type
53CHAIN
54SET @@session.completion_type = 2;
55SELECT @@session.completion_type;
56@@session.completion_type
57RELEASE
58SET @@session.completion_type = 'NO_CHAIN';
59SELECT @@session.completion_type;
60@@session.completion_type
61NO_CHAIN
62SET @@session.completion_type = 'CHAIN';
63SELECT @@session.completion_type;
64@@session.completion_type
65CHAIN
66SET @@session.completion_type = 'RELEASE';
67SELECT @@session.completion_type;
68@@session.completion_type
69RELEASE
70'#------------------FN_DYNVARS_017_05-----------------------#'
71set sql_mode=TRADITIONAL;
72SET @@global.completion_type = 10;
73ERROR 42000: Variable 'completion_type' can't be set to the value of '10'
74SET @@global.completion_type = -1024;
75ERROR 42000: Variable 'completion_type' can't be set to the value of '-1024'
76SET @@global.completion_type = 2.4;
77ERROR 42000: Incorrect argument type to variable 'completion_type'
78SET @@global.completion_type = OFF;
79ERROR 42000: Variable 'completion_type' can't be set to the value of 'OFF'
80SET @@session.completion_type = 10;
81ERROR 42000: Variable 'completion_type' can't be set to the value of '10'
82SET @@session.completion_type = -2;
83ERROR 42000: Variable 'completion_type' can't be set to the value of '-2'
84SET @@session.completion_type = 1.2;
85ERROR 42000: Incorrect argument type to variable 'completion_type'
86SET @@session.completion_type = ON;
87ERROR 42000: Variable 'completion_type' can't be set to the value of 'ON'
88'#------------------FN_DYNVARS_017_06-----------------------#'
89SELECT @@global.completion_type = VARIABLE_VALUE
90FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
91WHERE VARIABLE_NAME='completion_type';
92@@global.completion_type = VARIABLE_VALUE
931
94SELECT @@session.completion_type = VARIABLE_VALUE
95FROM INFORMATION_SCHEMA.SESSION_VARIABLES
96WHERE VARIABLE_NAME='completion_type';
97@@session.completion_type = VARIABLE_VALUE
981
99'#------------------FN_DYNVARS_017_07-----------------------#'
100SET @@global.completion_type = TRUE;
101SELECT @@global.completion_type;
102@@global.completion_type
103CHAIN
104SET @@global.completion_type = FALSE;
105SELECT @@global.completion_type;
106@@global.completion_type
107NO_CHAIN
108'#---------------------FN_DYNVARS_001_08----------------------#'
109SET @@completion_type = 1;
110SELECT @@completion_type = @@local.completion_type;
111@@completion_type = @@local.completion_type
1121
113SELECT @@local.completion_type = @@session.completion_type;
114@@local.completion_type = @@session.completion_type
1151
116'#---------------------FN_DYNVARS_001_09----------------------#'
117SET completion_type = 1;
118SELECT @@completion_type;
119@@completion_type
120CHAIN
121SET local.completion_type = 1;
122ERROR 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.completion_type = 1' at line 1
123SELECT local.completion_type;
124ERROR 42S02: Unknown table 'local' in field list
125SET session.completion_type = 1;
126ERROR 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 'session.completion_type = 1' at line 1
127SELECT session.completion_type;
128ERROR 42S02: Unknown table 'session' in field list
129SELECT completion_type = @@session.completion_type;
130ERROR 42S22: Unknown column 'completion_type' in 'field list'
131SET @@global.completion_type = @start_global_value;
132SELECT @@global.completion_type;
133@@global.completion_type
134NO_CHAIN
135SET @@session.completion_type = @start_session_value;
136SELECT @@session.completion_type;
137@@session.completion_type
138NO_CHAIN
139set sql_mode='';
140Warnings:
141Warning	3090	Changing sql mode 'NO_AUTO_CREATE_USER' is deprecated. It will be removed in a future release.
142