Debian Codegraph @

mysql-test/suite/sys_vars/t/sql_quote_show_create_func.test

raw
1 ############# mysql-test\t\sql_quote_show_create_func.test #################
2 # #
3 # Variable Name: sql_quote_show_create #
4 # Scope: SESSION #
5 # Access Type: Dynamic #
6 # Data Type: BOOLEAN #
7 # Default Value: 1 TRUE #
8 # Values: 1 TRUE, 0 FALSE #
9 # #
10 # #
11 # Creation Date: 2008-02-25 #
12 # Author: Sharique Abdullah #
13 # #
14 # Description: Test Cases of Dynamic System Variable sql_quote_show_create#
15 # that checks behavior of this variable in the following ways #
16 # * Functionality based on different values #
17 # #
18 # Reference: http://dev.mysql.com/doc/refman/5.1/en/set-option.html #
19 # #
20 ############################################################################
21
22 --echo ** Setup **
23 --echo
24 #
25 # Setup
26 #
27
28 SET @default_sql_quote_show_create = @@sql_quote_show_create;
29
30 #
31 # Creating tables
32 #
33
34 CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
35
36 --echo '#-----------------------------FN_DYNVARS_163_01------------------------------------#'
37 #
38 # Value TRUE
39 #
40
41 SET SESSION sql_quote_show_create = TRUE;
42
43 SHOW CREATE DATABASE test;
44 --echo EXPECTING identifiers test TO BE quoted like 'test'
45
46 SHOW CREATE TABLE t1;
47 --echo EXPECTING identifiers a, b, t1 TO BE quoted like 'a','b','t1'
48
49
50 --echo '#-----------------------------FN_DYNVARS_163_02------------------------------------#'
51 #
52 # Value FALSE
53 #
54
55 SET SESSION sql_quote_show_create = FALSE;
56
57 SHOW CREATE DATABASE test;
58 --echo EXPECTING identifiers test NOT TO BE quoted like 'test'
59
60 SHOW CREATE TABLE t1;
61 --echo EXPECTING identifiers a, b, t1 NOT TO BE quoted like 'a','b','t1'
62
63 --echo '#----------------------------FN_DYNVARS_163_03--------------------------------------#'
64 #
65 # Session data integrity check
66 #
67
68 connect (con_int1,localhost,root,,);
69
70 connection con_int1;
71 SELECT @@SESSION.sql_quote_show_create;
72 --echo 1 / TRUE Expected
73
74 SET SESSION sql_quote_show_create = FALSE;
75
76 connect (con_int2,localhost,root,,);
77
78 connection con_int2;
79 SELECT @@SESSION.sql_quote_show_create;
80 --echo 1 / TRUE Expected
81
82 SET SESSION sql_quote_show_create = TRUE;
83
84 connection con_int2;
85 SELECT @@SESSION.sql_quote_show_create;
86 --echo 1 / TRUE Expected
87
88 connection con_int1;
89 SELECT @@SESSION.sql_quote_show_create;
90 --echo 0 / FALSE Expected
91
92 connection default;
93
94 disconnect con_int1;
95 disconnect con_int2;
96
97
98 #
99 # Cleanup
100 #
101 --echo
102 --echo Cleanup
103
104 SET @@sql_quote_show_create = @default_sql_quote_show_create;
105
106 DROP TABLE t1;