Bug #38525 init_db.sql contains incorrect ./script/ code segment
Submitted: 1 Aug 2008 22:53 Modified: 6 Aug 2008 21:48
Reporter: Norm Wells Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.0 OS:Novell NetWare (nw6.5 sp7)
Assigned to: CPU Architecture:Any
Tags: init_db.sql, Netware

[1 Aug 2008 22:53] Norm Wells
Description:
The ./netware/Makefile.am,.in files presently create the ./netware init_db.sql from ./scripts/mysql_system_tables.sql and ./scripts/mysql_system_tables_fix.sql.

The correct scripts to use should be ./scripts/mysql_system_tables.sql and ./scripts/mysql_system_tables_data.sql as indicated by the Make dependencies.

The currently generated init_db.sql fails due to "existing table errors".

How to repeat:
Any 5.0 build for NetWare.

Suggested fix:
Change both ./netware/Makefile.am and ./netware/Makefile.in to 'cat' the init_db.sql dependencies.

-	@cat $(top_srcdir)/scripts/mysql_system_tables.sql \
-	     $(top_srcdir)/scripts/mysql_system_tables_fix.sql >> $@;
+	@cat $^ >> $@;
[2 Aug 2008 5:54] MySQL Verification Team
we're dealing with this currently in bug #30129
[6 Aug 2008 21:48] Norm Wells
G/Morning Shane,
Unsure of the manner you are using to address the previous bug, but for myself, don't see it directly related to the one I have added; the Makefile.xx's I have reported have one file name different between the init_db.sql dependencies and what is being used to create init_db.sl for NetWare. I see init_db.sql needing the files shown as dependencies, which is why I used the Make $^ tag in the suggested solution.
Thx, NW.