Bug #34717 PARTITIONS table in information schema crashes server when selected from
Submitted: 21 Feb 2008 8:49 Modified: 25 Apr 2008 11:53
Reporter: Tobias Asplund Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Information schema Severity:S1 (Critical)
Version:5.1.23 OS:Mac OS X
Assigned to: CPU Architecture:Any

[21 Feb 2008 8:49] Tobias Asplund
Description:
IS.PARTITIONS crashes when selected from when partitions are defined on any tables.

How to repeat:
Install world.sql from documentation page.

mysql> ALTER TABLE City PARTITION BY HASH(Id) PARTITIONS 1;
Query OK, 4079 rows affected (0.03 sec)
Records: 4079  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM information_schema.PARTITIONS;
ERROR 2013 (HY000): Lost connection to MySQL server during query
[21 Feb 2008 10:05] Miguel Solorzano
Thank you for the bug report. Could you please try to test with latest
source tree, on Windows I could not repeat otherwise I will ask to
Sveta to test on MAC OS X:

*************************** 62. row ***************************
                TABLE_CATALOG: NULL
                 TABLE_SCHEMA: world
                   TABLE_NAME: countrylanguage
               PARTITION_NAME: NULL
            SUBPARTITION_NAME: NULL
   PARTITION_ORDINAL_POSITION: NULL
SUBPARTITION_ORDINAL_POSITION: NULL
             PARTITION_METHOD: NULL
          SUBPARTITION_METHOD: NULL
         PARTITION_EXPRESSION: NULL
      SUBPARTITION_EXPRESSION: NULL
        PARTITION_DESCRIPTION: NULL
                   TABLE_ROWS: 984
               AVG_ROW_LENGTH: 39
                  DATA_LENGTH: 38376
              MAX_DATA_LENGTH: 10977524091715583
                 INDEX_LENGTH: 23552
                    DATA_FREE: 0
                  CREATE_TIME: 2008-02-21 07:01:19
                  UPDATE_TIME: 2008-02-21 07:01:27
                   CHECK_TIME: NULL
                     CHECKSUM: NULL
            PARTITION_COMMENT:
                    NODEGROUP:
              TABLESPACE_NAME: NULL
62 rows in set (0.14 sec)

mysql>
[22 Mar 2008 0:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[25 Apr 2008 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".