MySQL schema appears to be broken
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.
More information about the tinderbox-list