1SET @global_start_value = @@global.time_zone; 2SELECT @global_start_value; 3@global_start_value 4SYSTEM 5SET @session_start_value = @@session.time_zone; 6SELECT @session_start_value; 7@session_start_value 8SYSTEM 9'#--------------------FN_DYNVARS_001_01------------------------#' 10SET @@time_zone = "+02:00"; 11SET @@time_zone = DEFAULT; 12SELECT @@time_zone; 13@@time_zone 14SYSTEM 15SET @@global.time_zone = "-00:30"; 16SET @@global.time_zone = DEFAULT; 17SELECT @@global.time_zone; 18@@global.time_zone 19SYSTEM 20'#---------------------FN_DYNVARS_001_02-------------------------#' 21SET @@session.time_zone = "+02:00"; 22SELECT @@session.time_zone; 23@@session.time_zone 24+02:00 25SET @@global.time_zone = "+05:00"; 26SELECT @@global.time_zone; 27@@global.time_zone 28+05:00 29SELECT @@session.time_zone AS res_is_02_00; 30res_is_02_00 31+02:00 32SET @@session.time_zone = "-02:00"; 33SELECT @@session.time_zone; 34@@session.time_zone 35-02:00 36SELECT @@global.time_zone AS res_is_05_00; 37res_is_05_00 38+05:00 39SELECT @@global.time_zone=@@session.time_zone AS res_is_false; 40res_is_false 410 42'#--------------------FN_DYNVARS_001_03------------------------#' 43SET @@time_zone = "+13:00"; 44SELECT @@time_zone; 45@@time_zone 46+13:00 47SET @@time_zone = "-12:00"; 48SELECT @@time_zone; 49@@time_zone 50-12:00 51SET @@time_zone = "+12:59"; 52SELECT @@time_zone; 53@@time_zone 54+12:59 55SET @@time_zone = "-11:30"; 56SELECT @@time_zone; 57@@time_zone 58-11:30 59SET @@time_zone = "+00:00"; 60SELECT @@time_zone; 61@@time_zone 62+00:00 63SET @@time_zone = "-12:59"; 64SELECT @@time_zone; 65@@time_zone 66-12:59 67SET @@time_zone = "-00:00"; 68SELECT @@time_zone; 69@@time_zone 70+00:00 71SET @@time_zone = "+10:00"; 72SELECT @@time_zone; 73@@time_zone 74+10:00 75SET @@time_zone = "+0:0"; 76SELECT @@time_zone; 77@@time_zone 78+00:00 79SET @@time_zone = "-10:00"; 80SELECT @@time_zone; 81@@time_zone 82-10:00 83SET @@time_zone = "+2:00"; 84SELECT @@time_zone; 85@@time_zone 86+02:00 87SET @@global.time_zone = "+13:00"; 88SELECT @@global.time_zone; 89@@global.time_zone 90+13:00 91SET @@global.time_zone = "-12:00"; 92SELECT @@global.time_zone; 93@@global.time_zone 94-12:00 95SET @@global.time_zone = "+12:59"; 96SELECT @@global.time_zone; 97@@global.time_zone 98+12:59 99SET @@global.time_zone = "-11:30"; 100SELECT @@global.time_zone; 101@@global.time_zone 102-11:30 103SET @@global.time_zone = "+00:00"; 104SELECT @@global.time_zone; 105@@global.time_zone 106+00:00 107SET @@global.time_zone = "-12:59"; 108SELECT @@global.time_zone; 109@@global.time_zone 110-12:59 111SET @@global.time_zone = "-00:00"; 112SELECT @@global.time_zone; 113@@global.time_zone 114+00:00 115SET @@global.time_zone = "+10:00"; 116SELECT @@global.time_zone; 117@@global.time_zone 118+10:00 119SET @@global.time_zone = "+0:0"; 120SELECT @@global.time_zone; 121@@global.time_zone 122+00:00 123SET @@global.time_zone = "-10:00"; 124SELECT @@global.time_zone; 125@@global.time_zone 126-10:00 127SET @@global.time_zone = "+2:00"; 128SELECT @@global.time_zone; 129@@global.time_zone 130+02:00 131'#--------------------FN_DYNVARS_001_04-------------------------#' 132SET @@time_zone = "+24:00"; 133ERROR HY000: Unknown or incorrect time zone: '+24:00' 134SET @@time_zone = "+23:59"; 135ERROR HY000: Unknown or incorrect time zone: '+23:59' 136SET @@time_zone = "+13:01"; 137ERROR HY000: Unknown or incorrect time zone: '+13:01' 138SET @@time_zone = "-13:01"; 139ERROR HY000: Unknown or incorrect time zone: '-13:01' 140SET @@global.time_zone = "+24:00"; 141ERROR HY000: Unknown or incorrect time zone: '+24:00' 142SET @@global.time_zone = "+23:59"; 143ERROR HY000: Unknown or incorrect time zone: '+23:59' 144SET @@global.time_zone = "+13:01"; 145ERROR HY000: Unknown or incorrect time zone: '+13:01' 146SET @@global.time_zone = "-13:01"; 147ERROR HY000: Unknown or incorrect time zone: '-13:01' 148'#-------------------FN_DYNVARS_001_05----------------------------#' 149SET @@global.time_zone = 'SYSTEM'; 150SELECT @@global.time_zone; 151@@global.time_zone 152SYSTEM 153SET @@time_zone = 'SYSTEM'; 154SELECT @@time_zone; 155@@time_zone 156SYSTEM 157'#----------------------FN_DYNVARS_001_06------------------------#' 158SELECT @@time_zone = VARIABLE_VALUE 159FROM INFORMATION_SCHEMA.SESSION_VARIABLES 160WHERE VARIABLE_NAME='time_zone'; 161@@time_zone = VARIABLE_VALUE 1621 163'#----------------------FN_DYNVARS_001_07------------------------#' 164SELECT @@global.time_zone = VARIABLE_VALUE 165FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES 166WHERE VARIABLE_NAME='time_zone'; 167@@global.time_zone = VARIABLE_VALUE 1681 169'#---------------------FN_DYNVARS_001_08-------------------------#' 170SET @@time_zone = OFF; 171ERROR HY000: Unknown or incorrect time zone: 'OFF' 172SET @@time_zone = ON; 173ERROR HY000: Unknown or incorrect time zone: 'ON' 174SET @@time_zone = TRUE; 175ERROR 42000: Incorrect argument type to variable 'time_zone' 176SET @@time_zone = FALSE; 177ERROR 42000: Incorrect argument type to variable 'time_zone' 178SET @@global.time_zone = OFF; 179ERROR HY000: Unknown or incorrect time zone: 'OFF' 180SET @@global.time_zone = ON; 181ERROR HY000: Unknown or incorrect time zone: 'ON' 182SET @@global.time_zone = TRUE; 183ERROR 42000: Incorrect argument type to variable 'time_zone' 184SET @@global.time_zone = FALSE; 185ERROR 42000: Incorrect argument type to variable 'time_zone' 186'#---------------------FN_DYNVARS_001_09----------------------#' 187SET @@time_zone = 1; 188ERROR 42000: Incorrect argument type to variable 'time_zone' 189SET @@time_zone = +0200; 190ERROR 42000: Incorrect argument type to variable 'time_zone' 191SET @@time_zone = GMT+; 192ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 193SET @@time_zone = ""; 194ERROR HY000: Unknown or incorrect time zone: '' 195SET @@global.time_zone = 1; 196ERROR 42000: Incorrect argument type to variable 'time_zone' 197SET @@global.time_zone = +0200; 198ERROR 42000: Incorrect argument type to variable 'time_zone' 199SET @@global.time_zone = GMT+; 200ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 201SET @@global.time_zone = ""; 202ERROR HY000: Unknown or incorrect time zone: '' 203'#---------------------FN_DYNVARS_001_10----------------------#' 204SET @@time_zone = '+02:30'; 205SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone; 206@@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone 2071 208SET @@time_zone = '-01:30'; 209SELECT @@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone; 210@@time_zone = @@local.time_zone and @@time_zone = @@session.time_zone 2111 212'#---------------------FN_DYNVARS_001_11----------------------#' 213SET time_zone = "+01:00"; 214SELECT @@time_zone; 215@@time_zone 216+01:00 217SELECT local.time_zone; 218ERROR 42S02: Unknown table 'local' in field list 219SELECT session.time_zone; 220ERROR 42S02: Unknown table 'session' in field list 221SELECT time_zone = @@session.time_zone; 222ERROR 42S22: Unknown column 'time_zone' in 'field list' 223SET @@time_zone = @session_start_value; 224SELECT @@time_zone; 225@@time_zone 226SYSTEM 227SET @@global.time_zone = @global_start_value; 228SELECT @@global.time_zone; 229@@global.time_zone 230SYSTEM 231