Bug #60838 | on duplicate key update -- lost data | ||
---|---|---|---|
Submitted: | 12 Apr 2011 2:01 | Modified: | 12 May 2011 3:15 |
Reporter: | Alexander Danel | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: DML | Severity: | S2 (Serious) |
Version: | Ver 14.12 Distrib 5.0.91 | OS: | MacOS |
Assigned to: | CPU Architecture: | Any |
[12 Apr 2011 2:01]
Alexander Danel
[12 Apr 2011 3:15]
Valeriy Kravchuk
Try to execute select * from jobs where job_id IS NULL; again. You may be surprised. If you are, please, read http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_is-null. If not, please, send the output of SHOW CREATE TABLE for the jobs table.
[12 May 2011 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".