Got error when using insert into select on duplicate key update

[guo-shaoge]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

drop table if exists ccd;
drop table if exists cm1;
create table ccd (s int, b int, p int);
create table cm1 (p int);
insert into ccd (p) select 3 from cm1 on duplicate key update p = cm1.p;

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

no error

3. What did you see instead (Required)

mysql> insert into ccd (p) select 3 from cm1 on duplicate key update p = cm1.p;
ERROR 1054 (42S22): Unknown column 'cm1.p' in 'field list'

4. What is your TiDB version? (Required)

mysql> select tidb_version();
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()

                             |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v4.0.15-9-g605c1fa58b
Edition: Community
Git Commit Hash: 605c1fa58b0425817b3d8e258d1a1685d93d4d7c
Git Branch: release-4.0
UTC Build Time: 2021-11-28 07:23:59
GoVersion: go1.16.4
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[sylzd]

/assign

[guo-shaoge]

dup with #28078