~drizzle-trunk/drizzle/development

Merge Brian

added added

removed removed

1125

insert into t2e select * from t2;

1126

analyze table t2e;

1127

Table Op Msg_type Msg_text

1128

test.t2e analyze status OK

1128

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

1129

explain select * from t2e where a=1000 and b<11;

1130

id select_type table type possible_keys key key_len ref rows Extra

1131

1 SIMPLE t2e ref a a 5 const 502 Using where

1131

1 SIMPLE t2e ref a a 5 const 11 Using where

1132

drop table t1, t2;

1133

End of 5.1 tests

1134

CREATE TABLE t1 (c1 DECIMAL(10,0),INDEX(c1));