Bug #10255 value being updated automatically
Submitted: 29 Apr 2005 1:42 Modified: 29 May 2005 3:52
Reporter: Melly Masram Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: ISAM storage engine Severity:S1 (Critical)
Version: OS:Windows (Windows 2003 Advanced Server)
Assigned to: 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".