WL#4681: Took the system variable tests out of the main test suite, put them into "sys_vars", updated some reult files and tests.

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;