Bug #18745 Test case 'func_group' fails if "classic" 5.0 configuration
Submitted: 3 Apr 2006 15:20 Modified: 22 May 2006 18:27
Reporter: Kent Boortz Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.0.21-pre OS:
Assigned to: Georgi Kodinov CPU Architecture:Any

[3 Apr 2006 15:20] Kent Boortz
Description:
There are several attempts in this test file to make this test run
without InnoDB compiled into the server. This now fails on that
explain gives different output

  *** r/func_group.result       Wed Mar  8 03:51:29 2006
  --- r/func_group.reject       Mon Apr  3 14:13:58 2006
  ***************
  *** 892,899 ****
    NULL
    explain select min(7) from t2i join t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  t2i     ALL     NULL    NULL    NULL    NULL    1
  ! 1   SIMPLE  t1i     ALL     NULL    NULL    NULL    NULL    1
    select min(7) from t2i join t1i;
    min(7)
    NULL
  --- 892,898 ----
    NULL
    explain select min(7) from t2i join t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
    select min(7) from t2i join t1i;
    min(7)
    NULL
  ***************
  *** 908,915 ****
    NULL
    explain select max(7) from t2i join t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  t2i     ALL     NULL    NULL    NULL    NULL    1
  ! 1   SIMPLE  t1i     ALL     NULL    NULL    NULL    NULL    1
    select max(7) from t2i join t1i;
    max(7)
    NULL
  --- 907,913 ----
    NULL
    explain select max(7) from t2i join t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
    select max(7) from t2i join t1i;
    max(7)
    NULL
  ***************
  *** 939,960 ****
    1   NULL
    explain select count(*), min(7), max(7) from t1m, t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  t1m     system  NULL    NULL    NULL    NULL    0       const row not found
  ! 1   SIMPLE  t1i     ALL     NULL    NULL    NULL    NULL    1
    select count(*), min(7), max(7) from t1m, t1i;
    count(*)    min(7)  max(7)
    0   NULL    NULL
    explain select count(*), min(7), max(7) from t1m, t2i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  t1m     system  NULL    NULL    NULL    NULL    0       const row not found
  ! 1   SIMPLE  t2i     ALL     NULL    NULL    NULL    NULL    1
    select count(*), min(7), max(7) from t1m, t2i;
    count(*)    min(7)  max(7)
    0   NULL    NULL
    explain select count(*), min(7), max(7) from t2m, t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  t2m     system  NULL    NULL    NULL    NULL    1
  ! 1   SIMPLE  t1i     ALL     NULL    NULL    NULL    NULL    1
    select count(*), min(7), max(7) from t2m, t1i;
    count(*)    min(7)  max(7)
    0   NULL    NULL
  --- 937,955 ----
    1   NULL
    explain select count(*), min(7), max(7) from t1m, t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
    select count(*), min(7), max(7) from t1m, t1i;
    count(*)    min(7)  max(7)
    0   NULL    NULL
    explain select count(*), min(7), max(7) from t1m, t2i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
    select count(*), min(7), max(7) from t1m, t2i;
    count(*)    min(7)  max(7)
    0   NULL    NULL
    explain select count(*), min(7), max(7) from t2m, t1i;
    id  select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  ! 1   SIMPLE  NULL    NULL    NULL    NULL    NULL    NULL    NULL    Select tables optimized away
    select count(*), min(7), max(7) from t2m, t1i;
    count(*)    min(7)  max(7)
    0   NULL    NULL

How to repeat:
Configure, build and test with 

  ./configure --without-innodb --without-berkeley-db --without-ndbcluster
  make
  cd mysql-test
  ./mysql-test-run.pl --force
[22 May 2006 13:09] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/6700
[22 May 2006 15:27] Georgi Kodinov
pushed in 5.0.22/5.1.11
[22 May 2006 18:27] Paul DuBois
Change to test cases.
No changelog entry needed.