Window function panicked when range bound is time type

[winoros]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

CREATE TABLE `t_time` (
  `t` time DEFAULT NULL,
  `ts` timestamp NULL DEFAULT NULL
)
INSERT INTO t_time VALUES ('12:30', '2016-07-05 08:30:42');
SELECT t, FIRST_VALUE(t) OVER (ORDER BY t RANGE BETWEEN INTERVAL 2 HOUR PRECEDING AND INTERVAL 2 HOUR_MINUTE PRECEDING) FROM t_time;

2. What did you expect to see?

Execute successfully.

3. What did you see instead?

Panicked.

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

[alivxxx]

It seems that there is something wrong with date_add.
In mysql:

MySQL [test]> select date_add(t, INTERVAL 2 HOUR) from t_time;
+------------------------------+
| date_add(t, INTERVAL 2 HOUR) |
+------------------------------+
| 14:30:00                     |
+------------------------------+
1 row in set (0.001 sec)

While in TiDB:

MySQL [test]> select date_add(t, INTERVAL 2 HOUR) from t_time;
+------------------------------+
| date_add(t, INTERVAL 2 HOUR) |
+------------------------------+
| 2019-03-18 14:30:00          |
+------------------------------+
1 row in set (0.002 sec)

[winoros]

wait #9813

[winoros]

#9813 and #9874 fixed this issue.