Bug #51444 Workbench cannot read commited records
Submitted: 24 Feb 2010 4:22 Modified: 4 Apr 2010 13:36
Reporter: Juan Chung Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S3 (Non-critical)
Version:5.2.15 OSS beta rev 5053 OS:Windows (Windows XP SP3)
Assigned to: CPU Architecture:Any
Tags: commit, workbench

[24 Feb 2010 4:22] Juan Chung 
Description:
The autocommit value had been set to 0( zero ), then I insert a record to a table and successfully  committed the transaction in Java App client through jdbc. I execute query in the command line and the record just insert had successfully be fetched, but execute the same query script in workbech, the record just inserted could not be fetched. only after executing the commit command in the workbench, the record can be queried.

How to repeat:
1.set autocommit=0.
2.insert a record to a table from java app through jdbc and commit the transaction.
3.execute query in the workbech.

Suggested fix:
the workbench should read the committed records, not execute the commit command again.
[4 Mar 2010 13:37] Susanne Ebrecht 
Please provide your script.
[4 Apr 2010 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".