Description:
mysql 64-bit compiled code
make test fail under solaris 10 x86 with studio 10 with all patches applied :
make test
cd mysql-test; ./mysql-test-run && ./mysql-test-run --ps-protocol
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Installing Slave Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests
TEST RESULT
-------------------------------------------------------
alias [ fail ]
Errors are (from /opt/src/fedora/mysql-4.1.12/mysql-test/var/log/mysqltest-time) :
/opt/src/fedora/mysql-4.1.12/client/.libs/mysqltest: At line 65: query 'SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie' failed: 1064: 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 '(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA','' at line 1
(the last lines may be the most important ones)
Aborting: alias failed in default mode. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
How to repeat:
Sun V40z server + solaris 10 with patches applied trough updateManager , sun Studio 10 x86 with patches
declare -x CC="cc"
declare -x CFLAGS="-xarch=amd64 -xchip=opteron -xCC -xO2 -xstrconst -mt"
declare -x CXX="CC"
declare -x CXXFLAGS="-xarch=amd64 -xchip=opteron -xO2 -noex -mt"
declare -x CXx="CC"
./configure --prefix=/opt/mysql --with-comment --with-innodb --with-archive-storage-engine --with-csv-storage-engine --with-extra-charset=complex --with-big-tables --with-raid --with-libwrap
Also you will need to fix isam/Makefile and myisam/Makefile for change :
CCLD = $(CC)
LINK = $(LIBTOOL) --mode=link $(CCLD) $(AM_CFLAGS) $(CFLAGS) \
$(AM_LDFLAGS) $(LDFLAGS) -o $@
to :
CCLD = $(CXX)
LINK = $(LIBTOOL) --mode=link $(CCLD) $(AM_CFLAGS) $(CXXFLAGS) \
$(AM_LDFLAGS) $(LDFLAGS) -o $@
Suggested fix:
Use 32 bit code
Description: mysql 64-bit compiled code make test fail under solaris 10 x86 with studio 10 with all patches applied : make test cd mysql-test; ./mysql-test-run && ./mysql-test-run --ps-protocol Installing Test Databases Removing Stale Files Installing Master Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/master-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Installing Slave Databases running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --basedir=. --datadir=./var/slave-data --skip-innodb --skip-ndbcluster --skip-bdb --language=../sql/share/english/ --character-sets-dir=../sql/share/charsets/ Manager disabled, skipping manager start. Loading Standard Test Databases Starting Tests TEST RESULT ------------------------------------------------------- alias [ fail ] Errors are (from /opt/src/fedora/mysql-4.1.12/mysql-test/var/log/mysqltest-time) : /opt/src/fedora/mysql-4.1.12/client/.libs/mysqltest: At line 65: query 'SELECT ELT(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA',''), 'Privat (Private Nutzung)','Privat (Private Nutzung) Sitz im Ausland','Privat (geschaeftliche Nutzung)','Privat (geschaeftliche Nutzung) Sitz im Ausland','Firma (Kapitalgesellschaft)','Firma (Kapitalgesellschaft) Sitz im Ausland','Firma (Personengesellschaft)','Firma (Personengesellschaft) Sitz im Ausland','oeff. rechtl. Koerperschaft','oeff. rechtl. Koerperschaft Sitz im Ausland','Eingetragener Verein','Eingetragener Verein Sitz im Ausland','Typ unbekannt') AS Kundentyp ,kategorie FROM t1 WHERE hdl_nr < 2000000 AND kategorie IN ('Prepaid','Mobilfunk') AND st_klasse = 'Workflow' GROUP BY kundentyp ORDER BY kategorie' failed: 1064: 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 '(FIELD(kundentyp,'PP','PPA','PG','PGA','FK','FKA','FP','FPA','K','KA','V','VA','' at line 1 (the last lines may be the most important ones) Aborting: alias failed in default mode. To continue, re-run with '--force'. Ending Tests Shutting-down MySQL daemon Master shutdown finished Slave shutdown finished How to repeat: Sun V40z server + solaris 10 with patches applied trough updateManager , sun Studio 10 x86 with patches declare -x CC="cc" declare -x CFLAGS="-xarch=amd64 -xchip=opteron -xCC -xO2 -xstrconst -mt" declare -x CXX="CC" declare -x CXXFLAGS="-xarch=amd64 -xchip=opteron -xO2 -noex -mt" declare -x CXx="CC" ./configure --prefix=/opt/mysql --with-comment --with-innodb --with-archive-storage-engine --with-csv-storage-engine --with-extra-charset=complex --with-big-tables --with-raid --with-libwrap Also you will need to fix isam/Makefile and myisam/Makefile for change : CCLD = $(CC) LINK = $(LIBTOOL) --mode=link $(CCLD) $(AM_CFLAGS) $(CFLAGS) \ $(AM_LDFLAGS) $(LDFLAGS) -o $@ to : CCLD = $(CXX) LINK = $(LIBTOOL) --mode=link $(CCLD) $(AM_CFLAGS) $(CXXFLAGS) \ $(AM_LDFLAGS) $(LDFLAGS) -o $@ Suggested fix: Use 32 bit code