Bug #11162 Execution of prepared "explain select" shows different output

• Submitted: 8 Jun 2005 9:55
• Modified: 15 Jun 2005 10:27
• Reporter: Joerg Bruehe
• Status: Can't repeat
• Category: MySQL Server: Optimizer
• Severity: S3 (Non-critical)
• Version: 5.0.7
• OS: all Unix
• Assigned to: Igor Babaev
• CPU Architecture: Any

[8 Jun 2005 9:55] Joerg Bruehe

Description:
Build of 5.0.7, based on ChangeSet
  1.1940.1.1 05/06/07 08:23:46 [e-mail] +3 -0
  Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0
  into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

Test "ps_6bdb" fails with these differences:
-------------------------------------------------------
*** r/ps_6bdb.result    Tue Jun  7 20:31:20 2005
--- r/ps_6bdb.reject    Wed Jun  8 02:22:30 2005
***************
*** 1152,1164 ****
  Catalog       Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
  def                                   id      8       3       1       N       32929   0       63
  def                                   select_type     253     19      6       N       1       31      8
! def                                   table   253     64      2       N       1       31      8
! def                                   type    253     10      3       N       1       31      8
  def                                   possible_keys   253     4096    0       Y       0       31      8
  def                                   key     253     64      0       Y       0       31      8
  def                                   key_len 253     4096    0       Y       128     31      63
  def                                   ref     253     1024    0       Y       0       31      8
! def                                   rows    8       10      1       N       32929   0       63
  def                                   Extra   253     255     0       N       1       31      8
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t9      ALL     NULL    NULL    NULL    NULL    3
--- 1152,1164 ----
  Catalog       Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flags   Decimals        Charsetnr
  def                                   id      8       3       1       N       32929   0       63
  def                                   select_type     253     19      6       N       1       31      8
! def                                   table   253     64      2       Y       0       31      8
! def                                   type    253     10      3       Y       0       31      8
  def                                   possible_keys   253     4096    0       Y       0       31      8
  def                                   key     253     64      0       Y       0       31      8
  def                                   key_len 253     4096    0       Y       128     31      63
  def                                   ref     253     1024    0       Y       0       31      8
! def                                   rows    8       10      1       Y       32928   0       63
  def                                   Extra   253     255     0       N       1       31      8
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t9      ALL     NULL    NULL    NULL    NULL    3
-------------------------------------------------------

Happens in a "max" build in both the default and '--ps-protocol' tests on
- bsd53
- cane
- cane-linuxthreads
- hpux11
- hpux11-64bit
- intelxeon3
- sol10-sparc-a
- sol10-sparc-a-64bit
- sol10-x86
- sol9x86
- sunfire100b
- sunfire100b-64bit

How to repeat:
Run the test suite.

[8 Jun 2005 10:04] Joerg Bruehe

On the platforms not listed above, the test was skipped.

[8 Jun 2005 10:31] Joerg Bruehe

This here shows up in "ps_7ndb", and IMO it is the same thing:

-------------------------------------------------------
*** r/ps_7ndb.result    Tue Jun  7 20:31:20 2005
--- r/ps_7ndb.reject    Wed Jun  8 03:02:53 2005
***************
... ((see bug#11163))
***************
*** 1149,1161 ****
  Catalog       Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flag
s   Decimals        Charsetnr
  def                                   id      8       3       1       N       32929   0       63
  def                                   select_type     253     19      6       N       1       31      8
! def                                   table   253     64      2       N       1       31      8
! def                                   type    253     10      3       N       1       31      8
  def                                   possible_keys   253     4096    0       Y       0       31      8
  def                                   key     253     64      0       Y       0       31      8
  def                                   key_len 253     4096    0       Y       128     31      63
  def                                   ref     253     1024    0       Y       0       31      8
! def                                   rows    8       10      1       N       32929   0       63
  def                                   Extra   253     255     0       N       1       31      8
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t9      ALL     NULL    NULL    NULL    NULL    2
--- 1152,1164 ----
  Catalog       Database        Table   Table_alias     Column  Column_alias    Type    Length  Max length      Is_null Flag
s   Decimals        Charsetnr
  def                                   id      8       3       1       N       32929   0       63
  def                                   select_type     253     19      6       N       1       31      8
! def                                   table   253     64      2       Y       0       31      8
! def                                   type    253     10      3       Y       0       31      8
  def                                   possible_keys   253     4096    0       Y       0       31      8
  def                                   key     253     64      0       Y       0       31      8
  def                                   key_len 253     4096    0       Y       128     31      63
  def                                   ref     253     1024    0       Y       0       31      8
! def                                   rows    8       10      1       Y       32928   0       63
  def                                   Extra   253     255     0       N       1       31      8
  id    select_type     table   type    possible_keys   key     key_len ref     rows    Extra
  1     SIMPLE  t9      ALL     NULL    NULL    NULL    NULL    2
-------------------------------------------------------

[15 Jun 2005 10:27] Igor Babaev

Cannot repeat with the current 5.0.8 tree. Apparently it was fixed before.