diff options
author | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
---|---|---|
committer | Horst Hunger <horst@mysql.com> | 2008-12-19 16:03:32 +0100 |
commit | 357b5009409ed6666bf1df48a80d76cd42a482c8 (patch) | |
tree | 7a2fa9b404ffb20d1572c51a0bca7ecc64992310 /mysql-test/suite/sys_vars/r/sql_quote_show_create_func.result | |
parent | ba816c14a9bc8012759da9d58f858f1e73bec708 (diff) | |
download | mariadb-git-357b5009409ed6666bf1df48a80d76cd42a482c8.tar.gz |
WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.
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; |