Bug #8579 Test case 'index_merge_ror_cpk' fails on s390, irix and Sparc 64

• Submitted: 17 Feb 2005 17:09
• Modified: 22 Feb 2005 15:51
• Reporter: Kent Boortz
• Status: Closed
• Category: MySQL Server
• Severity: S1 (Critical)
• Version: 5.0.3-pre
• OS: s390, irix and Sparc 64
• Assigned to: Sergey Petrunya
• CPU Architecture: Any

[17 Feb 2005 17:09] Kent Boortz

Description:
Test case 'index_merge_ror_cpk' fails on s390, irix and Sparc 64

How to repeat:
Run the test case on the specified targets.

[22 Feb 2005 13:17] Joerg Bruehe

Differences as occurring on Irix, 32 bit;  64 bit looks the same:

-------------------------------------------------------
*** r/index_merge_ror_cpk.result        Tue Feb 22 00:59:21 2005
--- r/index_merge_ror_cpk.reject        Tue Feb 22 03:04:49 2005
***************
*** 59,65 ****
  1     SIMPLE  t1      ref     key1    key1    4       const   100     Using where
  explain select * from t1 where pk1 < 7500 and key1 = 10;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      index_merge     PRIMARY,key1    key1,PRIMARY    4,4     NULL    38      Using intersect(key1,PRIMARY); Using where
  explain select * from t1 where pktail1ok=1 and key1=10;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t1      index_merge     key1,pktail1ok  key1,pktail1ok  4,4     NULL    1       Using intersect(key1,pktail1ok); Using where
--- 59,65 ----
  1     SIMPLE  t1      ref     key1    key1    4       const   100     Using where
  explain select * from t1 where pk1 < 7500 and key1 = 10;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      index_merge     PRIMARY,key1    key1,PRIMARY    4,4     NULL    37      Using intersect(key1,PRIMARY); Using where
  explain select * from t1 where pktail1ok=1 and key1=10;
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t1      index_merge     key1,pktail1ok  key1,pktail1ok  4,4     NULL    1       Using intersect(key1,pktail1ok); Using where
-------------------------------------------------------

[22 Feb 2005 15:51] Sergey Petrunya

Updated the test case.