diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/t/character_set_database_basic.test')
-rw-r--r-- | mysql-test/suite/sys_vars/t/character_set_database_basic.test | 20 |
1 files changed, 16 insertions, 4 deletions
diff --git a/mysql-test/suite/sys_vars/t/character_set_database_basic.test b/mysql-test/suite/sys_vars/t/character_set_database_basic.test index 54ccc5afddb..95ffa83950f 100644 --- a/mysql-test/suite/sys_vars/t/character_set_database_basic.test +++ b/mysql-test/suite/sys_vars/t/character_set_database_basic.test @@ -154,30 +154,42 @@ SELECT @@global.character_set_database; ############################################################## SET @@character_set_database = 1; SELECT @@character_set_database; + +--echo # latin2_czech_cs is not a default collation +--error ER_UNKNOWN_CHARACTER_SET SET @@character_set_database = 2; -SELECT @@character_set_database; + SET @@character_set_database = 3; SELECT @@character_set_database; SET @@character_set_database = 36; SELECT @@character_set_database; + +--echo # cp1250_polish_ci is not a default collation +--error ER_UNKNOWN_CHARACTER_SET SET @@character_set_database = 99; -SELECT @@character_set_database; +--echo # Collation ID 100 does not exist --Error ER_UNKNOWN_CHARACTER_SET SET @@character_set_database = 100; SET @@global.character_set_database = 1; SELECT @@global.character_set_database; + +--echo # latin2_czech_cs is not a default collation +--error ER_UNKNOWN_CHARACTER_SET SET @@global.character_set_database = 2; -SELECT @@global.character_set_database; + SET @@global.character_set_database = 3; SELECT @@global.character_set_database; SET @@global.character_set_database = 36; SELECT @@global.character_set_database; + +--echo # cp1250_polish_ci is not a default collation +--error ER_UNKNOWN_CHARACTER_SET SET @@global.character_set_database = 99; -SELECT @@global.character_set_database; +--echo # Collation ID 100 does not exist --Error ER_UNKNOWN_CHARACTER_SET SET @@global.character_set_database = 100; |