Bulk Insert — Bug?

[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