MySQL Bugs: #19142: INSERT statements in Script tab result in duplicates

Bug #19142	INSERT statements in Script tab result in duplicates
Submitted:	17 Apr 2006 16:26	Modified:	11 Oct 2006 0:45
Reporter:	Kolbe Kegel	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.20	OS:	Windows (Windows XP)
Assigned to:	Mike Lischke	CPU Architecture:	Any
Tags:	Source Editors

Description:
With MySQL Query Browser 1.1.20 on Windows XP connected to MySQL 5.0.19, Query Browser inserts duplicate rows into a table when executing a series of INSERT statements on a Script Tab.

How to repeat:
create table table1 (col1 int);

Execute the following from a Script Tab in QB:

insert into table1 (col1) values (2);
insert into table1 (col1) values (2);
insert into table1 (col1) values (3);
insert into table1 (col1) values (3);
insert into table1 (col1) values (4);
insert into table1 (col1) values (4);

select * from table1;

mysql> select * from table1;
+------+
| col1 |
+------+
| 2    |
| 2    |
| 3    |
| 3    |
| 4    |
| 4    |
| 4    |
+------+
7 rows in set (0.01 sec)

The same thing happens to me, too, on Windows 2003.

same here, Win2K.

WORKAROUND: Save an edited script and reload it into a new tab, it runs correctly. This error occurs with edited scripts.

if a script is loaded from a file, there is no incorrect behavior:
>>File/Open Script..
drop table if exists test.test;
create table test.test (x integer);
set @x=0;
insert into test.test (x) values (@x);
set @x=1;
insert into test.test (x) values (@x);
>>Execute
>>in result tab
select * from test.test t;
>>result is:
x
0
1

>>now modify the script:
drop table if exists test.test;
create table test.test (x integer);
set @x=0;
insert into test.test (x) values (@x);
set @x=1;
insert into test.test (x) values (@x);
set @x=2;
insert into test.test (x) values (@x);
>>Execute
>>in result tab
select * from test.test t;
>>result is:
x
0
1
1
2
2

>>go back to the script and re-execute, QB throws an error:
Could not fetch Catalog/Schema data
The following error occurred: MySQL server has goe away (2006)

>>Save the altered script, reload it into a new tab, it runs correctly:
drop table if exists test.test;
create table test.test (x integer);
set @x=0;
insert into test.test (x) values (@x);
set @x=1;
insert into test.test (x) values (@x);
set @x=2;
insert into test.test (x) values (@x);
>>Execute
>>in result tab
select * from test.test t;
>>result is:
x
0
1
2

after that, QB continues throwing exceptions and disconnecting from the host when the edited script is run. sometimes (not always), a further altered script is not executed, but a previous version seems to be executed.. sometimes the script is reported to have executed but isn't.. so something..

Thank you for the bug report. I was unable to repeat with version 1.2.4rc.
Please upgrade and try again. Thanks in advance.