Skip to content

*: ODBC-styled datetime literal cannot be used in the expressions. #25531

Closed
pingcap/parser
#1253
@bb7133

Description

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(a datetime);
select * from t where a > {ts '2021-05-05 00:00:00.111'};

2. What did you expect to see? (Required)

The query runs successfully.

3. What did you see instead (Required)

tidb> select * from t where a > {ts '2021-05-05 00:00:00.111'};
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 29 near "ts '00:00:00.111'}" 

4. What is your TiDB version? (Required)

The error can be reproduced in all existing versions of TiDB.

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions