Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Bulk Insert — Bug?

forums forums SQLyog SQLyog: Bugs / Feature Requests Bulk Insert — Bug?

  • This topic is empty.
Viewing 8 reply threads
  • Author
    Posts
    • #22160
      peterlaursen
      Participant

      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.

    • #22161
      peterlaursen
      Participant

      @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!

    • #22162
      FireStorm9
      Member
      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]

    • #22163
      peterlaursen
      Participant

      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

    • #22164
      FireStorm9
      Member
      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!

    • #22165
      peterlaursen
      Participant

      “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' ?

    • #22166
      FireStorm9
      Member
      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,

    • #22167
      peterlaursen
      Participant

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

    • #22168
      FireStorm9
      Member
      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!

Viewing 8 reply threads
  • You must be logged in to reply to this topic.