diff options
Diffstat (limited to 'mysql-test/r/character_set_database_basic.result')
| -rw-r--r-- | mysql-test/r/character_set_database_basic.result | 507 |
1 files changed, 507 insertions, 0 deletions
diff --git a/mysql-test/r/character_set_database_basic.result b/mysql-test/r/character_set_database_basic.result new file mode 100644 index 00000000000..4380fea4c81 --- /dev/null +++ b/mysql-test/r/character_set_database_basic.result @@ -0,0 +1,507 @@ +SET @global_start_value = @@global.character_set_database; +SELECT @global_start_value; +@global_start_value +latin1 +SET @session_start_value = @@character_set_database; +SELECT @session_start_value; +@session_start_value +latin1 +SET @session_start_value = @@local.character_set_database; +SELECT @session_start_value; +@session_start_value +latin1 +SET @session_start_value = @@session.character_set_database; +SELECT @session_start_value; +@session_start_value +latin1 +'#--------------------FN_DYNVARS_012_01------------------#' +SELECT character_set_database; +ERROR 42S22: Unknown column 'character_set_database' in 'field list' +SET character_set_database=utf8; +SELECT @@session.character_set_database; +@@session.character_set_database +utf8 +SET global.character_set_database=utf8; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character_set_database=utf8' at line 1 +SET session character_set_database=utf8; +SELECT session character_set_database; +ERROR 42S22: Unknown column 'session' in 'field list' +SET global character_set_database=utf8; +SELECT global character_set_database; +ERROR 42S22: Unknown column 'global' in 'field list' +'#--------------------FN_DYNVARS_012_02-------------------------#' +SET @@character_set_database = latin5; +SET @@character_set_database = DEFAULT; +SELECT @@character_set_database AS DEFAULT_VALUE; +DEFAULT_VALUE +latin1 +SET @@global.character_set_database = latin5; +SET @@global.character_set_database = DEFAULT; +SELECT @@global.character_set_database; +@@global.character_set_database +latin1 +'#--------------------FN_DYNVARS_012_03-------------------------#' +SET @@session.character_set_database = utf8; +SELECT @@session.character_set_database; +@@session.character_set_database +utf8 +SET @@global.character_set_database = latin2; +SELECT @@global.character_set_database; +@@global.character_set_database +latin2 +SELECT @@session.character_set_database AS res_is_utf8; +res_is_utf8 +utf8 +SET @@session.character_set_database = latin5; +SELECT @@session.character_set_database; +@@session.character_set_database +latin5 +SELECT @@global.character_set_database AS res_is_latin2; +res_is_latin2 +latin2 +SELECT @@global.character_set_database=@@session.character_set_database +AS res_is_false; +res_is_false +0 +'#--------------------FN_DYNVARS_012_04-------------------------#' +SELECT @@character_set_database = @@session.character_set_database AS res; +res +1 +SELECT @@character_set_database = @@local.character_set_database AS res; +res +1 +'#--------------------FN_DYNVARS_012_05-------------------------#' +SET @@character_set_database = utf8 + latin2; +ERROR 42S22: Unknown column 'utf8' in 'field list' +'#--------------------FN_DYNVARS_012_06-------------------------#' +SET @@session.character_set_database = big5; +SELECT @@session.character_set_database; +@@session.character_set_database +big5 +SET @@session.character_set_database = dec8; +SELECT @@session.character_set_database; +@@session.character_set_database +dec8 +SET @@session.character_set_database = cp850; +SELECT @@session.character_set_database; +@@session.character_set_database +cp850 +SET @@session.character_set_database = hp8; +SELECT @@session.character_set_database; +@@session.character_set_database +hp8 +SET @@session.character_set_database = koi8r; +SELECT @@session.character_set_database; +@@session.character_set_database +koi8r +SET @@session.character_set_database = latin1; +SELECT @@session.character_set_database; +@@session.character_set_database +latin1 +SET @@session.character_set_database = latin2; +SELECT @@session.character_set_database; +@@session.character_set_database +latin2 +SET @@session.character_set_database = swe7; +SELECT @@session.character_set_database; +@@session.character_set_database +swe7 +SET @@session.character_set_database = ascii; +SELECT @@session.character_set_database; +@@session.character_set_database +ascii +SET @@session.character_set_database = ujis; +SELECT @@session.character_set_database; +@@session.character_set_database +ujis +SET @@session.character_set_database = sjis; +SELECT @@session.character_set_database; +@@session.character_set_database +sjis +SET @@session.character_set_database = hebrew; +SELECT @@session.character_set_database; +@@session.character_set_database +hebrew +SET @@session.character_set_database = tis620; +SELECT @@session.character_set_database; +@@session.character_set_database +tis620 +SET @@session.character_set_database = euckr; +SELECT @@session.character_set_database; +@@session.character_set_database +euckr +SET @@session.character_set_database = koi8u; +SELECT @@session.character_set_database; +@@session.character_set_database +koi8u +SET @@session.character_set_database = gb2312; +SELECT @@session.character_set_database; +@@session.character_set_database +gb2312 +SET @@session.character_set_database = greek; +SELECT @@session.character_set_database; +@@session.character_set_database +greek +SET @@session.character_set_database = cp1250; +SELECT @@session.character_set_database; +@@session.character_set_database +cp1250 +SET @@session.character_set_database = gbk; +SELECT @@session.character_set_database; +@@session.character_set_database +gbk +SET @@session.character_set_database = latin5; +SELECT @@session.character_set_database; +@@session.character_set_database +latin5 +SET @@session.character_set_database = armscii8; +SELECT @@session.character_set_database; +@@session.character_set_database +armscii8 +SET @@session.character_set_database = utf8; +SELECT @@session.character_set_database; +@@session.character_set_database +utf8 +SET @@session.character_set_database = ucs2; +SELECT @@session.character_set_database; +@@session.character_set_database +ucs2 +SET @@session.character_set_database = cp866; +SELECT @@session.character_set_database; +@@session.character_set_database +cp866 +SET @@session.character_set_database = keybcs2; +SELECT @@session.character_set_database; +@@session.character_set_database +keybcs2 +SET @@session.character_set_database = macce; +SELECT @@session.character_set_database; +@@session.character_set_database +macce +SET @@session.character_set_database = macroman; +SELECT @@session.character_set_database; +@@session.character_set_database +macroman +SET @@session.character_set_database = cp852; +SELECT @@session.character_set_database; +@@session.character_set_database +cp852 +SET @@session.character_set_database = latin7; +SELECT @@session.character_set_database; +@@session.character_set_database +latin7 +SET @@session.character_set_database = cp1251; +SELECT @@session.character_set_database; +@@session.character_set_database +cp1251 +SET @@session.character_set_database = cp1256; +SELECT @@session.character_set_database; +@@session.character_set_database +cp1256 +SET @@session.character_set_database = cp1257; +SELECT @@session.character_set_database; +@@session.character_set_database +cp1257 +SET @@session.character_set_database = binary; +SELECT @@session.character_set_database; +@@session.character_set_database +binary +SET @@session.character_set_database = geostd8; +SELECT @@session.character_set_database; +@@session.character_set_database +geostd8 +SET @@session.character_set_database = cp932; +SELECT @@session.character_set_database; +@@session.character_set_database +cp932 +SET @@session.character_set_database = eucjpms; +SELECT @@session.character_set_database; +@@session.character_set_database +eucjpms +'#--------------------FN_DYNVARS_012_07-------------------------#' +SET @@global.character_set_database = big5; +SELECT @@global.character_set_database; +@@global.character_set_database +big5 +SET @@global.character_set_database = dec8; +SELECT @@global.character_set_database; +@@global.character_set_database +dec8 +SET @@global.character_set_database = cp850; +SELECT @@global.character_set_database; +@@global.character_set_database +cp850 +SET @@global.character_set_database = hp8; +SELECT @@global.character_set_database; +@@global.character_set_database +hp8 +SET @@global.character_set_database = koi8r; +SELECT @@global.character_set_database; +@@global.character_set_database +koi8r +SET @@global.character_set_database = latin1; +SELECT @@global.character_set_database; +@@global.character_set_database +latin1 +SET @@global.character_set_database = latin2; +SELECT @@global.character_set_database; +@@global.character_set_database +latin2 +SET @@global.character_set_database = swe7; +SELECT @@global.character_set_database; +@@global.character_set_database +swe7 +SET @@global.character_set_database = ascii; +SELECT @@global.character_set_database; +@@global.character_set_database +ascii +SET @@global.character_set_database = ujis; +SELECT @@global.character_set_database; +@@global.character_set_database +ujis +SET @@global.character_set_database = sjis; +SELECT @@global.character_set_database; +@@global.character_set_database +sjis +SET @@global.character_set_database = hebrew; +SELECT @@global.character_set_database; +@@global.character_set_database +hebrew +SET @@global.character_set_database = tis620; +SELECT @@global.character_set_database; +@@global.character_set_database +tis620 +SET @@global.character_set_database = euckr; +SELECT @@global.character_set_database; +@@global.character_set_database +euckr +SET @@global.character_set_database = koi8u; +SELECT @@global.character_set_database; +@@global.character_set_database +koi8u +SET @@global.character_set_database = gb2312; +SELECT @@global.character_set_database; +@@global.character_set_database +gb2312 +SET @@global.character_set_database = greek; +SELECT @@global.character_set_database; +@@global.character_set_database +greek +SET @@global.character_set_database = cp1250; +SELECT @@global.character_set_database; +@@global.character_set_database +cp1250 +SET @@global.character_set_database = gbk; +SELECT @@global.character_set_database; +@@global.character_set_database +gbk +SET @@global.character_set_database = latin5; +SELECT @@global.character_set_database; +@@global.character_set_database +latin5 +SET @@global.character_set_database = armscii8; +SELECT @@global.character_set_database; +@@global.character_set_database +armscii8 +SET @@global.character_set_database = utf8; +SELECT @@global.character_set_database; +@@global.character_set_database +utf8 +SET @@global.character_set_database = ucs2; +SELECT @@global.character_set_database; +@@global.character_set_database +ucs2 +SET @@global.character_set_database = cp866; +SELECT @@global.character_set_database; +@@global.character_set_database +cp866 +SET @@global.character_set_database = keybcs2; +SELECT @@global.character_set_database; +@@global.character_set_database +keybcs2 +SET @@global.character_set_database = macce; +SELECT @@global.character_set_database; +@@global.character_set_database +macce +SET @@global.character_set_database = macroman; +SELECT @@global.character_set_database; +@@global.character_set_database +macroman +SET @@global.character_set_database = cp852; +SELECT @@global.character_set_database; +@@global.character_set_database +cp852 +SET @@global.character_set_database = latin7; +SELECT @@global.character_set_database; +@@global.character_set_database +latin7 +SET @@global.character_set_database = cp1251; +SELECT @@global.character_set_database; +@@global.character_set_database +cp1251 +SET @@global.character_set_database = cp1256; +SELECT @@global.character_set_database; +@@global.character_set_database +cp1256 +SET @@global.character_set_database = cp1257; +SELECT @@global.character_set_database; +@@global.character_set_database +cp1257 +SET @@global.character_set_database = binary; +SELECT @@global.character_set_database; +@@global.character_set_database +binary +SET @@global.character_set_database = geostd8; +SELECT @@global.character_set_database; +@@global.character_set_database +geostd8 +SET @@global.character_set_database = cp932; +SELECT @@global.character_set_database; +@@global.character_set_database +cp932 +SET @@global.character_set_database = eucjpms; +SELECT @@global.character_set_database; +@@global.character_set_database +eucjpms +'#--------------------FN_DYNVARS_012_08-------------------------#' +SET @@character_set_database = UTF8; +SELECT @@character_set_database; +@@character_set_database +utf8 +SET @@character_set_database = utf8; +SELECT @@character_set_database; +@@character_set_database +utf8 +SET @@global.character_set_database = uTf8; +SELECT @@global.character_set_database; +@@global.character_set_database +utf8 +'#--------------------FN_DYNVARS_012_09-------------------------#' +SET @@character_set_database = 1; +SELECT @@character_set_database; +@@character_set_database +big5 +SET @@character_set_database = 2; +SELECT @@character_set_database; +@@character_set_database +latin2 +SET @@character_set_database = 3; +SELECT @@character_set_database; +@@character_set_database +dec8 +SET @@character_set_database = 36; +SELECT @@character_set_database; +@@character_set_database +cp866 +SET @@character_set_database = 99; +SELECT @@character_set_database; +@@character_set_database +cp1250 +SET @@character_set_database = 100; +ERROR 42000: Unknown character set: '100' +SET @@global.character_set_database = 1; +SELECT @@global.character_set_database; +@@global.character_set_database +big5 +SET @@global.character_set_database = 2; +SELECT @@global.character_set_database; +@@global.character_set_database +latin2 +SET @@global.character_set_database = 3; +SELECT @@global.character_set_database; +@@global.character_set_database +dec8 +SET @@global.character_set_database = 36; +SELECT @@global.character_set_database; +@@global.character_set_database +cp866 +SET @@global.character_set_database = 99; +SELECT @@global.character_set_database; +@@global.character_set_database +cp1250 +SET @@global.character_set_database = 100; +ERROR 42000: Unknown character set: '100' +SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); +SELECT @total_charset; +@total_charset +36 +'Bug # 34843: character sets are mapped in such a way that 100 and following'; +'numbers gives error, and before 100 the 36 mapped wraps arround several times.'; +'#--------------------FN_DYNVARS_012_10-------------------------#' +SET @@character_set_database = "grek"; +ERROR 42000: Unknown character set: 'grek' +SET @@character_set_database = utf 8; +ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '8' at line 1 +SET @@character_set_database = 0; +ERROR 42000: Unknown character set: '0' +SET @@character_set_database = 1.1; +ERROR 42000: Incorrect argument type to variable 'character_set_database' +SET @@character_set_database = -1; +ERROR 42000: Unknown character set: '-1' +SET @@character_set_database = ''; +ERROR 42000: Unknown character set: '' +SET @@character_set_database = 'latin 2'; +ERROR 42000: Unknown character set: 'latin 2' +SET @@character_set_database = true; +SELECT @@character_set_database AS res_with_true; +res_with_true +big5 +SET @@character_set_database = ON; +ERROR 42000: Unknown character set: 'ON' +'#--------------------FN_DYNVARS_012_11-------------------------#' +SET @@global.character_set_database = abc; +ERROR 42000: Unknown character set: 'abc' +SET @@global.character_set_database = 1utf8; +ERROR 42000: Unknown character set: '1utf8' +SET @@global.character_set_database = 0; +ERROR 42000: Unknown character set: '0' +SET @@global.character_set_database = 1.1; +ERROR 42000: Incorrect argument type to variable 'character_set_database' +SET @@global.character_set_database = -1; +ERROR 42000: Unknown character set: '-1' +SET @@global.character_set_database = ''; +ERROR 42000: Unknown character set: '' +SET @@global.character_set_database = 'utf'; +ERROR 42000: Unknown character set: 'utf' +SET @@global.character_set_database = true; +SET @@global.character_set_database = ON; +ERROR 42000: Unknown character set: 'ON' +'#--------------------FN_DYNVARS_012_12-------------------------#' +SELECT @@global.character_set_database = +(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='character_set_database') AS res; +res +1 +SET @@global.character_set_database = 1; +SELECT @@global.character_set_database; +@@global.character_set_database +big5 +SELECT @@global.character_set_database = +(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES +WHERE VARIABLE_NAME='character_set_database') AS res; +res +1 +'#--------------------FN_DYNVARS_012_13-------------------------#' +SELECT @@character_set_database = +(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='character_set_database') AS res; +res +1 +SELECT @@local.character_set_database = +(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='character_set_database') AS res; +res +1 +SELECT @@session.character_set_database = +(SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES +WHERE VARIABLE_NAME='character_set_database') AS res; +res +1 +SET @@global.character_set_database = @global_start_value; +SELECT @@global.character_set_database; +@@global.character_set_database +latin1 +SET @@session.character_set_database = @session_start_value; +SELECT @@session.character_set_database; +@@session.character_set_database +latin1 |