System:
* Powermac with dual g4 533MHz CPU's, 1 GB RAM, SCSi drives
* Yellow Dog Linux 3.0.1
* gcc-3.3.2
* glibc-2.3.1-51a
===============================================================
Updated my BK tree today and ran the test suite:
mysql-4.1/mysql-test/mysql-test-run --force --with-ndbcluster
Results:
Failed 4/278 tests, 98.56% successful
* grant_cache
* ndb_basic
* ndb_lock
* system_mysql_db_fix
=================================================================
The ndb test failures are not really failures. The row ordering from a
command like
SELECT * FROM t1
is most likely hardware dependent [Is that correct???].
For example,
-------------------------------------------------------
*** r/ndb_basic.result 2004-07-27 18:36:25.000000000 +0300
--- r/ndb_basic.reject 2004-07-27 20:33:09.000000000 +0300
***************
*** 31,38 ****
UPDATE t1 SET pk1=pk1 + 1;
SELECT * FROM t1;
pk1 attr1 attr2 attr3
- 9412 9413 17 9413
3 1 NULL 9412
DELETE FROM t1;
SELECT * FROM t1;
pk1 attr1 attr2 attr3
--- 31,38 ----
UPDATE t1 SET pk1=pk1 + 1;
SELECT * FROM t1;
pk1 attr1 attr2 attr3
3 1 NULL 9412
+ 9412 9413 17 9413
DELETE FROM t1;
SELECT * FROM t1;
pk1 attr1 attr2 attr3
-------------------------------------------------------
*** r/ndb_lock.result 2004-07-27 18:36:25.000000000 +0300
--- r/ndb_lock.reject 2004-07-27 20:33:26.000000000 +0300
***************
*** 19,25 ****
commit;
select * from t1;
x y
- 2 two
3 three
1 one
commit;
--- 19,25 ----
commit;
select * from t1;
x y
3 three
+ 2 two
1 one
commit;
-------------------------------------------------------
If an 'ORDER BY" clause is added to the tests, the tests will pass.
The output from the other two tests that failed are shown below:
-------------------------------------------------------
*** r/grant_cache.result 2004-07-27 18:36:24.000000000 +0300
--- r/grant_cache.reject 2004-07-27 20:24:12.000000000 +0300
***************
*** 112,119 ****
Variable_name Value
Qcache_not_cached 1
show grants for current_user();
! Grants for @localhost
! GRANT USAGE ON *.* TO ''@'localhost'
select "user2";
user2
user2
--- 112,119 ----
Variable_name Value
Qcache_not_cached 1
show grants for current_user();
! Grants for root@localhost
! GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION
select "user2";
user2
user2
-------------------------------------------------------
I suspect that the result set for the grant_cache test is just wrong.
Would someone please verify this one way or the other.
--------------------------------------------------------
system_mysql_db_fix [ fail ]
Errors are (from
/usr/local/src/MySQL/Cluster/mysql-4.1/mysql-test/var/log/mysqltest-time) :
ERROR 1045: Access denied for user 'root'@'localhost' (using password:
YES)
cat: write error: Broken pipe
/usr/local/src/MySQL/Cluster/mysql-4.1/client/.libs/mysqltest: At line
10: query 'show create table func' failed: 1146: Table 'test.func'
doesn't exist
(the last lines may be the most important ones)
Ending Tests
Shutting-down MySQL daemon
Master shutdown finished
Slave shutdown finished
Resuming
Tests
----------------------------------------------------------
I have looked at system_mysql_db_fix.test and am not sure how this test
could ever run since it refers to some non-existent tables. I am not
sure what is causing the permission problem.
-Joseph
--
Joseph E. Sacco, Ph.D. <jsacco[at]earthlink[dot]net>
