Bug #19720 "Information Schema" output does not list privileges when running "embedded"
Submitted: 11 May 2006 11:04 Modified: 22 Jun 2006 16:24
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S2 (Serious)
Version:5.1.10-beta OS:Other (SCO + HP-UX (at least))
Assigned to: Sergei Glukhov CPU Architecture:Any

[11 May 2006 11:04] Joerg Bruehe
Description:
First attempt at a 5.1.10-beta release build.
"Embedded" crashed at start on many platforms (bug#19650),
and only on SCO OR 6 + HP-UX 11.11 it passed tests at all.

Here, we got this error:
-------------------------------------------------------
*** r/join.result
--- r/join.reject
***************
*** 700,707
  select * from information_schema.statistics join information_schema.columns
  using(table_name,column_name) where table_name='user';
  TABLE_NAME    COLUMN_NAME     TABLE_CATALOG   TABLE_SCHEMA    NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDE
X       COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT TABLE_CATALOG   TAB
LE_SCHEMA       ORDINAL_POSITION        COLUMN_DEFAULT  IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHA
RACTER_OCTET_LENGTH     NUMERIC_PRECISION       NUMERIC_SCALE   CHARACTER_SET_NAME      COLLATION_NAME  COLUMN_TYPE     COL
UMN_KEY EXTRA   PRIVILEGES      COLUMN_COMMENT
! user  Host    NULL    mysql   0       mysql   PRIMARY 1       A       NULL    NULL    NULL            BTREE           NUL
L       mysql   1               NO      char    20      60      NULL    NULL    utf8    utf8_bin        char(60)        PRI
                select,insert,update,references
! user  User    NULL    mysql   0       mysql   PRIMARY 2       A       5       NULL    NULL            BTREE           NUL
L       mysql   2               NO      char    5       16      NULL    NULL    utf8    utf8_bin        char(16)        PRI
                select,insert,update,references
  drop table t1;
  drop table t2;
  drop table t3;
--- 700,707
  select * from information_schema.statistics join information_schema.columns
  using(table_name,column_name) where table_name='user';
  TABLE_NAME    COLUMN_NAME     TABLE_CATALOG   TABLE_SCHEMA    NON_UNIQUE      INDEX_SCHEMA    INDEX_NAME      SEQ_IN_INDE
X       COLLATION       CARDINALITY     SUB_PART        PACKED  NULLABLE        INDEX_TYPE      COMMENT TABLE_CATALOG   TAB
LE_SCHEMA       ORDINAL_POSITION        COLUMN_DEFAULT  IS_NULLABLE     DATA_TYPE       CHARACTER_MAXIMUM_LENGTH        CHA
RACTER_OCTET_LENGTH     NUMERIC_PRECISION       NUMERIC_SCALE   CHARACTER_SET_NAME      COLLATION_NAME  COLUMN_TYPE     COL
UMN_KEY EXTRA   PRIVILEGES      COLUMN_COMMENT
! user  Host    NULL    mysql   0       mysql   PRIMARY 1       A       NULL    NULL    NULL            BTREE           NUL
L       mysql   1               NO      char    20      60      NULL    NULL    utf8    utf8_bin        char(60)        PRI

! user  User    NULL    mysql   0       mysql   PRIMARY 2       A       5       NULL    NULL            BTREE           NUL
L       mysql   2               NO      char    5       16      NULL    NULL    utf8    utf8_bin        char(16)        PRI

  drop table t1;
  drop table t2;
  drop table t3;
-------------------------------------------------------
opnsrv6c-5.1-community.log   embedded
hpux11-5.1-community.log   embedded

How to repeat:
Run "embedded" tests.
[29 May 2006 7:36] 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/6952
[13 Jun 2006 13:50] 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/7567
[22 Jun 2006 16:24] Paul DuBois
Changes to test cases only.
No changelog entry needed.