pingcap/tidb
GitHub で見るThe query in slow log can't be parsed when there is single comment in sql
Open
#30,886 opened on 2021年12月20日
help wantedseverity/moderatesig/sql-infratype/bug
Repository metrics
- Stars
- (40,090 stars)
- PR merge metrics
- (平均マージ 14d 4h) (30d で 346 merged PRs)
説明
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
If we execute the sql with tidb, and image it is a slow query.
select count(*) from t x ,t y
-- condition
where x.a<y.a
and x.a is not null -- comment
The query recorded in tidb slow log is select count(*) from t x ,t y -- condition where x.a<y.a and x.a is not null -- comment; , and we can't parse the sql correctly because we can't identify which sentences are commented.
Compared with tidb,the mysql slow query in the log is
select count(*) from t x ,t y
-- condition
where x.a<y.a
and x.a is not null -- comment;
2. What did you expect to see? (Required)
same with mysql
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
master