The error messages when inserting errors are not easy to understand

[wan1y]

Bug Report

I think the error message given by mysql is easier to understand

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> CREATE TABLE `t1` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;

mysql> insert into t1 values(1,"a");

mysql> insert into t1 values(2,"b");

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

mysql> insert into t1 select * from t1 on duplicate key update id = "";
1366 - Incorrect integer value: '' for column 'id' at row 1

3. What did you see instead (Required)

mysql> insert into t1 select * from t1 on duplicate key update id = "";
1292 - Truncated incorrect FLOAT value: ''

4. What is your TiDB version? (Required)

Release Version: v4.0.0-beta.2-2573-ga347ad928
Edition: Community
Git Commit Hash: a347ad92826425312ca6de00cb66bd7af717d677
Git Branch: master
UTC Build Time: 2021-04-06 15:37:56
GoVersion: go1.13
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false

[zoomxi]

/assign