MySQL schema appears to be broken

Ade Lovett ade at freebsd.org
Sat Feb 11 19:49:23 EST 2006


Doing some experiments here, and needed to set up a test database (db  
host is 6.0-STABLE/amd64 running mysql-4.1.16).

mysql -u tinderbox --password=XXX tbtest < tinderbox-mysql.schema

leads to the following error:

ERROR 1064 (42000) at line 244: You have an error in your SQL syntax;  
check the manual that corresponds to your MySQL server version for  
the right syntax to use near ')' at line 1

and from the schema file:

244: INSERT INTO port_fail_patterns VALUES (1500, 'configure: error:  
cpu .* not supported', 'arch', );

comparing with other lines, it looks like it's missing a trailing  
'0', and there appear to be a number of other such broken lines  
within the schema file.

I haven't tested the pgsql schema yet.

-aDe



More information about the tinderbox-list mailing list