Debian Codegraph @

mysql-test/suite/compat/oracle/r/func_time.result

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