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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.