1
SET @session_start_value = @@session.sql_quote_show_create;
2
SELECT @session_start_value;
5
'#--------------------FN_DYNVARS_162_01------------------------#'
6
SET @@session.sql_quote_show_create = 0;
7
SET @@session.sql_quote_show_create = DEFAULT;
8
SELECT @@session.sql_quote_show_create;
9
@@session.sql_quote_show_create
11
SET @@session.sql_quote_show_create = 1;
12
SET @@session.sql_quote_show_create = DEFAULT;
13
SELECT @@session.sql_quote_show_create;
14
@@session.sql_quote_show_create
16
'#---------------------FN_DYNVARS_162_02-------------------------#'
17
SET sql_quote_show_create = 1;
18
SELECT @@sql_quote_show_create;
19
@@sql_quote_show_create
21
SELECT session.sql_quote_show_create;
22
ERROR 42S02: Unknown table 'session' in field list
23
SELECT local.sql_quote_show_create;
24
ERROR 42S02: Unknown table 'local' in field list
25
SET session sql_quote_show_create = 0;
26
SELECT @@session.sql_quote_show_create;
27
@@session.sql_quote_show_create
29
'#--------------------FN_DYNVARS_162_03------------------------#'
30
SET @@session.sql_quote_show_create = 0;
31
SELECT @@session.sql_quote_show_create;
32
@@session.sql_quote_show_create
34
SET @@session.sql_quote_show_create = 1;
35
SELECT @@session.sql_quote_show_create;
36
@@session.sql_quote_show_create
38
'#--------------------FN_DYNVARS_162_04-------------------------#'
39
SET @@session.sql_quote_show_create = -1;
40
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '-1'
41
SET @@session.sql_quote_show_create = 2;
42
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '2'
43
SET @@session.sql_quote_show_create = "T";
44
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'T'
45
SET @@session.sql_quote_show_create = "Y";
46
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'Y'
47
SET @@session.sql_quote_show_create = TR�E;
48
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'TRÜE'
49
SET @@session.sql_quote_show_create = �N;
50
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'ÕN'
51
SET @@session.sql_quote_show_create = OF;
52
SELECT @@session.sql_quote_show_create;
53
@@session.sql_quote_show_create
55
'Bug# 34828: OF is taken as OFF and a value of 0 is set.'
56
SET @@session.sql_quote_show_create = �FF;
57
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'ÓFF'
58
SET @@session.sql_quote_show_create = '�';
59
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '�'
60
SET @@session.sql_quote_show_create = NO;
61
ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'NO'
62
'#-------------------FN_DYNVARS_162_05----------------------------#'
63
SET @@global.sql_quote_show_create = 0;
64
ERROR HY000: Variable 'sql_quote_show_create' is a SESSION variable and can't be used with SET GLOBAL
65
SELECT @@global.sql_quote_show_create;
66
ERROR HY000: Variable 'sql_quote_show_create' is a SESSION variable
67
'#----------------------FN_DYNVARS_162_06------------------------#'
68
SELECT count(VARIABLE_VALUE)
69
FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES
70
WHERE VARIABLE_NAME='sql_quote_show_create';
73
'#----------------------FN_DYNVARS_162_07------------------------#'
74
SELECT @@session.sql_quote_show_create = VARIABLE_VALUE
75
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
76
WHERE VARIABLE_NAME='sql_quote_show_create';
77
@@session.sql_quote_show_create = VARIABLE_VALUE
79
SELECT @@session.sql_quote_show_create;
80
@@session.sql_quote_show_create
83
FROM INFORMATION_SCHEMA.SESSION_VARIABLES
84
WHERE VARIABLE_NAME='sql_quote_show_create';
87
'#---------------------FN_DYNVARS_162_08-------------------------#'
88
SET @@session.sql_quote_show_create = OFF;
89
SELECT @@session.sql_quote_show_create;
90
@@session.sql_quote_show_create
92
SET @@session.sql_quote_show_create = ON;
93
SELECT @@session.sql_quote_show_create;
94
@@session.sql_quote_show_create
96
'#---------------------FN_DYNVARS_162_09----------------------#'
97
SET @@session.sql_quote_show_create = TRUE;
98
SELECT @@session.sql_quote_show_create;
99
@@session.sql_quote_show_create
101
SET @@session.sql_quote_show_create = FALSE;
102
SELECT @@session.sql_quote_show_create;
103
@@session.sql_quote_show_create
105
SET @@session.sql_quote_show_create = @session_start_value;
106
SELECT @@session.sql_quote_show_create;
107
@@session.sql_quote_show_create