Description:
TEST RESULT
-------------------------------------------------------
ndb_cache2 [ fail ]
Errors are (from /home/patg/mysql-build/mysql-5.1-new/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ndb_cache2.result 2006-01-26 00:55:20.000000000 +0300
--- r/ndb_cache2.reject 2006-01-29 03:28:08.000000000 +0300
***************
*** 101,107 ****
1 3 3 First row
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 3
delete from t1 where c1='Fourth row';
show status like "Qcache_queries_in_cache";
Variable_name Value
--- 101,107 ----
1 3 3 First row
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 2
delete from t1 where c1='Fourth row';
show status like "Qcache_queries_in_cache";
Variable_name Value
***************
*** 111,117 ****
1 3 3 First row
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 3
use test;
select * from t1 order by pk desc;
pk a1 b1 c1
--- 111,117 ----
1 3 3 First row
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 2
use test;
select * from t1 order by pk desc;
pk a1 b1 c1
***************
*** 122,128 ****
1 3 3 First row
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 4
update t1 set a1=4 where b1=3;
use test;
show status like "Qcache_queries_in_cache";
--- 122,128 ----
1 3 3 First row
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 3
update t1 set a1=4 where b1=3;
use test;
show status like "Qcache_queries_in_cache";
***************
*** 138,147 ****
1 4 3 First row
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 7
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 5
select * from t1 order by pk desc;
pk a1 b1 c1
2 7 8 Second row
--- 138,147 ----
1 4 3 First row
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 8
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 4
select * from t1 order by pk desc;
pk a1 b1 c1
2 7 8 Second row
***************
*** 155,164 ****
Qcache_queries_in_cache 1
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 7
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 7
select * from t2;
pk a2 b2
1 2 3
--- 155,164 ----
Qcache_queries_in_cache 1
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 8
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 6
select * from t2;
pk a2 b2
1 2 3
***************
*** 611,620 ****
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 10
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 15
drop table t1, t2, t3, t4, t5;
show status like "Qcache_queries_in_cache";
Variable_name Value
--- 611,620 ----
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 15
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 10
drop table t1, t2, t3, t4, t5;
show status like "Qcache_queries_in_cache";
Variable_name Value
-------------------------------------------------------
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: ndb_cache2 failed in default mode. To continue, re-run with '--force'.
Ending Tests
Shutting-down MySQL daemon
Master(s) shutdown finished
Slave(s) shutdown finished
patg@govinda:~/mysql-build/mysql-5.1-new/mysql-test>
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ndb_cache_multi2.result 2006-01-26 00:55:20.000000000 +0300
--- r/ndb_cache_multi2.reject 2006-01-29 03:35:07.000000000 +0300
***************
*** 61,76 ****
Qcache_hits 0
select * from t1;
a
! 3
show status like "Qcache_queries_in_cache";
Variable_name Value
Qcache_queries_in_cache 2
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 3
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 0
drop table t1, t2;
set GLOBAL query_cache_size=0;
set GLOBAL ndb_cache_check_time=0;
--- 61,76 ----
Qcache_hits 0
select * from t1;
a
! 2
show status like "Qcache_queries_in_cache";
Variable_name Value
Qcache_queries_in_cache 2
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 2
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 1
drop table t1, t2;
set GLOBAL query_cache_size=0;
set GLOBAL ndb_cache_check_time=0;
-------------------------------------------------------
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.
How to repeat:
Build latest from bk:
last several entries on my tree:
ChangeSet@1.2075.1.1, 2006-01-27 20:27:10+01:00, pekka@mysql.com
ndb - wl#2972 fix null blobs
ChangeSet@1.2076.4.1, 2006-01-27 16:41:53+01:00, rburnett@production.mysql.com
BUG#15820 - Can create table with 1 partition, then doing ALTER .. ADD PARTITION crashes
It is ok for a partitioned table to have only 1 partition. This test is just to show that
doing the ALTER TABLE ADD PARTITION doesn't crash the server.
partition_mgm_err.result:
Added result block for test of bug #15820
partition_mgm_err.test:
Added test block for bug #15820
ChangeSet@1.2081.1.4, 2006-01-27 15:58:00+01:00, jonas@perch.ndb.mysql.com
ndb - fix compile error on sles9-x86
Run make test, or cd ./mysql-test/, ./mysql-test-run.pl ndb_cache2, ./mysql-test.run.pl ndb_cache_multi2
