summaryrefslogtreecommitdiff
path: root/mysql-test/suite/sys_vars/r/character_set_database_func.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/sys_vars/r/character_set_database_func.result')
-rw-r--r--mysql-test/suite/sys_vars/r/character_set_database_func.result11
1 files changed, 8 insertions, 3 deletions
diff --git a/mysql-test/suite/sys_vars/r/character_set_database_func.result b/mysql-test/suite/sys_vars/r/character_set_database_func.result
index 3cadadd0f3f..f51a025610b 100644
--- a/mysql-test/suite/sys_vars/r/character_set_database_func.result
+++ b/mysql-test/suite/sys_vars/r/character_set_database_func.result
@@ -4,16 +4,17 @@ SET @session_character_set_database = @@session.character_set_database;
SET @session_character_set_server = @@session.character_set_server;
SET @global_character_set_server = @@global.character_set_server;
SET @@global.character_set_database = utf8;
-'connect (con1,localhost,root,,,,)'
-'connection con1'
+connect con1,localhost,root,,,,;
+connection con1;
SELECT @@global.character_set_database;
@@global.character_set_database
utf8
SELECT @@session.character_set_database;
@@session.character_set_database
latin1
+disconnect con1;
'#--------------------FN_DYNVARS_008_02-------------------------#'
-'connection default'
+connection default;
DROP TABLE IF EXISTS t1;
'--check if setting session character_set_database effects new databases'
SET @@session.character_set_server = utf8;
@@ -71,12 +72,16 @@ count(*)
1
DROP TABLE IF EXISTS t1;
SET GLOBAL character_set_server=latin5;
+connect con2, localhost, root,,;
+connection con2;
CREATE DATABASE csdb CHARACTER SET = utf8;
USE csdb;
DROP DATABASE csdb;
SELECT @@character_set_database;
@@character_set_database
latin5
+connection default;
+disconnect con2;
SET @@global.character_set_database = @global_character_set_database;
SET @@session.character_set_database = @session_character_set_database;
SET @@session.character_set_server = @session_character_set_server;