diff options
Diffstat (limited to 'mysql-test/suite/sys_vars/r/collation_database_basic.result')
-rw-r--r-- | mysql-test/suite/sys_vars/r/collation_database_basic.result | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/mysql-test/suite/sys_vars/r/collation_database_basic.result b/mysql-test/suite/sys_vars/r/collation_database_basic.result index d4375b7c8e4..50787b4bc7d 100644 --- a/mysql-test/suite/sys_vars/r/collation_database_basic.result +++ b/mysql-test/suite/sys_vars/r/collation_database_basic.result @@ -32,9 +32,12 @@ ERROR 42S22: Unknown column 'global' in 'field list' '#--------------------FN_DYNVARS_016_02-------------------------#' SET @@collation_database = latin1_bin; SET @@collation_database = DEFAULT; +SELECT DEFAULT_COLLATION_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME=DATABASE(); +DEFAULT_COLLATION_NAME +latin1_swedish_ci SELECT @@collation_database AS DEFAULT_VALUE; DEFAULT_VALUE -utf8_unicode_ci +latin1_swedish_ci SET @@global.collation_database = latin1_bin; SET @@global.collation_database = DEFAULT; SELECT @@global.collation_database; |