Debian Codegraph @

mysql-test/suite/compat/oracle/t/func_time.test

raw
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;