Bug #38525 init_db.sql contains incorrect ./script/ code segment
Submitted: 2 Aug 2008 0:53 Modified: 6 Aug 2008 23:48
Reporter: Norm Wells
Status: Duplicate
Category:Server: Installing Severity:S3 (Non-critical)
Version:5.0 OS:Novell NetWare (nw6.5 sp7)
Assigned to: Target Version:
Tags: init_db.sql, Netware

[2 Aug 2008 0: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 7:54] Shane Bester 
we're dealing with this currently in bug #30129
[6 Aug 2008 23: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.