1--echo #
2--echo # Start of 10.4 tests
3--echo #
4
5--echo #
6--echo # MDEV-17776 CAST(x AS INTERVAL DAY_SECOND(N))
7--echo #
8
9CREATE TABLE t1 (a VARCHAR(128));
10INSERT INTO t1 VALUES
11('00:00:00'),
12('+00:00:01'),
13('-00:00:01'),
14('838:59:59'),
15('839:00:00'),
16('2018:01:02'),
17('87649415:59:59'),
18('3652058 23:59:59'),
19('87649416:00:00'),
20('3652059 00:00:00');
21
22SELECT
23  EXTRACT(DAY FROM a) AS d,
24  EXTRACT(HOUR FROM a) AS h,
25  a,
26  CAST(a AS INTERVAL DAY_SECOND(6)) AS cast_itds
27FROM t1;
28
29DROP TABLE t1;
30
31
32CREATE TABLE t1 (a DECIMAL(32,9));
33INSERT INTO t1 VALUES
34(0),
35(1),
36(-1),
37(8385959),
38(8390000),
39(20180102),
40(876494155959),
41(876494160000);
42
43SELECT
44  EXTRACT(DAY FROM a) AS d,
45  EXTRACT(HOUR FROM a) AS h,
46  a,
47  CAST(a AS INTERVAL DAY_SECOND(6)) AS cast_itds
48FROM t1;
49
50DROP TABLE t1;
51
52--echo #
53--echo # End of 10.4 tests
54--echo #
55