pingcap/tidb
Voir sur GitHubThe query in slow log can't be parsed when there is single comment in sql
Open
#30 886 ouverte le 20 déc. 2021
help wantedseverity/moderatesig/sql-infratype/bug
Métriques du dépôt
- Stars
- (40 090 stars)
- Métriques de merge PR
- (Merge moyen 14j 4h) (346 PRs mergées en 30 j)
Description
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