1
############# mysql-test\t\sql_quote_show_create_func.test #################
3
# Variable Name: sql_quote_show_create #
5
# Access Type: Dynamic #
7
# Default Value: 1 TRUE #
8
# Values: 1 TRUE, 0 FALSE #
11
# Creation Date: 2008-02-25 #
12
# Author: Sharique Abdullah #
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 #
18
# Reference: http://dev.mysql.com/doc/refman/5.1/en/set-option.html #
20
############################################################################
28
SET @default_sql_quote_show_create = @@sql_quote_show_create;
34
CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
36
--echo '#-----------------------------FN_DYNVARS_163_01------------------------------------#'
41
SET SESSION sql_quote_show_create = TRUE;
43
SHOW CREATE DATABASE test;
44
--echo EXPECTING identifiers test TO BE quoted like 'test'
47
--echo EXPECTING identifiers a, b, t1 TO BE quoted like 'a','b','t1'
50
--echo '#-----------------------------FN_DYNVARS_163_02------------------------------------#'
55
SET SESSION sql_quote_show_create = FALSE;
57
SHOW CREATE DATABASE test;
58
--echo EXPECTING identifiers test NOT TO BE quoted like 'test'
61
--echo EXPECTING identifiers a, b, t1 NOT TO BE quoted like 'a','b','t1'
63
--echo '#----------------------------FN_DYNVARS_163_03--------------------------------------#'
65
# Session data integrity check
68
--echo ** Connecting con_int1 using root **
69
connect (con_int1,localhost,root,,);
71
--echo ** Connection con_int1 **
73
SELECT @@SESSION.sql_quote_show_create;
74
--echo 1 / TRUE Expected
76
SET SESSION sql_quote_show_create = FALSE;
78
--echo ** Connecting con_int2 using root **
79
connect (con_int2,localhost,root,,);
81
--echo ** Connection con_int2 **
83
SELECT @@SESSION.sql_quote_show_create;
84
--echo 1 / TRUE Expected
86
SET SESSION sql_quote_show_create = TRUE;
88
--echo ** Connection con_int2 **
90
SELECT @@SESSION.sql_quote_show_create;
91
--echo 1 / TRUE Expected
93
--echo ** Connection con_int1 **
95
SELECT @@SESSION.sql_quote_show_create;
96
--echo 0 / FALSE Expected
98
--echo ** Connection default **
101
--echo Disconnecting Connections con_int1, con_int2
112
SET @@sql_quote_show_create = @default_sql_quote_show_create;