| 1 |
SET sql_mode=ORACLE; |
| 2 |
|
| 3 |
--echo # |
| 4 |
--echo # Start of 10.3 tests |
| 5 |
--echo # |
| 6 |
|
| 7 |
--echo # |
| 8 |
--echo # MDEV-16152 Expressions with INTERVAL return bad results in some cases |
| 9 |
--echo # |
| 10 |
|
| 11 |
SELECT TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1, |
| 12 |
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2; |
| 13 |
|
| 14 |
SELECT TIMESTAMP'2001-01-01 10:20:30' + INTERVAL '10' YEAR AS c1, |
| 15 |
INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2, |
| 16 |
+INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c3; |
| 17 |
|
| 18 |
EXPLAIN EXTENDED SELECT |
| 19 |
TIMESTAMP'2001-01-01 10:20:30' - INTERVAL '10' YEAR AS c1, |
| 20 |
-INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2; |
| 21 |
|
| 22 |
EXPLAIN EXTENDED SELECT |
| 23 |
TIMESTAMP'2001-01-01 10:20:30' + INTERVAL '10' YEAR AS c1, |
| 24 |
INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c2, |
| 25 |
+INTERVAL '10' YEAR + TIMESTAMP'2001-01-01 10:20:30' AS c3; |