blob: 9470a7e6100e4121c721bd1a3f03bb786c853ced (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
|
SET @start_global_value = @@global.completion_type;
SELECT @start_global_value;
@start_global_value
NO_CHAIN
SET @start_session_value = @@session.completion_type;
SELECT @start_session_value;
@start_session_value
NO_CHAIN
'#--------------------FN_DYNVARS_017_01-------------------------#'
SET @@global.completion_type = 2;
SET @@global.completion_type = DEFAULT;
SELECT @@global.completion_type;
@@global.completion_type
NO_CHAIN
SET @@session.completion_type = 1;
SET @@session.completion_type = DEFAULT;
SELECT @@session.completion_type;
@@session.completion_type
NO_CHAIN
'#--------------------FN_DYNVARS_017_03-------------------------#'
SET @@global.completion_type = 0;
SELECT @@global.completion_type;
@@global.completion_type
NO_CHAIN
SET @@global.completion_type = 1;
SELECT @@global.completion_type;
@@global.completion_type
CHAIN
SET @@global.completion_type = 2;
SELECT @@global.completion_type;
@@global.completion_type
RELEASE
SET @@global.completion_type = NO_CHAIN;
SELECT @@global.completion_type;
@@global.completion_type
NO_CHAIN
SET @@global.completion_type = CHAIN;
SELECT @@global.completion_type;
@@global.completion_type
CHAIN
SET @@global.completion_type = 'RELEASE';
SELECT @@global.completion_type;
@@global.completion_type
RELEASE
'#--------------------FN_DYNVARS_017_04-------------------------#'
SET @@session.completion_type = 0;
SELECT @@session.completion_type;
@@session.completion_type
NO_CHAIN
SET @@session.completion_type = 1;
SELECT @@session.completion_type;
@@session.completion_type
CHAIN
SET @@session.completion_type = 2;
SELECT @@session.completion_type;
@@session.completion_type
RELEASE
SET @@session.completion_type = 'NO_CHAIN';
SELECT @@session.completion_type;
@@session.completion_type
NO_CHAIN
SET @@session.completion_type = 'CHAIN';
SELECT @@session.completion_type;
@@session.completion_type
CHAIN
SET @@session.completion_type = 'RELEASE';
SELECT @@session.completion_type;
@@session.completion_type
RELEASE
'#------------------FN_DYNVARS_017_05-----------------------#'
set sql_mode=TRADITIONAL;
SET @@global.completion_type = 10;
ERROR 42000: Variable 'completion_type' can't be set to the value of '10'
SET @@global.completion_type = -1024;
ERROR 42000: Variable 'completion_type' can't be set to the value of '-1024'
SET @@global.completion_type = 2.4;
ERROR 42000: Incorrect argument type to variable 'completion_type'
SET @@global.completion_type = OFF;
ERROR 42000: Variable 'completion_type' can't be set to the value of 'OFF'
SET @@session.completion_type = 10;
ERROR 42000: Variable 'completion_type' can't be set to the value of '10'
SET @@session.completion_type = -2;
ERROR 42000: Variable 'completion_type' can't be set to the value of '-2'
SET @@session.completion_type = 1.2;
ERROR 42000: Incorrect argument type to variable 'completion_type'
SET @@session.completion_type = ON;
ERROR 42000: Variable 'completion_type' can't be set to the value of 'ON'
'#------------------FN_DYNVARS_017_06-----------------------#'
SELECT @@global.completion_type = VARIABLE_VALUE
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
WHERE VARIABLE_NAME='completion_type';
@@global.completion_type = VARIABLE_VALUE
1
SELECT @@session.completion_type = VARIABLE_VALUE
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
WHERE VARIABLE_NAME='completion_type';
@@session.completion_type = VARIABLE_VALUE
1
'#------------------FN_DYNVARS_017_07-----------------------#'
SET @@global.completion_type = TRUE;
SELECT @@global.completion_type;
@@global.completion_type
CHAIN
SET @@global.completion_type = FALSE;
SELECT @@global.completion_type;
@@global.completion_type
NO_CHAIN
'#---------------------FN_DYNVARS_001_08----------------------#'
SET @@completion_type = 1;
SELECT @@completion_type = @@local.completion_type;
@@completion_type = @@local.completion_type
1
SELECT @@local.completion_type = @@session.completion_type;
@@local.completion_type = @@session.completion_type
1
'#---------------------FN_DYNVARS_001_09----------------------#'
SET completion_type = 1;
SELECT @@completion_type;
@@completion_type
CHAIN
SET local.completion_type = 1;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'completion_type = 1' at line 1
SELECT local.completion_type;
ERROR 42S02: Unknown table 'local' in field list
SET session.completion_type = 1;
ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'completion_type = 1' at line 1
SELECT session.completion_type;
ERROR 42S02: Unknown table 'session' in field list
SELECT completion_type = @@session.completion_type;
ERROR 42S22: Unknown column 'completion_type' in 'field list'
SET @@global.completion_type = @start_global_value;
SELECT @@global.completion_type;
@@global.completion_type
NO_CHAIN
SET @@session.completion_type = @start_session_value;
SELECT @@session.completion_type;
@@session.completion_type
NO_CHAIN
set sql_mode='';
|
