pingcap/tidb
在 GitHub 查看The query in slow log can't be parsed when there is single comment in sql
Open
#30,886 创建于 2021年12月20日
help wantedseverity/moderatesig/sql-infratype/bug
仓库指标
- Star
- (40,090 star)
- PR 合并指标
- (平均合并 14天 4小时) (30 天内合并 346 个 PR)
描述
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