| Server IP : 172.67.216.182 / Your IP : 172.71.81.235 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.time_zone; SELECT @global_start_value; @global_start_value SYSTEM SET @session_start_value = @@session.time_zone; SELECT @session_start_value; @session_start_value SYSTEM '#--------------------FN_DYNVARS_001_01------------------------#' SET @@time_zone = "+02:00"; SET @@time_zone = DEFAULT; SELECT @@time_zone; @@time_zone SYSTEM SET @@global.time_zone = "-00:30"; SET @@global.time_zone = DEFAULT; SELECT @@global.time_zone; @@global.time_zone SYSTEM '#---------------------FN_DYNVARS_001_02-------------------------#' SET @@session.time_zone = "+02:00"; SELECT @@session.time_zone; @@session.time_zone +02:00 SET @@global.time_zone = "+05:00"; SELECT @@global.time_zone; @@global.time_zone +05:00 SELECT @@session.time_zone AS res_is_02_00; res_is_02_00 +02:00 SET @@session.time_zone = "-02:00"; SELECT @@session.time_zone; @@session.time_zone -02:00 SELECT @@global.time_zone AS res_is_05_00; res_is_05_00 +05:00 SELECT @@global.time_zone=@@session.time_zone AS res_is_false; res_is_false 0 '#--------------------FN_DYNVARS_001_03------------------------#' SET @@time_zone = "+13:00"; SELECT @@time_zone; @@time_zone +13:00 SET @@time_zone = "-12:00"; SELECT @@time_zone; @@time_zone -12:00 SET @@time_zone = "+12:59"; SELECT @@time_zone; @@time_zone +12:59 SET @@time_zone = "-11:30"; SELECT @@time_zone; @@time_zone -11:30 SET @@time_zone = "+00:00"; SELECT @@time_zone; @@time_zone +00:00 SET @@time_zone = "-12:59"; SELECT @@time_zone; @@time_zone -12:59 SET @@time_zone = "-00:00"; SELECT @@time_zone; @@time_zone +00:00 SET @@time_zone = "+10:00"; SELECT @@time_zone; @@time_zone +10:00 SET @@time_zone = "+0:0"; SELECT @@time_zone; @@time_zone +00:00 SET @@time_zone = "-10:00"; SELECT @@time_zone; @@time_zone -10:00 SET @@time_zone = "+2:00"; SELECT @@time_zone; @@time_zone +02:00 SET @@global.time_zone = "+13:00"; SELECT @@global.time_zone; @@global.time_zone +13:00 SET @@global.time_zone = "-12:00"; SELECT @@global.time_zone; @@global.time_zone -12:00 SET @@global.time_zone = "+12:59"; SELECT @@global.time_zone; @@global.time_zone +12:59 SET @@global.time_zone = "-11:30"; SELECT @@global.time_zone; @@global.time_zone -11:30 SET @@global.time_zone = "+00:00"; SELECT @@global.time_zone; @@global.time_zone +00:00 SET @@global.time_zone = "-12:59"; SELECT @@global.time_zone; @@global.time_zone -12:59 SET @@global.time_zone = "-00:00"; SELECT @@global.time_zone; @@global.time_zone +00:00 SET @@global.time_zone = "+10:00"; SELECT @@global.time_zone; @@global.time_zone +10:00 SET @@global.time_zone = "+0:0"; SELECT @@global.time_zone; @@global.time_zone +00:00 SET @@global.time_zone = "-10:00"; SELECT @@global.time_zone; @@global.time_zone -10:00 SET @@global.time_zone = "+2:00"; SELECT @@global.time_zone; @@global.time_zone +02:00 '#--------------------FN_DYNVARS_001_04-------------------------#' SET @@time_zone = "+24:00"; ERROR HY000: Unknown or incorrect time zone: '+24:00' SET @@time_zone = "+23:59"; ERROR HY000: Unknown or incorrect time zone: '+23:59' SET @@time_zone = "+13:01"; ERROR HY000: Unknown or incorrect time zone: '+13:01' SET @@time_zone = "-13:01"; ERROR HY000: Unknown or incorrect time zone: '-13:01' SET @@global.time_zone = "+24:00"; ERROR HY000: Unknown or incorrect time zone: '+24:00' SET @@global.time_zone = "+23:59"; ERROR HY000: Unknown or incorrect time zone: '+23:59' SET @@global.time_zone = "+13:01"; ERROR HY000: Unknown or incorrect time zone: '+13:01' SET @@global.time_zone = "-13:01"; ERROR HY000: Unknown or incorrect time zone: '-13:01' '#-------------------FN_DYNVARS_001_05----------------------------#' SET @@global.time_zone = 'SYSTEM'; SELECT @@global.time_zone; @@global.time_zone SYSTEM SET @@time_zone = 'SYSTEM'; SELECT @@time_zone; @@time_zone SYSTEM '#----------------------FN_DYNVARS_001_06------------------------#' SELECT @@time_zone = VARIABLE_VALUE FROM INFORMATION_SCHEMA.SESSION_VARIABLES WHERE VARIABLE_NAME='time_zone'; @@time_zone = VARIABLE_VALUE 1 '#----------------------FN_DYNVARS_001_07------------------------#' SELECT @@global.time_zone = VARIABLE_VALUE FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='time_zone'; @@global.time_zone = VARIABLE_VALUE 1 '#---------------------FN_DYNVARS_001_08-------------------------#' SET @@time_zone = OFF; ERROR HY000: Unknown or incorrect time zone: 'OFF' SET @@time_zone = ON; ERROR HY000: Unknown or incorrect time zone: 'ON' SET @@time_zone = TRUE; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@time_zone = FALSE; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@global.time_zone = OFF; ERROR HY000: Unknown or incorrect time zone: 'OFF' SET @@global.time_zone = ON; ERROR HY000: Unknown or incorrect time zone: 'ON' SET @@global.time_zone = TRUE; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@global.time_zone = FALSE; ERROR 42000: Incorrect argument type to variable 'time_zone' '#---------------------FN_DYNVARS_001_09----------------------#' SET @@time_zone = 1; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@time_zone = +0200; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@time_zone = GMT+; 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 '' at line 1 SET @@time_zone = ""; ERROR HY000: Unknown or incorrect time zone: '' SET @@global.time_zone = 1; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@global.time_zone = +0200; ERROR 42000: Incorrect argument type to variable 'time_zone' SET @@global.time_zone = GMT+; 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 '' at line 1 SET @@global.time_zone = ""; ERROR HY000: Unknown or incorrect time zone: '' '#---------------------FN_DYNVARS_001_10----------------------#' SET @@time_zone = '+02:30'; SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone; @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone 1 SET @@time_zone = '-01:30'; SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone; @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone 1 '#---------------------FN_DYNVARS_001_11----------------------#' SET time_zone = "+01:00"; SELECT @@time_zone; @@time_zone +01:00 SELECT local.time_zone; ERROR 42S02: Unknown table 'local' in field list SELECT session.time_zone; ERROR 42S02: Unknown table 'session' in field list SELECT time_zone = @@session.time_zone; ERROR 42S22: Unknown column 'time_zone' in 'field list' SET @@time_zone = @session_start_value; SELECT @@time_zone; @@time_zone SYSTEM SET @@global.time_zone = @global_start_value; SELECT @@global.time_zone; @@global.time_zone SYSTEM