MySQL Bugs: #7264: Test failure: 'func

Bug #7264	Test failure: 'func_group'
Submitted:	14 Dec 2004 12:54	Modified:	31 Dec 2004 10:16
Reporter:	Joerg Bruehe	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0.3-pre	OS:	Linux (Linux / Athlon, x86)
Assigned to:	Sergey Petrunya	CPU Architecture:	Any

Description:
Test 'func_group' fails for me in current 5.0,
both in runs without and with '--ps-protocol'.

Failure report:
-------------------------------------------------------
*** r/func_group.result 2004-12-09 16:27:37.000000000 +0300
--- r/func_group.reject 2004-12-14 12:21:36.000000000 +0300
***************
*** 578,584 ****
  explain
  select min(a1) from t1 where a1 != 'KKK';
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      index   PRIMARY PRIMARY 3       NULL    14      Using where; Using index
  explain
  select max(a3) from t1 where a2 < 2 and a3 < 'SEA';
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
--- 578,584 ----
  explain
  select min(a1) from t1 where a1 != 'KKK';
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
! 1     SIMPLE  t1      range   PRIMARY PRIMARY 3       NULL    14      Using where; Using index
  explain
  select max(a3) from t1 where a2 < 2 and a3 < 'SEA';
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
-------------------------------------------------------

Latest changeset on my PC:
ChangeSet@1.1738, 2004-12-14 13:41:32+03:00, gluh@gluh.mysql.r18.ru
  Fix for bug #7223: information_schema: error in "views"

How to repeat:
Run the test suite.

Couldn't repeat with
* today's tree (ChangeSet@1.1754, 2004-12-17 12:19:31+03:00, dlenev@brandersnatch.localdomain)
compiled with compile-pentium and compile-pentium-debug, 
* tree rolled back to the mentioned cset compiled with compile-pentium-debug.
Joerg, can you repeat with todays tree? what compile settings should be used?

This bug seems to be similar with Bug #7251, which I cannot repeat either. 
Tried on powermacg5:
  func_group test passes, myisam test (from Bug #7251) fails. Really can't repeat.

I pulled today, re-built, and re-tried. For 'func_group' in default mode, the same differences still occur for me, the only change is the timestamp of the "reject" file.
(With '--ps-protocol', nothing works - this should be a separate issue.)

My last changesets according to "bk revtool":
=== cut ===
ChangeSet@1.1738, 2004-12-21 07:49:38+02:00, jan@hundin.mysql.fi
  Content merge.

ChangeSet@1.1732.1.41, 2004-12-21 02:28:12+03:00, sergefp@mysql.com
  Merge spetrunia@bk-internal.mysql.com:/home/bk/mysql-5.0
  into mysql.com:/dbdata/psergey/mysql-5.0-nov-clean

ChangeSet@1.1732.1.40, 2004-12-21 01:59:58+03:00, sergefp@mysql.com
  Fix for BUG#4480: In joins with SELECT_STRAIGHT_JOIN re-order tables by outer join dependency, 
  so we read dependent tables after tables they depend on (this is needed for outer joins)
=== cut ===

My machine has an Athlon CPU, it runs a Linux 2.4 kernel (SuSE 8.2) and gcc 3.3:
gcc (GCC) 3.3 20030226 (prerelease) (SuSE Linux)

Again, I did a standard "BUILD/compile-pentium-max", resulting in these options:
=== cut ===
running /bin/sh ./configure  --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --with-readline --with-innodb --with-berkeley-db --with-embedded-server --enable-thread-safe-client --with-openssl --with-vio --with-raid --with-ndbcluster --enable-local-infile CFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -g CXXFLAGS=-Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -g CXX=gcc CFLAGS=-O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Wunused -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -g   CXXFLAGS=-O3 -DDBUG_OFF -Wimplicit -Wreturn-type -Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wformat -Wparentheses -Wsign-compare -Wwrite-strings -Woverloaded-virtual -Wsign-promo -Wreorder -Wctor-dtor-privacy -Wnon-virtual-dtor -felide-constructors -fno-exceptions -fno-rtti -mcpu=pentiumpro -O3 -fno-omit-frame-pointer -g   -fno-implicit-templates -fno-exceptions -fno-rtti -DUSE_MYSYS_NEW -DDEFINE_CXA_PURE_VIRTUAL  --no-create --no-recursion
=== cut ===

Ok I could repeat with mentioned tree and compiler settings