Bug #10255 value being updated automatically

• Submitted: 29 Apr 2005 1:42
• Modified: 29 May 2005 3:52
• Reporter: Melly Masram
• Status: No Feedback
• Category: MySQL Server: ISAM storage engine
• Severity: S1 (Critical)
• OS: Windows (Windows 2003 Advanced Server)
• CPU Architecture: Any

[29 Apr 2005 1:42] Melly Masram

Description:
I defined a table call biodata.One of the field (name-status), i define with type - varchar and Null-Yes.
When I insert a record, it will insert a value N in the field. When the status of the person become Yes, it will update the value N to Y.
The problem is, after somewhile..the database automatically send a statement to the table biodata and update all the value from Y to N.
Why is this happen..please help me!!!

How to repeat:
I defined a table call biodata.One of the field (name-status), i define with type - varchar and Null-Yes.
When I insert a record, it will insert a value N in the field. When the status of the person become Yes, it will update the value N to Y.
The problem is, after somewhile..the database automatically send a statement to the table biodata and update all the value from Y to N.
Why is this happen..please help me!!!

Suggested fix:
I defined a table call biodata.One of the field (name-status), i define with type - varchar and Null-Yes.
When I insert a record, it will insert a value N in the field. When the status of the person become Yes, it will update the value N to Y.
The problem is, after somewhile..the database automatically send a statement to the table biodata and update all the value from Y to N.
Why is this happen..please help me!!!

[29 Apr 2005 3:52] MySQL Verification Team

Could you please provide a test case with a table schema and queries
which are presenting this behavior.

[29 May 2005 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".