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 --echo ** Connecting con_int1 using root **
69 connect (con_int1,localhost,root,,);
70
71 --echo ** Connection con_int1 **
72 connection con_int1;
73 SELECT @@SESSION.sql_quote_show_create;
74 --echo 1 / TRUE Expected
75
76 SET SESSION sql_quote_show_create = FALSE;
77
78 --echo ** Connecting con_int2 using root **
79 connect (con_int2,localhost,root,,);
80
81 --echo ** Connection con_int2 **
82 connection con_int2;
83 SELECT @@SESSION.sql_quote_show_create;
84 --echo 1 / TRUE Expected
85
86 SET SESSION sql_quote_show_create = TRUE;
87
88 --echo ** Connection con_int2 **
89 connection con_int2;
90 SELECT @@SESSION.sql_quote_show_create;
91 --echo 1 / TRUE Expected
92
93 --echo ** Connection con_int1 **
94 connection con_int1;
95 SELECT @@SESSION.sql_quote_show_create;
96 --echo 0 / FALSE Expected
97
98 --echo ** Connection default **
99 connection default;
100
101 --echo Disconnecting Connections con_int1, con_int2
102 disconnect con_int1;
103 disconnect con_int2;
104
105
106 #
107 # Cleanup
108 #
109 --echo
110 --echo Cleanup
111
112 SET @@sql_quote_show_create = @default_sql_quote_show_create;
113
114 DROP TABLE t1;