MySQL Bugs: #29820: SELECT from MySQL Query Browser causes data to be deleted/lost

Bug #29820	SELECT from MySQL Query Browser causes data to be deleted/lost
Submitted:	16 Jul 2007 12:47	Modified:	16 Jul 2007 17:02
Reporter:	Mohammad Inamullah	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	Query Browser 1.1.20	OS:	Windows (XP Pro)
Assigned to:		CPU Architecture:	Any
Tags:	data loss, query browser

Description:
MySQL Server 4.0.2a-nt / MySQL Query Browser 1.1.20 / MySQL Java connector 3.0.14

I have been using Query Browser for about 2 years now and never before came across this situation. For a particular table, after I programatically INSERT data, if I SELECT data using QB, the data gets displayed but gets removed from the table entirely. The table has 5 VARCHAR(200) fields and one DATE field. My JAVA programs does a successfull insert. From command line MySQL, doing a SELECT displays the data as expected; even with repeated issues of SELECT command, the data is fetched. However, in QB, the data gets fetched only the first time and then on the next repeat of a SELECT command, returns 0 resultsets.
As long as I do not look up the data using Query Browser it stays there; I can access/modify it programatically or with MySQL command line. Any attempt to SELECT it from QB deletes it after the first fetch. This happens with only this table. Any data inserted manually through QB query field persists as expected and does not get deleted upon repeated SELECTs.

So far, I have not figured out a work around this problem other than not using Query Browser on this table during software development.

How to repeat:
I have no idea of how to reapeat this. This is a simple small table and I have plenty of other tables like this with similar data with no problems. Renaming the table and removing all constraints has done nothing.

table info: t_patient_information
PATIENT_IDX        VARCHAR(200)
SSN                VARCHAR(200)
FIRST_NAME         VARCHAR(200)
MIDDLE_NAME        VARCHAR(200)
LAST_NAME          VARCHAR(200)
DATE_OF_BIRTH      DATE
SEX                VARCHAR(200)

JAVA Prepared statement query: "insert into t_patient_information values(?, ?, ?, ?, ?, ?, ?);"

Sample dataset successfully entered:
"PIDX-111", "4444444", "John", "A", "Doe", "1966-12-10", "Male"

Thank you for the report.

But version 1.1.20 is quite old and many bug have been fixed since. Please upgrade MySQL Query Browser to current version 1.2.12 and say us result.

My problem was solved by moving up from Query Browser 1.1.20 to 1.2.12. I am still not sure what the problem was.

Sorry, forgot to say thanks Sveta Smirnova :)

Thank you for the feedback.