pingcap/tidb

The query in slow log can't be parsed when there is single comment in sql

Open

#30,886 创建于 2021年12月20日

在 GitHub 查看
 (2 评论) (0 反应) (0 负责人)Go (6,186 fork)batch import
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

贡献者指南