Bug #3379 | Replace deletes wrong record | ||
---|---|---|---|
Submitted: | 3 Apr 2004 6:39 | Modified: | 3 Apr 2004 8:27 |
Reporter: | SINISA MILIVOJEVIC | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S1 (Critical) |
Version: | 4.0.19 | OS: | Any (any) |
Assigned to: | Sergei Golubchik | CPU Architecture: | Any |
[3 Apr 2004 6:39]
SINISA MILIVOJEVIC
[3 Apr 2004 8:27]
Sergei Golubchik
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: REPLACE deletes all rows that has a collision on at least one UNIQUE key. As the second row you insert contain the same value in the thunk column (which is UNIQUE) as the first row, the first row has to be removed.