建议优化下一条insert..select语句的报错信息

🌞 建议反馈 产品需求
2

哈哈，果然是报这个。

select version();
+--------------------+
| version()          |
+--------------------+
| 5.7.25-TiDB-v6.4.0 |
+--------------------+

root@[test]>select -269944300556.700000000000000000000000000000/0.000000001138326077000000000000
    -> ;

+-------------------------------------------------------------------------------+
| -269944300556.700000000000000000000000000000/0.000000001138326077000000000000 |
+-------------------------------------------------------------------------------+
|                         -237141453587819371373.322233045883214006350133012019 |
+-------------------------------------------------------------------------------+
1 row in set, 1 warning (1.43 sec)

root@[test]>show warnings;
+---------+------+--------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                    |
+---------+------+--------------------------------------------------------------------------------------------+
| Warning | 1292 | Truncated incorrect DECIMAL value: '-237141453587819371373.322233045883214006350133012019' |
+---------+------+--------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

root@[test]>create table tt(a decimal);
Query OK, 0 rows affected (1.17 sec)

root@[test]>insert into tt select -269944300556.700000000000000000000000000000/0.000000001138326077000000000000;
ERROR 1292 (22007): Truncated incorrect DECIMAL value: '{%!s(int8=00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000021) %!s(int8=00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000054) %!s(int8=00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000030) %!s(bool=true) [%!s(int32=0000000000000000000000000000000