blob: 4cda672b8204e49078c226ffdd47a9c2d8ea867e (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
#
# MDEV-9175 Query parser tansforms MICROSECOND into SECOND_FRAC, which does not work
#
#enable after fix MDEV-27871
--disable_view_protocol
select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
explain extended select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
create view v1 as select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456');
select * from v1;
drop view v1;
--enable_view_protocol
|