Description:
I hope the following output of "make test" will help developers. I compiled the 4.1.1-alpha with tru64unix native compiler (64-bit) and ran "make test" after this. Here is the output:
# make test
cd mysql-test ; ./mysql-test-run
Installing Test Databases
Removing Stale Files
Installing Master Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --based
ir=. --datadir=./var/master-data --skip-innodb --skip-bdb --language=../sql/shar
e/english/
Installing Slave Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables --based
ir=. --datadir=./var/slave-data --skip-innodb --skip-bdb --language=../sql/share
/english/
Manager disabled, skipping manager start.
Loading Standard Test Databases
Starting Tests
TEST RESULT
------------------------------------------
alias [ pass ]
alter_table [ pass ]
analyse [ pass ]
ansi [ pass ]
auto_increment [ pass ]
backup [ pass ]
bdb-alter-table-1 [ skipped ]
bdb-alter-table-2 [ skipped ]
bdb-crash [ skipped ]
bdb-deadlock [ skipped ]
bdb [ skipped ]
bdb_cache [ skipped ]
bench_count_distinct [ pass ]
bigint [ pass ]
binary [ pass ]
bool [ pass ]
bulk_replace [ pass ]
case [ pass ]
cast [ pass ]
check [ pass ]
comments [ pass ]
compare [ pass ]
connect [ pass ]
constraints [ pass ]
count_distinct [ pass ]
count_distinct2 [ pass ]
count_distinct3 [ pass ]
create [ pass ]
ctype_collate [ pass ]
ctype_cp1251 [ pass ]
ctype_latin1_de [ pass ]
ctype_many [ skipped ]
ctype_mb [ pass ]
ctype_recoding [ pass ]
ctype_ucs [ skipped ]
ctype_ujis [ skipped ]
ctype_utf8 [ pass ]
date_formats [ pass ]
delayed [ pass ]
delete [ pass ]
derived [ pass ]
dirty_close [ pass ]
distinct [ pass ]
drop [ pass ]
drop_temp_table [ pass ]
empty_table [ pass ]
errors [ pass ]
explain [ pass ]
flush [ pass ]
flush_table [ pass ]
foreign_key [ pass ]
fulltext [ pass ]
fulltext2 [ pass ]
fulltext_cache [ pass ]
fulltext_distinct [ pass ]
fulltext_left_join [ pass ]
fulltext_multi [ pass ]
fulltext_order_by [ pass ]
fulltext_update [ pass ]
fulltext_var [ pass ]
func_compress [ skipped ]
func_concat [ pass ]
func_crypt [ pass ]
func_date_add [ pass ]
func_default [ pass ]
func_encrypt [ skipped ]
func_equal [ pass ]
func_gconcat [ pass ]
func_group [ pass ]
func_if [ pass ]
func_in [ pass ]
func_isnull [ pass ]
func_like [ pass ]
func_math [ pass ]
func_misc [ pass ]
func_op [ pass ]
func_regexp [ pass ]
func_sapdb [ pass ]
func_set [ pass ]
func_str [ pass ]
func_system [ pass ]
func_test [ pass ]
func_time [ pass ]
func_timestamp [ pass ]
gcc296 [ pass ]
gis-rtree [ pass ]
gis [ pass ]
grant [ pass ]
grant2 [ pass ]
grant_cache [ pass ]
group_by [ pass ]
handler [ pass ]
having [ pass ]
heap [ pass ]
heap_auto_increment [ pass ]
heap_btree [ pass ]
heap_hash [ pass ]
help [ pass ]
innodb-deadlock [ pass ]
innodb [ pass ]
innodb_cache [ pass ]
innodb_handler [ pass ]
insert [ pass ]
insert_select [ pass ]
insert_update [ pass ]
isam [ skipped ]
join [ pass ]
join_crash [ pass ]
join_outer [ pass ]
key [ pass ]
key_cache [ pass ]
key_diff [ pass ]
key_primary [ pass ]
keywords [ pass ]
kill [ pass ]
limit [ pass ]
loaddata [ pass ]
lock [ pass ]
lock_multi [ pass ]
lock_tables_lost_commit [ pass ]
lowercase_table [ pass ]
merge [ pass ]
mix_innodb_myisam_binlog [ pass ]
multi_update [ pass ]
myisam [ pass ]
mysqlbinlog [ pass ]
mysqldump [ pass ]
negation_elimination [ pass ]
null [ pass ]
null_key [ pass ]
odbc [ pass ]
olap [ pass ]
openssl_1 [ skipped ]
order_by [ pass ]
order_fill_sortbuf [ pass ]
outfile [ pass ]
overflow [ pass ]
packet [ pass ]
preload [ pass ]
query_cache [ pass ]
query_cache_merge [ pass ]
raid [ skipped ]
range [ pass ]
rename [ pass ]
repair_part1 [ pass ]
repair_part2 [ pass ]
replace [ skipped ]
rollback [ pass ]
row [ pass ]
rpl000001 [ pass ]
rpl000002 [ pass ]
rpl000004 [ pass ]
rpl000005 [ pass ]
rpl000006 [ pass ]
rpl000008 [ pass ]
rpl000009 [ pass ]
rpl000010 [ pass ]
rpl000011 [ pass ]
rpl000012 [ pass ]
rpl000013 [ pass ]
rpl000015 [ fail ]
Errors are (from /scratch/sources/mysql-4.1.1-alpha/mysql-test/var/log/mysqltest
-time) :
/scratch/sources/mysql-4.1.1-alpha/client/.libs/mysqltest: At line 40: Result le
ngth mismatch
(the last line(s) may be the ones that caused the die() in mysqltest)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/rpl000015.result Mon Dec 1 16:20:37 2003
--- r/rpl000015.reject Wed Apr 21 10:21:43 2004
***************
*** 8,14 ****
change master to master_host='127.0.0.1';
show slave status;
Slave_IO_State Master_Host Master_User Master_Port Connect_
Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos
Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicat
e_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table
Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Err
or Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition
Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File
Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key
Seconds_Behind_Master
! # 127.0.0.1 test MASTER_PORT 7 4 slave-re
lay-bin.000001 4 No No
0 0 0 4 None 0
No #
change master to master_host='127.0.0.1',master_user='root',
master_password='',master_port=MASTER_PORT;
show slave status;
--- 8,14 ----
change master to master_host='127.0.0.1';
show slave status;
Slave_IO_State Master_Host Master_User Master_Port Connect_
Retry Master_Log_File Read_Master_Log_Pos Relay_Log_File Relay_Log_Pos
Relay_Master_Log_File Slave_IO_Running Slave_SQL_Running Replicat
e_Do_DB Replicate_Ignore_DB Replicate_Do_Table Replicate_Ignore_Table
Replicate_Wild_Do_Table Replicate_Wild_Ignore_Table Last_Errno Last_Err
or Skip_Counter Exec_Master_Log_Pos Relay_Log_Space Until_Condition
Until_Log_File Until_Log_Pos Master_SSL_Allowed Master_SSL_CA_File
Master_SSL_CA_Path Master_SSL_Cert Master_SSL_Cipher Master_SSL_Key
Seconds_Behind_Master
! # 127.0.0.1 test 3308 7 4 slave-relay-bin.
000001 4 No No
0 0 0 4 None 0 No
#
change master to master_host='127.0.0.1',master_user='root',
master_password='',master_port=MASTER_PORT;
show slave status;
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
Aborting: rpl000015 failed. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
make: *** [test] Error 1
How to repeat:
CXXLDFLAGS="-lwrap" \
CC="cc -std0 -pthread -DTHREAD -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DTCPWRAP_MYSQL -D__STDC__ -DDBUG_OFF -DHAVE_LIBWRAP" \
CXX="cxx -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DTCPWRAP_MYSQL -D__STDC__ -DDBUG_OFF -DHAVE_LIBWRAP" CFLAGS="-DUSE_SYMDIR -DHAVE_GETHOSTBYNAME_R_RETURN_INT -DHAVE_LIBWRAP" \
LIB_EXTRA_CCFLAGS="-lwrap" \
./configure \
--prefix=/usr/local_test \
--enable-thread-safe-client \
--enable-local-infile \
--with-pthread \
--with-unix-socket-path=/tmp/mysql_4.1.sock \
--with-tcp-port=3308 \
--with-mysqld-user=mysql \
--with-libwrap=/usr/local \
--without-debug \
--with-charset=utf8 \
--with-collation=utf8_general_ci
make
make test
Suggested fix:
Just to inform the developers about the current status on this platform - probably it helps to produce the stable code branch ....