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 Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S2 (Serious)
Version:mysql-4.1.1-alpha-nightly-20031123 OS:Linux (linux / redhat 9)
Assigned to: 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.