| Server IP : 104.21.38.3 / Your IP : 172.68.164.117 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : ON Directory : /www/server/mysql/src/mysql-test/suite/sys_vars/r/ |
Upload File : |
SET @global_start_value = @@global.character_set_results; SELECT @global_start_value; @global_start_value latin1 SET @session_start_value = @@character_set_results; SELECT @session_start_value; @session_start_value latin1 SET @session_start_value = @@local.character_set_results; SELECT @session_start_value; @session_start_value latin1 SET @session_start_value = @@session.character_set_results; SELECT @session_start_value; @session_start_value latin1 '#--------------------FN_DYNVARS_013_01------------------#' SELECT character_set_results; ERROR 42S22: Unknown column 'character_set_results' in 'field list' SET character_set_results=utf8; SELECT @@session.character_set_results; @@session.character_set_results utf8 SET global.character_set_results=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 'global.character_set_results=utf8' at line 1 SET session character_set_results=utf8; SELECT session character_set_results; ERROR 42S22: Unknown column 'session' in 'field list' SET global character_set_results=utf8; SELECT global character_set_results; ERROR 42S22: Unknown column 'global' in 'field list' '#--------------------FN_DYNVARS_013_02-------------------------#' SET @@character_set_results = latin5; SET @@character_set_results = DEFAULT; SELECT @@character_set_results AS DEFAULT_VALUE; DEFAULT_VALUE utf8 SET @@global.character_set_results = latin5; SET @@global.character_set_results = DEFAULT; SELECT @@global.character_set_results; @@global.character_set_results latin1 '#--------------------FN_DYNVARS_013_03-------------------------#' SET @@session.character_set_results = utf8; SELECT @@session.character_set_results; @@session.character_set_results utf8 SET @@global.character_set_results = latin2; SELECT @@global.character_set_results; @@global.character_set_results latin2 SELECT @@session.character_set_results AS res_is_utf8; res_is_utf8 utf8 SET @@session.character_set_results = latin5; SELECT @@session.character_set_results; @@session.character_set_results latin5 SELECT @@global.character_set_results AS res_is_latin2; res_is_latin2 latin2 SELECT @@global.character_set_results=@@session.character_set_results AS res_is_false; res_is_false 0 '#--------------------FN_DYNVARS_013_04-------------------------#' SELECT @@character_set_results = @@session.character_set_results AS res; res 1 SELECT @@character_set_results = @@local.character_set_results AS res; res 1 '#--------------------FN_DYNVARS_013_05-------------------------#' SET @@character_set_results = utf8 + latin2; ERROR 42S22: Unknown column 'utf8' in 'field list' '#--------------------FN_DYNVARS_013_06-------------------------#' SET @@session.character_set_results = big5; SELECT @@session.character_set_results; @@session.character_set_results big5 SET @@session.character_set_results = dec8; SELECT @@session.character_set_results; @@session.character_set_results dec8 SET @@session.character_set_results = cp850; SELECT @@session.character_set_results; @@session.character_set_results cp850 SET @@session.character_set_results = hp8; SELECT @@session.character_set_results; @@session.character_set_results hp8 SET @@session.character_set_results = koi8r; SELECT @@session.character_set_results; @@session.character_set_results koi8r SET @@session.character_set_results = latin1; SELECT @@session.character_set_results; @@session.character_set_results latin1 SET @@session.character_set_results = latin2; SELECT @@session.character_set_results; @@session.character_set_results latin2 SET @@session.character_set_results = swe7; SELECT @@session.character_set_results; ??session.character_set_results swe7 SET @@session.character_set_results = ascii; SELECT @@session.character_set_results; @@session.character_set_results ascii SET @@session.character_set_results = ujis; SELECT @@session.character_set_results; @@session.character_set_results ujis SET @@session.character_set_results = sjis; SELECT @@session.character_set_results; @@session.character_set_results sjis SET @@session.character_set_results = hebrew; SELECT @@session.character_set_results; @@session.character_set_results hebrew SET @@session.character_set_results = tis620; SELECT @@session.character_set_results; @@session.character_set_results tis620 SET @@session.character_set_results = euckr; SELECT @@session.character_set_results; @@session.character_set_results euckr SET @@session.character_set_results = koi8u; SELECT @@session.character_set_results; @@session.character_set_results koi8u SET @@session.character_set_results = gb2312; SELECT @@session.character_set_results; @@session.character_set_results gb2312 SET @@session.character_set_results = greek; SELECT @@session.character_set_results; @@session.character_set_results greek SET @@session.character_set_results = cp1250; SELECT @@session.character_set_results; @@session.character_set_results cp1250 SET @@session.character_set_results = gbk; SELECT @@session.character_set_results; @@session.character_set_results gbk SET @@session.character_set_results = gb18030; SELECT @@session.character_set_results; @@session.character_set_results gb18030 SET @@session.character_set_results = latin5; SELECT @@session.character_set_results; @@session.character_set_results latin5 SET @@session.character_set_results = armscii8; SELECT @@session.character_set_results; @@session.character_set_results armscii8 SET @@session.character_set_results = utf8; SELECT @@session.character_set_results; @@session.character_set_results utf8 SET @@session.character_set_results = ucs2; SELECT @@session.character_set_results; u c s 2 SET @@session.character_set_results = cp866; SELECT @@session.character_set_results; @@session.character_set_results cp866 SET @@session.character_set_results = keybcs2; SELECT @@session.character_set_results; @@session.character_set_results keybcs2 SET @@session.character_set_results = macce; SELECT @@session.character_set_results; @@session.character_set_results macce SET @@session.character_set_results = macroman; SELECT @@session.character_set_results; @@session.character_set_results macroman SET @@session.character_set_results = cp852; SELECT @@session.character_set_results; @@session.character_set_results cp852 SET @@session.character_set_results = latin7; SELECT @@session.character_set_results; @@session.character_set_results latin7 SET @@session.character_set_results = cp1251; SELECT @@session.character_set_results; @@session.character_set_results cp1251 SET @@session.character_set_results = cp1256; SELECT @@session.character_set_results; @@session.character_set_results cp1256 SET @@session.character_set_results = cp1257; SELECT @@session.character_set_results; @@session.character_set_results cp1257 SET @@session.character_set_results = binary; SELECT @@session.character_set_results; @@session.character_set_results binary SET @@session.character_set_results = geostd8; SELECT @@session.character_set_results; @@session.character_set_results geostd8 SET @@session.character_set_results = cp932; SELECT @@session.character_set_results; @@session.character_set_results cp932 SET @@session.character_set_results = eucjpms; SELECT @@session.character_set_results; @@session.character_set_results eucjpms '#--------------------FN_DYNVARS_013_07-------------------------#' SET @@global.character_set_results = big5; SELECT @@global.character_set_results; @@global.character_set_results big5 SET @@global.character_set_results = dec8; SELECT @@global.character_set_results; @@global.character_set_results dec8 SET @@global.character_set_results = cp850; SELECT @@global.character_set_results; @@global.character_set_results cp850 SET @@global.character_set_results = hp8; SELECT @@global.character_set_results; @@global.character_set_results hp8 SET @@global.character_set_results = koi8r; SELECT @@global.character_set_results; @@global.character_set_results koi8r SET @@global.character_set_results = latin1; SELECT @@global.character_set_results; @@global.character_set_results latin1 SET @@global.character_set_results = latin2; SELECT @@global.character_set_results; @@global.character_set_results latin2 SET @@global.character_set_results = swe7; SELECT @@global.character_set_results; @@global.character_set_results swe7 SET @@global.character_set_results = ascii; SELECT @@global.character_set_results; @@global.character_set_results ascii SET @@global.character_set_results = ujis; SELECT @@global.character_set_results; @@global.character_set_results ujis SET @@global.character_set_results = sjis; SELECT @@global.character_set_results; @@global.character_set_results sjis SET @@global.character_set_results = hebrew; SELECT @@global.character_set_results; @@global.character_set_results hebrew SET @@global.character_set_results = tis620; SELECT @@global.character_set_results; @@global.character_set_results tis620 SET @@global.character_set_results = euckr; SELECT @@global.character_set_results; @@global.character_set_results euckr SET @@global.character_set_results = koi8u; SELECT @@global.character_set_results; @@global.character_set_results koi8u SET @@global.character_set_results = gb2312; SELECT @@global.character_set_results; @@global.character_set_results gb2312 SET @@global.character_set_results = greek; SELECT @@global.character_set_results; @@global.character_set_results greek SET @@global.character_set_results = cp1250; SELECT @@global.character_set_results; @@global.character_set_results cp1250 SET @@global.character_set_results = gbk; SELECT @@global.character_set_results; @@global.character_set_results gbk SET @@global.character_set_results = gb18030; SELECT @@global.character_set_results; @@global.character_set_results gb18030 SET @@global.character_set_results = latin5; SELECT @@global.character_set_results; @@global.character_set_results latin5 SET @@global.character_set_results = armscii8; SELECT @@global.character_set_results; @@global.character_set_results armscii8 SET @@global.character_set_results = utf8; SELECT @@global.character_set_results; @@global.character_set_results utf8 SET @@global.character_set_results = ucs2; SELECT @@global.character_set_results; @@global.character_set_results ucs2 SET @@global.character_set_results = cp866; SELECT @@global.character_set_results; @@global.character_set_results cp866 SET @@global.character_set_results = keybcs2; SELECT @@global.character_set_results; @@global.character_set_results keybcs2 SET @@global.character_set_results = macce; SELECT @@global.character_set_results; @@global.character_set_results macce SET @@global.character_set_results = macroman; SELECT @@global.character_set_results; @@global.character_set_results macroman SET @@global.character_set_results = cp852; SELECT @@global.character_set_results; @@global.character_set_results cp852 SET @@global.character_set_results = latin7; SELECT @@global.character_set_results; @@global.character_set_results latin7 SET @@global.character_set_results = cp1251; SELECT @@global.character_set_results; @@global.character_set_results cp1251 SET @@global.character_set_results = cp1256; SELECT @@global.character_set_results; @@global.character_set_results cp1256 SET @@global.character_set_results = cp1257; SELECT @@global.character_set_results; @@global.character_set_results cp1257 SET @@global.character_set_results = binary; SELECT @@global.character_set_results; @@global.character_set_results binary SET @@global.character_set_results = geostd8; SELECT @@global.character_set_results; @@global.character_set_results geostd8 SET @@global.character_set_results = cp932; SELECT @@global.character_set_results; @@global.character_set_results cp932 SET @@global.character_set_results = eucjpms; SELECT @@global.character_set_results; @@global.character_set_results eucjpms '#--------------------FN_DYNVARS_013_08-------------------------#' SET @@character_set_results = UTF8; SELECT @@character_set_results; @@character_set_results utf8 SET @@character_set_results = utf8; SELECT @@character_set_results; @@character_set_results utf8 SET @@global.character_set_results = uTf8; SELECT @@global.character_set_results; @@global.character_set_results utf8 '#--------------------FN_DYNVARS_013_09-------------------------#' SET @@character_set_results = 1; SELECT @@character_set_results; @@character_set_results big5 SET @@character_set_results = 2; SELECT @@character_set_results; @@character_set_results latin2 SET @@character_set_results = 3; SELECT @@character_set_results; @@character_set_results dec8 SET @@character_set_results = 36; SELECT @@character_set_results; @@character_set_results cp866 SET @@character_set_results = 99; SELECT @@character_set_results; @@character_set_results cp1250 SET @@character_set_results = 100; ERROR 42000: Unknown character set: '100' SET @@global.character_set_results = 1; SELECT @@global.character_set_results; @@global.character_set_results big5 SET @@global.character_set_results = 2; SELECT @@global.character_set_results; @@global.character_set_results latin2 SET @@global.character_set_results = 3; SELECT @@global.character_set_results; @@global.character_set_results dec8 SET @@global.character_set_results = 36; SELECT @@global.character_set_results; @@global.character_set_results cp866 SET @@global.character_set_results = 99; SELECT @@global.character_set_results; @@global.character_set_results cp1250 SET @@global.character_set_results = 100; ERROR 42000: Unknown character set: '100' SET @total_charset = (SELECT count(*) FROM INFORMATION_SCHEMA.CHARACTER_SETS); SELECT @total_charset; @total_charset 41 '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_013_10-------------------------#' SET @@character_set_results = abc; ERROR 42000: Unknown character set: 'abc' SET @@character_set_results = 1utf8; ERROR 42000: Unknown character set: '1utf8' SET @@character_set_results = 0; ERROR 42000: Unknown character set: '0' SET @@character_set_results = .1; ERROR 42000: Incorrect argument type to variable 'character_set_results' SET @@character_set_results = -1; ERROR 42000: Unknown character set: '-1' SET @@character_set_results = ""; ERROR 42000: Unknown character set: '' SET @@character_set_results = 'utf'; ERROR 42000: Unknown character set: 'utf' SET @@character_set_results = true; SELECT @@character_set_results AS res_with_true; res_with_true big5 SET @@character_set_results = ON; ERROR 42000: Unknown character set: 'ON' '#--------------------FN_DYNVARS_013_11-------------------------#' SET @@global.character_set_results = "'latin2'"; ERROR 42000: Unknown character set: ''latin2'' SET @@global.character_set_results = 1utf8; ERROR 42000: Unknown character set: '1utf8' SET @@global.character_set_results = 0; ERROR 42000: Unknown character set: '0' SET @@global.character_set_results = 0.1; ERROR 42000: Incorrect argument type to variable 'character_set_results' SET @@global.character_set_results = -1; ERROR 42000: Unknown character set: '-1' SET @@global.character_set_results = ""; ERROR 42000: Unknown character set: '' SET @@global.character_set_results = 'utf'; ERROR 42000: Unknown character set: 'utf' SET @@global.character_set_results = true; SET @@global.character_set_results = ON; ERROR 42000: Unknown character set: 'ON' '#--------------------FN_DYNVARS_013_12-------------------------#' SELECT @@global.character_set_results = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='character_set_results') AS res; res 1 SET @@global.character_set_results = 1; SELECT @@global.character_set_results; @@global.character_set_results big5 SELECT @@global.character_set_results = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='character_set_results') AS res; res 1 '#--------------------FN_DYNVARS_013_13-------------------------#' SELECT @@character_set_results = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='character_set_results') AS res; res 1 SELECT @@local.character_set_results = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='character_set_results') AS res; res 1 SELECT @@session.character_set_results = (SELECT VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='character_set_results') AS res; res 1 SET @@global.character_set_results = @global_start_value; SELECT @@global.character_set_results; @@global.character_set_results latin1 SET @@session.character_set_results = @session_start_value; SELECT @@session.character_set_results; @@session.character_set_results latin1