MySQL Bugs: #32696: index_merge

Bug #32696	index_merge_falcon.test fails
Submitted:	25 Nov 2007 11:39	Modified:	26 May 2010 17:49
Reporter:	Ingo Strüwing	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Falcon storage engine	Severity:	S2 (Serious)
Version:	6.0.4	OS:	Any
Assigned to:	Olav Sandstå	CPU Architecture:	Any
Tags:	F_HANDLER, pb2, pushbuild, test failure

Description:
falcon.index_merge_falcon      [ fail ]

--- /data/pushbuild/pb/mysql-6.0-engines/45/mysql-6.0-engines-clone/mysql-test/suite/falcon/r/index_merge_falcon.result	2007-09-20 18:43:21 +03:00
+++ /data/pushbuild/pb/mysql-6.0-engines/45/mysql-6.0-engines-clone/mysql-test/suite/falcon/r/index_merge_falcon.reject	2007-11-25 08:40:51 +03:00
@@ -51,13 +51,13 @@
 64801
 explain select key1,key2 from t1 where key1=100 and key2=100;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ref	key1,key2	key1	5	const	6480	Using where
+1	SIMPLE	t1	range	key1,key2	key2	5	NULL	6480	Using where
 select key1,key2 from t1 where key1=100 and key2=100;
 key1	key2
 100	100
 explain select key1,key2,key3,key4,filler1 from t1 where key1=100 and key2=100 or key3=100 and key4=100;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	index_merge	key1,key2,key3,key4	key1,key3	5,5	NULL	12960	Using sort_union(key1,key3); Using where
+1	SIMPLE	t1	index_merge	key1,key2,key3,key4	key2,key4	5,5	NULL	12960	Using sort_union(key2,key4); Using where
 select key1,key2,key3,key4,filler1 from t1 where key1=100 and key2=100 or key3=100 and key4=100;
 key1	key2	key3	key4	filler1
 100	100	100	100	key1-key2-key3-key4
@@ -65,21 +65,21 @@
...
@@ -373,7 +373,7 @@
 explain select count(*) from t1 where
 key1a = 2 and key1b is null and key3a = 2 and key3b is null;
 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
-1	SIMPLE	t1	ref	i1,i3	i1	10	const,const	51	Using where
+1	SIMPLE	t1	range	i1,i3	i1	10	NULL	51	Using where
 select count(*) from t1 where
 key1a = 2 and key1b is null and key3a = 2 and key3b is null;
 count(*)

mysqltest: Result content mismatch

Disabling test case. Please re-enable after fix.

How to repeat:
See pushbuild, for example https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-6.0-engines
log https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0-engines&entry=rkalimul...
See also https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...

Pushed into 6.0.4-alpha

index_merge_falcon.test is enabled and passes in the current tree.

The test was enabled by this cset:

ChangeSet 1.2577.3.5 2008/03/07 10:43:24 hakank@lu0011.(none)
  After merge cleanup.
mysql-test/suite/falcon/t/disabled.def 1.35.1.3 2008/03/07 10:43:17 hakank@lu0011.(none)
  After merge cleanup.

The result file looks ok. 
Changing status to can't repeat

Im a re-opening this bug report due to seeing this error consistently using the source from mysql-6.0-falcon-team tree (MySQL 6.0.7) when running the Falcon test suite on Solaris 10 on AMD servers.

De-assigning from myself. Something within the falcon tree caused the bug to show up again. I didn't change anything in the falcon tree and also have no idea what others have changed there, so it's logical if Falcon team took a look first. 

Feel free to get me involved once this is narrowed down to some SQL layer issue.

Olav, assigning this to you since you reopened it based on failures on Solaris.  Please verify.

I have verified that this bug is reproducible on a Solaris AMD server running Solaris 10 using the current version of MySQL checked out from the mysql-6.0-falcon tree.

To reproduce it:

1. Configure with the following command:

./configure CC=/opt/studio12/SUNWspro/bin/cc CXX=/opt/studio12/SUNWspro/bin/CC CFLAGS="-Xa -m32 -mt" CXXFLAGS="-m32 -mt" --prefix=/home/os136802/install/mysql6 --with-named-curses=-lcurses --with-mysql-ldflags=-static --with-client-ldflags=-static --with-plugins=myisam,innobase,falcon --enable-dtrace --with-debug

2. compile...

3. Run test:

./mysql-test-run.pl --suite=falcon index_merge_falcon

Note that if I configure for producing 64 bits executables the error does not occur.

This test seems to fail regularly in pushbuild2 on the "Solaris 10 on x86 compiled with gcc" rig on the mysql-6.0-falcon tree.

Test is still failing on every push in Pushbuild 2 on Solaris x86 platforms(Bug#40637 filed as duplicate).