Bulk Insert — Bug?

[FireStorm9]

First off, thanks for this great product!!!!

I think I found a bug in 5.17 Final.

When using Export as SQL Statements, select “Data only” and clear ALL options EXCEPT “Create Bulk Insert Statements”. The expected result is:

Code:

INSERT INTO TABLE FOO VALUES
(1, 2, 3),
(2, 3, 4),
(5, 6, 7)

The actual result is

Code:

INSERT INTO TABLE FOO (`a`, `b`, `c`) VALUES (1, 2, 3)
INSERT INTO TABLE FOO (`a`, `b`, `c`) VALUES (2, 3, 4)
INSERT INTO TABLE FOO (`a`, `b`, `c`) VALUES (4, 5, 6)

Also, on a second topic, I'd like to post a feature request (well, ok, two feature requests):

1. Be able to export as sql statements TO THE EDIT WINDOW instead of forcing to dump to file, and

2. Be able to export RESULT SETS as SQL STATEMENTS, ala PHPMyAdmin.

Thanks tons!

-=FireStorm

[peterlaursen]

1) the 'bug'

Not reproducable! I get for instance this INSERT statement:

Code:

insert into `tablename1` (`id`,`v`) values (1,'a'),(2,'b'),(3,'c');

.. and that IS a BULK insert statement to my best understanding.

2) requests:

both are reasonable. I do not know how hard is is to copy to the editor.

[peterlaursen]

@FireStorm9

Now if you are sure that you do not get BULKs when you specify it, we will have to find the reason for difference!

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 12:17 AM:

@FireStorm9

Now if you are sure that you do not get BULKs when you specify it, we will have to find the reason for difference!

I am sure. Please see the attached files for selection, result, and version information.

The connection is to a Linux server on my local lan, i.e. no ssh tunneling or anything special.

If there's anything I can do to to help I'd love to!

Thanks!!!

[attachment=506:attachment]

[attachment=509:attachment]

[attachment=510:attachment]

[peterlaursen]

tools … preferences … General TAB.

What is the setting for 'Max packet Size' on your system?

If it is = (zero) or very low that woluld explain!

http://webyog.com/faq/24_101_en.html

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 02:58 PM:

tools … preferences … General TAB.

What is the setting for 'Max packet Size' on your system?

If it is = (zero) or very low that woluld explain!

http://webyog.com/faq/24_101_en.html

I checked and it was indeed set to custom: 8.

I changed it to “server default” and got the same result (complete sql statements).

I restarted SQLYog just in case, but STILL got the same results.

Thanks!

[peterlaursen]

“I changed it to “server default””

'server default' means that the server setting for max_allowed_packet is used.

What is the server 'max_allowed_packet' in your case?

(tool .. show .. variables will tell).

What happens if you set the BULK sixe yourself to – say – '200' ?

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 09:21 PM:

“I changed it to “server default””

'server default' means that the server setting for max_allowed_packet is used.

What is the server 'max_allowed_packet' in your case?

(tool .. show .. variables will tell).

What happens if you set the BULK sixe yourself to – say – '200' ?

show variables like 'max_allowed_p%';

Code:

Variable_name Value
—————— ——-
max_allowed_packet 1047552

Set to custom: 512

Same result.

Thanks,

[peterlaursen]

OKOKOKOK .. I give up then … let us return to this later next week!

[FireStorm9]

peterlaursen wrote on Aug 25 2006, 11:13 PM:

OKOKOKOK .. I give up then … let us return to this later next week!

Ahhh come on!!!! 🙂

Have a good weekend!

[Author]

Posts