Error message not formatted

[you06]

Description

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

select 888888888888888888888888888888888888888888888888888888888888888888888888888888888888;

2. What did you expect to see? (Required)

Formatted error message.

3. What did you see instead (Required)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 91 near "888888888888888888888888888888888888888888888888888888888888888888888888888888888888"
decimal literal: [types:1690]%s value is out of range in '%s'

4. Affected version (Required)

Release Version: v4.0.0
Edition: Community
Git Commit Hash: 689a6b6439ae7835947fcaccf329a3fc303986cb
Git Branch: heads/refs/tags/v4.0.0
UTC Build Time: 2020-05-28 01:37:40
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

5. Root Cause Analysis

SIG slack channel

#sig-exec

Score

• 300

Mentor

• @lzmhhh123

[zhangysh1995]

I found a related issue last week, check here

[yufan022]

/pick-up

[ti-challenge-bot]

Pick up success.

[ti-challenge-bot]

@yufan022 You did not submit PR within 7 days, so give up automatically.

[solotzg]

Now the behavior are the same, shall we close it ?

---

mysql

select 888888888888888888888888888888888888888888888888888888888888888888888888888888888888;
SHOW WARNINGS;
select version();

888888888888888888888888888888888888888888888888888888888888888888888888888888888888
99999999999999999999999999999999999999999999999999999999999999999
Level	Code	Message
Warning	1292	Truncated incorrect DECIMAL value: '888888888888888888888888888888888888888888888888888888888888888888888888888888888'
version()
8.0.28-0ubuntu0.20.04.3

tidb

MySQL [test]> select 888888888888888888888888888888888888888888888888888888888888888888888888888888888888;
+--------------------------------------------------------------------------------------+
| 888888888888888888888888888888888888888888888888888888888888888888888888888888888888 |
+--------------------------------------------------------------------------------------+
|                    99999999999999999999999999999999999999999999999999999999999999999 |
+--------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

MySQL [test]> SHOW WARNINGS;
+---------+------+------------------------------------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                                                |
+---------+------+------------------------------------------------------------------------------------------------------------------------+
| Warning | 1292 | Truncated incorrect DECIMAL value: '888888888888888888888888888888888888888888888888888888888888888888888888888888888' |
+---------+------+------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MySQL [test]> select version();
+----------------------------+
| version()                  |
+----------------------------+
| 5.7.25-TiDB-v6.1.0-nightly |
+----------------------------+
1 row in set (0.00 sec)