mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 19:06:14 +01:00
31 lines
1.5 KiB
Text
31 lines
1.5 KiB
Text
SET sql_mode=ORACLE;
|
|
#
|
|
# Start of 10.3 tests
|
|
#
|
|
#
|
|
# MDEV-16152 Expressions with INTERVAL return bad results in some cases
|
|
#
|
|
SELECT TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1,
|
|
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2;
|
|
c1 c2
|
|
1991-01-01 10:20:30 1991-01-01 10:20:30
|
|
SELECT TIMESTAMP'2001-01-01 10:20:30' + INTERVAL '10' YEAR AS c1,
|
|
INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2,
|
|
+INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c3;
|
|
c1 c2 c3
|
|
2011-01-01 10:20:30 2011-01-01 10:20:30 2011-01-01 10:20:30
|
|
EXPLAIN EXTENDED SELECT
|
|
TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1,
|
|
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2;
|
|
id select_type table type possible_keys key key_len ref rows filtered Extra
|
|
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
|
|
Warnings:
|
|
Note 1003 select TIMESTAMP'2001-01-01 10:20:30' - interval '10' year AS "c1",TIMESTAMP'2001-01-01 10:20:30' - interval '10' year AS "c2"
|
|
EXPLAIN EXTENDED SELECT
|
|
TIMESTAMP'2001-01-01 10:20:30' + INTERVAL '10' YEAR AS c1,
|
|
INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2,
|
|
+INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c3;
|
|
id select_type table type possible_keys key key_len ref rows filtered Extra
|
|
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
|
|
Warnings:
|
|
Note 1003 select TIMESTAMP'2001-01-01 10:20:30' + interval '10' year AS "c1",TIMESTAMP'2001-01-01 10:20:30' + interval '10' year AS "c2",TIMESTAMP'2001-01-01 10:20:30' + interval '10' year AS "c3"
|