Bug #7634 Test failure: 'index_merge': Value of 'rows' differs

• Submitted: 3 Jan 2005 14:29
• Modified: 2 Feb 2005 4:56
• Reporter: Joerg Bruehe
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.3-pre
• OS: Other (QNX)
• Assigned to: Igor Babaev
• CPU Architecture: Any

[3 Jan 2005 14:29] Joerg Bruehe

Description:
On machine 'buildqnx' (and only on this!), test 'index_merge' fails:

-------------------------------------------------------
*** r/index_merge.result        Fri Dec 31 20:00:11 2004
--- r/index_merge.reject        Fri Dec 31 22:20:56 2004
***************
*** 374,381 ****
  where (A.key1 = 1 and A.key2 = 1 and A.key3 = 1 and A.key4=1 and A.key5=1 and A.key6=1 and A.key7 = 1 or A.key8=1)
  and (B.key1 = 1 and B.key2 = 1 and B.key3 = 1 and B.key4=1 and B.key5=1 and B.key6=1 and B.key7 = 1 or B.key8=1);
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  A       index_merge     i1,i2,i3,i4,i5,i6,i7,i8 i2,i3,i4,i5,i6,i8       4,4,4,4,4,4     NULL    16      Using union(intersect(i2,i3,i4,i5,i6),i8); Using where
! 1     SIMPLE  B       index_merge     i1,i2,i3,i4,i5,i6,i7,i8 i2,i3,i4,i5,i6,i8       4,4,4,4,4,4     NULL    16      Using union(intersect(i2,i3,i4,i5,i6),i8); Using where
  select max(A.key1 + B.key1 + A.key2 + B.key2 + A.key3 + B.key3 + A.key4 + B.key4 + A.key5 + B.key5)
  from t0 as A, t0 as B
  where (A.key1 = 1 and A.key2 = 1 and A.key3 = 1 and A.key4=1 and A.key5=1 and A.key6=1 and A.key7 = 1 or A.key8=1)
--- 374,381 ----
  where (A.key1 = 1 and A.key2 = 1 and A.key3 = 1 and A.key4=1 and A.key5=1 and A.key6=1 and A.key7 = 1 or A.key8=1)
  and (B.key1 = 1 and B.key2 = 1 and B.key3 = 1 and B.key4=1 and B.key5=1 and B.key6=1 and B.key7 = 1 or B.key8=1);
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  A       index_merge     i1,i2,i3,i4,i5,i6,i7,i8 i2,i3,i4,i5,i6,i7,i8    4,4,4,4,4,4,4   NULL    7       Using union(intersect(i2,i3,i4,i5,i6,i7),i8); Using where
! 1     SIMPLE  B       index_merge     i1,i2,i3,i4,i5,i6,i7,i8 i2,i3,i4,i5,i6,i7,i8    4,4,4,4,4,4,4   NULL    7       Using union(intersect(i2,i3,i4,i5,i6,i7),i8); Using where
  select max(A.key1 + B.key1 + A.key2 + B.key2 + A.key3 + B.key3 + A.key4 + B.key4 + A.key5 + B.key5)
  from t0 as A, t0 as B
  where (A.key1 = 1 and A.key2 = 1 and A.key3 = 1 and A.key4=1 and A.key5=1 and A.key6=1 and A.key7 = 1 or A.key8=1)
-------------------------------------------------------

This is a pull of Dec 31, latest changeset:
  1.1753 04/12/31 15:14:17 [e-mail] +1 -0
  row0upd.c:
    Manually merge the little InnoDB bug fix from 4.1 to 5.0; Marko can then run tests on the fixed version

How to repeat:
Run the test suite on QNX.

[2 Feb 2005 4:56] Sergey Petrunya

This was caused by platform differences, no problems in the code. Test case adjusted accordingly, see the cset for details.