~drizzle-trunk/drizzle/development

Merge Brian

added added

removed removed

create index idx_t1_2 on t1 (a1,a2,b);

analyze table t1;

Table Op Msg_type Msg_text

test.t1 analyze status Table is already up to date

test.t1 analyze note The storage engine for the table doesn't support analyze

drop table if exists t2;

create TEMPORARY table t2 (

a1 char(64), a2 char(64) not null, b char(16), c char(16), d char(16), dummy char(64) default ' '

create index idx_t2_2 on t2 (a1,a2,b);

analyze table t2;

Table Op Msg_type Msg_text

test.t2 analyze status Table is already up to date

test.t2 analyze note The storage engine for the table doesn't support analyze

drop table if exists t3;

create TEMPORARY table t3 (

a1 char(1), a2 char(1), b char(1), c char(4) not null, d char(3), dummy char(1) default ' '

130

create index idx_t3_2 on t3 (a1,a2,b);

131

analyze table t3;

132

Table Op Msg_type Msg_text

133

test.t3 analyze status Table is already up to date

133

test.t3 analyze note The storage engine for the table doesn't support analyze

134

explain select a1, min(a2) from t1 group by a1;

135

id select_type table type possible_keys key key_len ref rows Extra

136

1 SIMPLE t1 range NULL idx_t1_1 518 NULL 5 Using index for group-by