Bug #40637 falcon.index_merge_falcon test fails on Solaris x86 platforms
Submitted: 11 Nov 2008 14:25 Modified: 11 Nov 2008 14:39
Reporter: John Embretsen Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0-bzr OS:Solaris (x86)
Assigned to: CPU Architecture:Any
Tags: pb2, pushbuild, test failure

[11 Nov 2008 14:25] John Embretsen 
Description:
Query plan is not as expected when running EXPLAIN SELECT queries as part of the falcon.inxex_merge_falcon test, for example:

 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

In this example the join type (and hence also "ref" column) and key used differ from the expected values.

How to repeat:
On a Solaris x86 platform, run:

cd mysql-test/
./mysql-test-run.pl --suite=falcon index_merge_falcon
[11 Nov 2008 14:31] Olav Sandstå 
I think this is a duplicate of bug #32696 index_merge_falcon.test fails.
[11 Nov 2008 14:39] John Embretsen 
Verified as duplicate of Bug#32696 - index_merge_falcon.test fails.

I apologize for the noise (for some reason I did not find 32696 when searching for existing bug reports).