| 1 |
SET sql_mode=ORACLE; |
| 2 |
# |
| 3 |
# Start of 10.3 tests |
| 4 |
# |
| 5 |
# |
| 6 |
# MDEV-16152 Expressions with INTERVAL return bad results in some cases |
| 7 |
# |
| 8 |
SELECT TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1, |
| 9 |
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2; |
| 10 |
c1 c2 |
| 11 |
1991-01-01 10:20:30 1991-01-01 10:20:30 |
| 12 |
SELECT TIMESTAMP'2001-01-01 10:20:30' + INTERVAL '10' YEAR AS c1, |
| 13 |
INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2, |
| 14 |
+INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c3; |
| 15 |
c1 c2 c3 |
| 16 |
2011-01-01 10:20:30 2011-01-01 10:20:30 2011-01-01 10:20:30 |
| 17 |
EXPLAIN EXTENDED SELECT |
| 18 |
TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1, |
| 19 |
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2; |
| 20 |
id select_type table type possible_keys key key_len ref rows filtered Extra |
| 21 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used |
| 22 |
Warnings: |
| 23 |
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" |
| 24 |
EXPLAIN EXTENDED SELECT |
| 25 |
TIMESTAMP'2001-01-01 10:20:30' + INTERVAL '10' YEAR AS c1, |
| 26 |
INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2, |
| 27 |
+INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c3; |
| 28 |
id select_type table type possible_keys key key_len ref rows filtered Extra |
| 29 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used |
| 30 |
Warnings: |
| 31 |
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" |