Comment 3 for bug 924492

The test data consists of tables of similar composition. Each table has the same columns, but they are created in randomized order. They are populated with 0,0,1,1,10,10,100,100 rows each.

CREATE TABLE `CC` (
`col_enum_not_null_key` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') not null,
`col_bigint_not_null` bigint not null,
`col_enum` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
`col_char_10_not_null_key` char(10) not null,
`col_char_255_key` char(255),
`col_char_10` char(10),
`col_text_key` text,
`col_bigint_not_null_key` bigint not null,
`col_text_not_null_key` text not null,
`col_char_255_not_null` char(255) not null,
`col_enum_key` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'),
`col_char_10_not_null` char(10) not null,
`col_int_key` int,
`col_char_255` char(255),
`col_text_not_null` text not null,
`col_char_255_not_null_key` char(255) not null,
`col_bigint_key` bigint,
pk integer auto_increment,
`col_enum_not_null` enum ('a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z') not null,
`col_int_not_null` int not null,
`col_char_10_key` char(10),
`col_bigint` bigint,
`col_int_not_null_key` int not null,
`col_int` int,
`col_text` text,
/*Indices*/
key (`col_enum_not_null_key` ),
key (`col_char_10_not_null_key` ),
key (`col_char_255_key` ),
key (`col_text_key` (255)),
key (`col_bigint_not_null_key` ),
key (`col_text_not_null_key` (255)),
key (`col_enum_key` ),
key (`col_int_key` ),
key (`col_char_255_not_null_key` ),
key (`col_bigint_key` ),
primary key (pk),
key (`col_char_10_key` ),
key (`col_int_not_null_key` )) ;