Random Query Generator

Support misc CREATE TABLE options

Registered by John H. Embretsen

The Gendata part of the Random Query Generator currently supports setting certain CREATE TABLE options in .zz files, as specified at http://forge.mysql.com/wiki/RandomDataGenerator. In order to support testing of other options (features, work-arounds, etc.), test authors need to be able to specify other options as well, such as ROW_FORMAT or KEY_BLOCK_SIZE, etc.

Blueprint information

Status:
Not started
Approver:
None
Priority:
Medium
Drafter:
None
Direction:
Needs approval
Assignee:
None
Definition:
New
Series goal:
None
Implementation:
Unknown
Milestone target:
None

Related branches

Sprints

Whiteboard

John said 2010-02-03:

Example of current support in .zz files for certain CREATE TABLE options:

$tables = {
        rows => [0, 1, 10, 100],
        partitions => [ undef , 'KEY (pk) PARTITIONS 2' ],
        engines => ['Falcon', 'Innodb', 'Maria' ],
};

In order to work around an InnoDB limitation I currently need to be able to specify ROW_FORMAT=DYNAMIC as in:

    CREATE TABLE t1 (
      `col_blob` blob,
      `col_blob_key` blob,
      pk integer auto_increment,
      key (`col_blob_key` (255)),
      primary key (pk)) ROW_FORMAT=DYNAMIC ENGINE=innodb;

So, support for something like

     row_format => [ DYNAMIC ]

would be nice.

However, it might be better to have some sort of generic solution for all kinds of other options as well.
Options supported by "MySQL 5.5" are documented here: http://dev.mysql.com/doc/refman/5.5/en/create-table.html

-------------------------------------------

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.