Data Insertion Difference When Using "execute All Queries"

[dhayes]

I’ve encountered a strange error when inserting data through a query window.  To reproduce the error:

 

1.  Create a simple table:

 

create table SQLYOG_BUG (IDX int not null auto_increment primary key, TEXT1 text);

 

2.  Type the following into a query window.  Note there are several blank lines between some of the words.

 

insert into SQLYOG_BUG (TEXT1) values (‘this

should have

 

 

multiple 

 

 

 

blank lines’);

 

3.  When I execute the query using F9 or the single query button and then view the contents of TEXT1, I get what I expect (multiple blank lines in the result):

 

this

should have

 

 

multiple 

 

 

 

blank lines

 

 

However, if I use the “Execute All Queries” (Ctrl+F9) I get this (multiple blank lines appear to be compressed into one):

 

this

should have

multiple 

blank lines

 

 

This is happening with SQLyog Enterprise v11.11 (64 bit) and SQLyog Community v12.09 (64 bit).

 

[Kartik Grover]

Hi

 

This issue is reproducible. Thank you for reporting it. We will fix it.

 

Thanks and Regards

Kartik

[Author]

Posts