Debian Codegraph @

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

raw
1 SET @session_start_value = @@session.sql_quote_show_create;
2 SELECT @session_start_value;
3 @session_start_value
4 1
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
10 1
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
15 1
16 '#---------------------FN_DYNVARS_162_02-------------------------#'
17 SET sql_quote_show_create = 1;
18 SELECT @@sql_quote_show_create;
19 @@sql_quote_show_create
20 1
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
28 0
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
33 0
34 SET @@session.sql_quote_show_create = 1;
35 SELECT @@session.sql_quote_show_create;
36 @@session.sql_quote_show_create
37 1
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 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_quote_show_create = ÓFF;
54 ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'ÓFF'
55 SET @@session.sql_quote_show_create = '¹';
56 ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of '¹'
57 SET @@session.sql_quote_show_create = NO;
58 ERROR 42000: Variable 'sql_quote_show_create' can't be set to the value of 'NO'
59 '#-------------------FN_DYNVARS_162_05----------------------------#'
60 SET @@global.sql_quote_show_create = 1-@@global.sql_quote_show_create;
61 SELECT @@global.sql_quote_show_create;
62 @@global.sql_quote_show_create
63 0
64 SET @@global.sql_quote_show_create = 1-@@global.sql_quote_show_create;
65 SELECT @@global.sql_quote_show_create;
66 @@global.sql_quote_show_create
67 1
68 '#----------------------FN_DYNVARS_162_06------------------------#'
69 SELECT count(VARIABLE_VALUE)
70 FROM performance_schema.global_variables
71 WHERE VARIABLE_NAME='sql_quote_show_create';
72 count(VARIABLE_VALUE)
73 1
74 '#----------------------FN_DYNVARS_162_07------------------------#'
75 SELECT IF(@@session.sql_quote_show_create, "ON", "OFF") = VARIABLE_VALUE
76 FROM performance_schema.session_variables
77 WHERE VARIABLE_NAME='sql_quote_show_create';
78 IF(@@session.sql_quote_show_create, "ON", "OFF") = VARIABLE_VALUE
79 1
80 SELECT @@session.sql_quote_show_create;
81 @@session.sql_quote_show_create
82 1
83 SELECT VARIABLE_VALUE
84 FROM performance_schema.session_variables
85 WHERE VARIABLE_NAME='sql_quote_show_create';
86 VARIABLE_VALUE
87 ON
88 '#---------------------FN_DYNVARS_162_08-------------------------#'
89 SET @@session.sql_quote_show_create = OFF;
90 SELECT @@session.sql_quote_show_create;
91 @@session.sql_quote_show_create
92 0
93 SET @@session.sql_quote_show_create = ON;
94 SELECT @@session.sql_quote_show_create;
95 @@session.sql_quote_show_create
96 1
97 '#---------------------FN_DYNVARS_162_09----------------------#'
98 SET @@session.sql_quote_show_create = TRUE;
99 SELECT @@session.sql_quote_show_create;
100 @@session.sql_quote_show_create
101 1
102 SET @@session.sql_quote_show_create = FALSE;
103 SELECT @@session.sql_quote_show_create;
104 @@session.sql_quote_show_create
105 0
106 SET @@session.sql_quote_show_create = @session_start_value;
107 SELECT @@session.sql_quote_show_create;
108 @@session.sql_quote_show_create
109 1