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

貢獻者指南