Display Format Issue of the Original_sql Field in SPM

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: SPM 的 Original_sql 字段显示格式问题

| username: ShawnYan

[TiDB Usage Environment] Poc
[TiDB Version] 7.1
[Reproduction Path] What operations were performed when the issue occurred
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration] Go to TiDB Dashboard - Cluster Info - Hosts and take a screenshot of this page
[Attachments: Screenshots/Logs/Monitoring]

As shown in the figure, the SQL displayed in the Original_sql field cannot be directly copied and used, but the Bind_sql can. It is recommended to optimize this.

For example:

select count ( ? ) from `test` . `t`

should be changed to

select count(?) from `test`.`t`

2023-07-04_101831

| username: redgame | Original post link

Detailed…

| username: cassblanca | Original post link

Go file an issue :grinning:

| username: yilong | Original post link

You can submit an issue on GitHub when you have time, thanks.

| username: ShawnYan | Original post link

@Yilong

Raised the issue, please take a look, thank you.

| username: ShawnYan | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.