1#
2# MDEV-9175 Query parser tansforms MICROSECOND into SECOND_FRAC, which does not work
3#
4
5select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
6explain extended select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
7create view v1 as select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
8select * from v1;
9drop view v1;
10