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