I downloaded version 5.0 on 30/08/03,
everything went fine until I did make test
it failed with an error in derived,
/root/mysql5.0/mysql-5.0/client/.libs/mysqltest: At line 97: Result content mismatch
see output and attached.
I then tried make test --force as suggested, but --force is an unrecognized option.
GNU make version is 3.80-25
Regards
Michael Newport
linux:~/mysql5.0/mysql-5.0 # 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
--basedir=. --datadir=./var/master-data --skip-innodb --skip-bdb
--language=../sql/share/english/
Installing Slave Databases
running ../sql/mysqld --no-defaults --bootstrap --skip-grant-tables
--basedir=. --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_ujis [ skipped ]
delayed[ pass ]
delete [ pass ]
derived[ fail ]
Errors are (from
/root/mysql5.0/mysql-5.0/mysql-test/var/log/mysqltest-time) :
/root/mysql5.0/mysql-5.0/client/.libs/mysqltest: At line 97: Result
content 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/derived.resultSat Aug 30 16:03:29 2003
--- r/derived.rejectSat Aug 30 16:38:16 2003
***
*** 182,195
105 3
explain SELECT d.pla_id, m2.mat_id FROM t1 m2 INNER JOIN (SELECT
mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON
mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum;
idselect_type table typepossible_keys key key_len
ref rowsExtra
! 1 PRIMARY m2 ALL NULLNULLNULLNULL9
! 1 PRIMARY derived2 ALL NULLNULLNULLNULL
6 Using where
2 DERIVED mp ALL NULLNULLNULLNULL9
Using temporary; Using filesort
2 DERIVED m2 index NULLPRIMARY 3 NULL9
Using index
explain SELECT d.pla_id, m2.test FROM t1 m2 INNER JOIN (SELECT
mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON
mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum;
idselect_type table typepossible_keys key key_len
ref rowsExtra
! 1 PRIMARY m2 ALL NULLNULLNULLNULL9
! 1 PRIMARY derived2 ALL NULLNULLNULLNULL
6 Using where
2 DERIVED mp ALL NULLNULLNULLNULL9
Using temporary; Using filesort
2 DERIVED m2 index NULLPRIMARY 3 NULL9
Using index
drop table t1,t2;
--- 182,195
105 3
explain SELECT d.pla_id, m2.mat_id FROM t1 m2 INNER JOIN (SELECT
mp.pla_id, MIN(m1.matintnum) AS matintnum FROM t2 mp INNER JOIN t1 m1 ON
mp.mat_id=m1.mat_id GROUP BY mp.pla_id) d ON d.matintnum=m2.matintnum;
idselect_type table typepossible_keys key key_len
ref rowsExtra
! 1 PRIMARY derived2 ALL NULLNULLNULLNULL6
! 1 PRIMARY m2 ALL NULLNULLNULLNULL9
Using where
2 DERIVED mp ALL NULLNULLNULLNULL9
Using temporary; Using filesort
2