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
Triage: Triaged: D3 (Medium)

[25 Nov 2007 11:39] Ingo Strüwing
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...
[28 Nov 2007 10:23] Bugs System
Pushed into 6.0.4-alpha
[12 Jun 2008 17:56] Sergey Petrunya
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
[19 Aug 2008 10:45] Olav Sandstå
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.
[2 Sep 2008 14:09] Sergey Petrunya
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.
[2 Sep 2008 14:19] Kevin Lewis
Olav, assigning this to you since you reopened it based on failures on Solaris.  Please verify.
[3 Sep 2008 8:41] Olav Sandstå
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.
[12 Sep 2008 6:36] Olav Sandstå
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.
[11 Nov 2008 15:03] John Embretsen
Test is still failing on every push in Pushbuild 2 on Solaris x86 platforms(Bug#40637 filed as duplicate).