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