Bug #33131 problem with update query
Submitted: 11 Dec 2007 7:14 Modified: 11 Jan 2008 7:44
Reporter: ajesh avirachan Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version: 5.0.45-log OS:Linux (2.6.9-5.EL)
Assigned to: CPU Architecture:Any

[11 Dec 2007 7:14] ajesh avirachan 
Description:
Hi,

  My program runs the query " UPDATE book_ms set book_desc='s' and book_type='fff'  where book_id=61;" . I was expected to happen the updation in the table.  Even though the result as shown below.

Query OK, 1 row affected, 1 warning (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

Then i execute the SELECT query, i didn't get the updated result. 

But the query " UPDATE book_ms set book_desc='s', book_type='fff'  where book_id=61;" works fine . 

why it is happening like this? Is it a Bug?

Thanking you
Ajesh
Software Engineer.

How to repeat:
Trying to use the same update query else where , same problem occurs.
[11 Dec 2007 7:44] Sveta Smirnova 
Thank you for the report.

Please provide complete test case showing the problem.
[12 Jan 2008 0: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".