mirror of
https://github.com/MariaDB/server.git
synced 2025-08-08 11:22:35 +03:00
10 lines
436 B
Plaintext
10 lines
436 B
Plaintext
#
|
|
# 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;
|