MySQL Bugs: #24697: insert .. select ....ON DUPLICATE KEY UPDATE fails with ambiguous column name

regarding info from http://dev.mysql.com/doc/refman/5.1/en/insert-select.html To avoid ambigious column reference problems when the SELECT and the INSERT refer to the same table, provide a unique alias for each table used in the SELECT part, and ...

bugs.mysql.com