Bug #44904 | LIMIT IN INSERT ... DUPLICATE KEY UPDATE DIFFER IN THE SMPLE LIMIT | ||
---|---|---|---|
Submitted: | 15 May 2009 14:19 | Modified: | 10 Feb 2018 17:27 |
Reporter: | giovanni silva | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S3 (Non-critical) |
Version: | 5.0, 5.1 | OS: | Windows (XP SP3) |
Assigned to: | CPU Architecture: | Any |
[15 May 2009 14:19]
giovanni silva
[17 May 2009 11:48]
Sveta Smirnova
Thank you for the report. You said: ----<Q>---- A LIMIT clause works differently for these two types of update: -- update row with pk = 3 update cep set cep = 'XXX' where codigo = 4 or cep = 'AAA' limit 1 --update row with pk = 4 insert into cep(codigo, cep) values(4, 'AAA') on duplicate key update cep = 'XXX'; ----</Q>---- But second query does not have LIMIT clause. Please explain what you mean.
[17 Jun 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[10 Feb 2018 17:27]
Roy Lyseng
Posted by developer: Closing bug since it has been suspended for 9 years.