diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/sql_quote_show_create_func.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/sql_quote_show_create_func.result | 61 |
1 files changed, 61 insertions, 0 deletions
diff --git a/mysql-test/suite/sys_vars/r/sql_quote_show_create_func.result b/mysql-test/suite/sys_vars/r/sql_quote_show_create_func.result new file mode 100644 index 00000000000..9c1e751eef2 --- /dev/null +++ b/mysql-test/suite/sys_vars/r/sql_quote_show_create_func.result @@ -0,0 +1,61 @@ +** Setup ** + +SET @default_sql_quote_show_create = @@sql_quote_show_create; +CREATE TEMPORARY TABLE t1(a varchar(20), b varchar(20)); +'#-----------------------------FN_DYNVARS_163_01------------------------------------#' +SET SESSION sql_quote_show_create = TRUE; +SHOW CREATE DATABASE test; +Database Create Database +test CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ +EXPECTING identifiers test TO BE quoted like 'test' +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TEMPORARY TABLE `t1` ( + `a` varchar(20) DEFAULT NULL, + `b` varchar(20) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +EXPECTING identifiers a, b, t1 TO BE quoted like 'a','b','t1' +'#-----------------------------FN_DYNVARS_163_02------------------------------------#' +SET SESSION sql_quote_show_create = FALSE; +SHOW CREATE DATABASE test; +Database Create Database +test CREATE DATABASE test /*!40100 DEFAULT CHARACTER SET latin1 */ +EXPECTING identifiers test NOT TO BE quoted like 'test' +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TEMPORARY TABLE t1 ( + a varchar(20) DEFAULT NULL, + b varchar(20) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +EXPECTING identifiers a, b, t1 NOT TO BE quoted like 'a','b','t1' +'#----------------------------FN_DYNVARS_163_03--------------------------------------#' +** Connecting con_int1 using root ** +** Connection con_int1 ** +SELECT @@SESSION.sql_quote_show_create; +@@SESSION.sql_quote_show_create +1 +1 / TRUE Expected +SET SESSION sql_quote_show_create = FALSE; +** Connecting con_int2 using root ** +** Connection con_int2 ** +SELECT @@SESSION.sql_quote_show_create; +@@SESSION.sql_quote_show_create +1 +1 / TRUE Expected +SET SESSION sql_quote_show_create = TRUE; +** Connection con_int2 ** +SELECT @@SESSION.sql_quote_show_create; +@@SESSION.sql_quote_show_create +1 +1 / TRUE Expected +** Connection con_int1 ** +SELECT @@SESSION.sql_quote_show_create; +@@SESSION.sql_quote_show_create +0 +0 / FALSE Expected +** Connection default ** +Disconnecting Connections con_int1, con_int2 + +Cleanup +SET @@sql_quote_show_create = @default_sql_quote_show_create; +DROP TABLE t1; |