1** Setup **
2
3SET @default_sql_quote_show_create = @@sql_quote_show_create;
4CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20));
5'#-----------------------------FN_DYNVARS_163_01------------------------------------#'
6SET SESSION sql_quote_show_create = TRUE;
7SHOW CREATE DATABASE test;
8Database	Create Database
9test	CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */
10EXPECTING identifiers test TO BE quoted like 'test'
11SHOW CREATE TABLE t1;
12Table	Create Table
13t1	CREATE TEMPORARY TABLE `t1` (
14  `a` varchar(20) DEFAULT NULL,
15  `b` varchar(20) DEFAULT NULL
16) ENGINE=InnoDB DEFAULT CHARSET=latin1
17EXPECTING identifiers a, b, t1 TO BE quoted like 'a','b','t1'
18'#-----------------------------FN_DYNVARS_163_02------------------------------------#'
19SET SESSION sql_quote_show_create = FALSE;
20SHOW CREATE DATABASE test;
21Database	Create Database
22test	CREATE DATABASE test /*!40100 DEFAULT CHARACTER SET latin1 */
23EXPECTING identifiers test NOT TO BE quoted like 'test'
24SHOW CREATE TABLE t1;
25Table	Create Table
26t1	CREATE TEMPORARY TABLE t1 (
27  a varchar(20) DEFAULT NULL,
28  b varchar(20) DEFAULT NULL
29) ENGINE=InnoDB DEFAULT CHARSET=latin1
30EXPECTING identifiers a, b, t1 NOT TO BE quoted like 'a','b','t1'
31'#----------------------------FN_DYNVARS_163_03--------------------------------------#'
32** Connecting con_int1 using root **
33** Connection con_int1 **
34SELECT @@SESSION.sql_quote_show_create;
35@@SESSION.sql_quote_show_create
361
371 / TRUE Expected
38SET SESSION sql_quote_show_create = FALSE;
39** Connecting con_int2 using root **
40** Connection con_int2 **
41SELECT @@SESSION.sql_quote_show_create;
42@@SESSION.sql_quote_show_create
431
441 / TRUE Expected
45SET SESSION sql_quote_show_create = TRUE;
46** Connection con_int2 **
47SELECT @@SESSION.sql_quote_show_create;
48@@SESSION.sql_quote_show_create
491
501 / TRUE Expected
51** Connection con_int1 **
52SELECT @@SESSION.sql_quote_show_create;
53@@SESSION.sql_quote_show_create
540
550 / FALSE Expected
56** Connection default **
57Disconnecting Connections con_int1, con_int2
58
59Cleanup
60SET @@sql_quote_show_create = @default_sql_quote_show_create;
61DROP TABLE t1;
62