Bug #1940 fill_help_tables.sql length of inserts too long

• Submitted: 24 Nov 2003 19:39
• Modified: 1 Dec 2003 13:07
• Reporter: Pete Lancashire
• Status: Can't repeat
• Category: MySQL Server: Installing
• Severity: S2 (Serious)
• Version: mysql-4.1.1-alpha-nightly-20031123
• OS: Linux (linux / redhat 9)
• CPU Architecture: Any

[24 Nov 2003 19:39] Pete Lancashire

Description:
mysql_install_db fails with a SQL error

in the file fill_help_tables.sql,

the insert into the table help_topic is too long.
If you break it up into multiple inserts, it does not error. This may
be unique to Linux/redhat only.

also the file does not start with

use mysql;

can't remember if that was needed to make things work

How to repeat:
create a tmp .sql file, delete all inserts other then the first one
for the table help_topics.

run, it will give a sql error

break up so that each row is individually inserted.

this passes

i then combined rows with help_topic_id 0,1,2 & 3, for a total of 4 rows
2036 characters
this passed

then combined the above with help_topic_id 4, for a total of 5 rows.
this failed

my guess is line length, so went back to just 0,1,2 &3 and increased the line by adding text just before MySQL supp...

a line length of 2049 characters works, 2050 fails.

[1 Dec 2003 13:07] Dean Ellis

I cannot repeat this with the latest snapshot, unless I set max_allowed_packet too low to allow the queries (which is to be expected).  Perhaps that is your issue as well.

Thank you.