ports/71698: MySQL 4.0 server fails to build static

[SiGNOUT]

>Number:         71698
>Category:       ports
>Synopsis:       MySQL 4.0 server fails to build static
>Confidential:   no
>Severity:       serious
>Priority:       high
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Mon Sep 13 09:30:18 GMT 2004
>Closed-Date:
>Last-Modified:
>Originator:     SiGNOUT
>Release:        FreeBSD 5.3-BETA3 i386
>Organization:
N/A
>Environment:
System: FreeBSD mysql.signout.dk 5.3-BETA3 FreeBSD 5.3-BETA3 #1: Fri Sep 10 14:03:19 CEST 2004 signout at mysql.signout.dk:/usr/obj/usr/src/sys/SiGNOUT i386

>Description:
MySQL 4.0.20 server cannot build if BUILD_STATIC is set

# /usr/ports/databases/mysql40-server
# make BUILD_STATIC=1

<cut>
c++ -DDBUG_OFF -O -pipe -O -pipe -felide-constructors -fno-rtti -fno-exceptions -fno-implicit-templates -fno-exceptions -fno-rtti -DMYSQLD_NET_RETRY_COUNT=1000000 -o mysqld sql_lex.o sql_handler.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o field.o key.o sql_class.o sql_list.o net_serv.o net_pkg.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o convert.o set_var.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_update.o sql_delete.o uniques.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o des_key_file.o time.o opt_range.o opt_sum.o opt_ft.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innodb.o ha_isam.o ha_isammrg.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o sl
 ave.o sql_repl.o sql_union.o mini_client.o mini_client_errors.o stacktrace.o repl_failsafe.o sql_olap.o -static -L../bdb/build_unix -ldb ../innobase/usr/libusr.a ../innobase/srv/libsrv.a ../innobase/dict/libdict.a ../innobase/que/libque.a ../innobase/srv/libsrv.a ../innobase/ibuf/libibuf.a ../innobase/row/librow.a ../innobase/pars/libpars.a ../innobase/btr/libbtr.a ../innobase/trx/libtrx.a ../innobase/read/libread.a ../innobase/usr/libusr.a ../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a ../innobase/eval/libeval.a ../innobase/log/liblog.a ../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innoba
 se/ut/libut.a ../isam/libnisam.a ../merge/libmerge.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lwrap -lpthread -lz -lcrypt -lm -lpthread
/usr/lib/libc.a(isnan.o)(.text+0x60): In function `__isnanl':
: multiple definition of `__isnanl'
/usr/lib/libm.a(s_isnan.o)(.text+0x24): first defined here
*** Error code 1
</cut>

>How-To-Repeat:
# /usr/ports/databases/mysql40-server
# make BUILD_STATIC=1

>Fix:

I have no idea - building without static can be a workaround until a fix is present


>Release-Note:
>Audit-Trail:
>Unformatted: