diff options
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.result | 11 |
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; |