pingcap/tidb
Vedi su GitHubThe query in slow log can't be parsed when there is single comment in sql
Open
#30.886 aperta il 20 dic 2021
help wantedseverity/moderatesig/sql-infratype/bug
Metriche repository
- Star
- (40.090 star)
- Metriche merge PR
- (Merge medio 14g 4h) (346 PR mergiate in 30 g)
Descrizione
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