Ziele Untersuchung
mit Columbo Integrität von
Datenbanken Interaktion und
Portierbarkeit Ergonomie der
Schnittstellen

Angebot Produkte Projekt Beratung

Mittel Analytik Modellierung Sprachen Algebra Logik Hardware Denken Kreativität

Zusammenhänge Gesellschaft Wirtschaft Branche Firma

Benutzer


products/Sources/formale Sprachen/C/MariaDB/mysql-test/suite/sys_vars/r/ (MariaDB Server Version 8.1-8.4^©) Datei vom 1.9.2026 mit Größe 6 kB

Quelle time_zone_basic.result Sprache: Lisp

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 MariaDB 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 MariaDB 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 SELECT
SELECT session.time_zone;
ERROR 42S02: Unknown table 'session' in SELECT
SELECT time_zone = @@session.time_zone;
ERROR 42S22: Unknown column 'time_zone' in 'SELECT'
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

Messung V0.5 in Prozent

¤ Dauer der Verarbeitung: 0.10 Sekunden (vorverarbeitet am 2026-10-10) ¤

Wurzel

Suchen

PVS Prover

Isabelle Prover

NIST Cobol Testsuite

Cephes Mathematical Library

Vienna Development Method

Haftungshinweis

Die Informationen auf dieser Webseite wurden nach bestem Wissen sorgfältig zusammengestellt. Es wird jedoch weder Vollständigkeit, noch Richtigkeit, noch Qualität der bereit gestellten Informationen zugesichert.