Bug #35275 INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS omits KEY_BLOCK_SIZE
Submitted: 13 Mar 2008 17:25 Modified: 18 Jun 2010 2:05
Reporter: Marko Mäkelä Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Information schema Severity:S3 (Non-critical)
Version:5.1.23-bk OS:Any
Assigned to: Sergei Glukhov CPU Architecture:Any

[13 Mar 2008 17:25] Marko Mäkelä 
Description:
When the KEY_BLOCK_SIZE attribute is specified in CREATE TABLE or ALTER TABLE, it will be shown in SHOW TABLE STATUS. However, it won't be shown in INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS, although ROW_FORMAT is shown there (in lowercase).

How to repeat:
CREATE TABLE t(a INT) KEY_BLOCK_SIZE=1;
SHOW TABLE STATUS LIKE 't';
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_name='t';

Suggested fix:
Add KEY_BLOCK_SIZE to get_schema_tables_record() in sql/sql_show.cc.
[13 Mar 2008 20:15] Sveta Smirnova 
Thank you for the report.

Could you please provide output of SHOW TABLES STATUS LIKE 't': I don't see KEY_BLOCK_SIZE in mine.
[24 Mar 2008 19:02] Marko Mäkelä 
I could swear that I saw KEY_BLOCK_SIZE in the Create_options of SHOW TABLE STATUS when using a snapshot that was checked out from BitKeeper one to three months ago. However, I can't see it now, neither in mysql-5.1.22-rc-linux-i686-glibc23 nor in a week-old BitKeeper snapshot.

Nevertheless, I would expect any options of CREATE TABLE or ALTER TABLE to show up in Create_options. ROW_FORMAT does show up in the CREATE_OPTIONS column of SHOW TABLE STATUS and INFORMATION_SCHEMA.TABLES, but KEY_BLOCK_SIZE does not show up in either.
[24 Mar 2008 19:28] Sveta Smirnova 
Thank you for the report.

Reclassified to feature request.
[26 Mar 2008 12:25] 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/44446

ChangeSet@1.2572, 2008-03-26 16:14:36+04:00, gluh@mysql.com +3 -0
  Bug#35275 INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS omits KEY_BLOCK_SIZE
  Added KEY_BLOCK_SIZE option to I_S.TABLES.CREATE_OPTIONS field
[27 Nov 2008 16:33] Alexander Barkov 
The patch looks ok to push.

Please check to confirm coding style.
[10 Dec 2008 14:39] 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/61221

2729 Sergey Glukhov	2008-12-10
      Bug#35275 INFORMATION_SCHEMA.TABLES.CREATE_OPTIONS omits KEY_BLOCK_SIZE
      Added KEY_BLOCK_SIZE option to I_S.TABLES.CREATE_OPTIONS field
[15 Jan 2009 6:33] Bugs System 
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:azundris@mysql.com-20081230114838-cn52tu180wcrvh0h) (merge vers: 5.1.31) (pib:6)
[19 Jan 2009 11:27] Bugs System 
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:04] Bugs System 
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 16:10] Bugs System 
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[20 Jan 2009 18:57] Bugs System 
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:azundris@mysql.com-20081230114916-c290n83z25wkt6e4) (merge vers: 6.0.9-alpha) (pib:6)
[29 Jan 2009 5:28] Paul DuBois 
Noted in 5.1.31, 6.0.10 changelogs.

The CREATE_OPTIONS column for INFORMATION_SCHEMA.TABLES did not
display the KEY_BLOCK_SIZE option.
[5 May 2010 15:15] Bugs System 
Pushed into 5.1.47 (revid:joro@sun.com-20100505145753-ivlt4hclbrjy8eye) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[6 May 2010 14:07] Paul DuBois 
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[28 May 2010 5:49] Bugs System 
Pushed into mysql-next-mr (revid:alik@sun.com-20100524190136-egaq7e8zgkwb9aqi) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (pib:16)
[28 May 2010 6:18] Bugs System 
Pushed into 6.0.14-alpha (revid:alik@sun.com-20100524190941-nuudpx60if25wsvx) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[28 May 2010 6:46] Bugs System 
Pushed into 5.5.5-m3 (revid:alik@sun.com-20100524185725-c8k5q7v60i5nix3t) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[30 May 2010 0:21] Paul DuBois 
Push resulted from incorporation of InnoDB tree. No changes pertinent to this bug.
Re-closing.
[17 Jun 2010 11:49] Bugs System 
Pushed into 5.1.47-ndb-7.0.16 (revid:martin.skold@mysql.com-20100617114014-bva0dy24yyd67697) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 12:27] Bugs System 
Pushed into 5.1.47-ndb-6.2.19 (revid:martin.skold@mysql.com-20100617115448-idrbic6gbki37h1c) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)
[17 Jun 2010 13:14] Bugs System 
Pushed into 5.1.47-ndb-6.3.35 (revid:martin.skold@mysql.com-20100617114611-61aqbb52j752y116) (version source revid:vasil.dimov@oracle.com-20100331130613-8ja7n0vh36a80457) (merge vers: 5.1.46) (pib:16)