mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +01:00
9 lines
436 B
Text
9 lines
436 B
Text
#
|
|
# MDEV-9175 Query parser tansforms MICROSECOND into SECOND_FRAC, which does not work
|
|
#
|
|
|
|
select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456') as exp;
|
|
explain extended select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456') as exp;
|
|
create view v1 as select timestampdiff(microsecond,'2000-01-01 00:00:00','2001-01-01 00:00:00.123456') as exp;
|
|
select * from v1;
|
|
drop view v1;
|