~drizzle-trunk/drizzle/development

Fixing more range mismatch

added added

removed removed

1137

DROP TABLE t1;

1138

create table t1 (a int);

1139

insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);

1140

create table t2 (a int, b int, filler char(100));

1140

create table t2 (a int, b int, filler char(100)) ENGINE=myisam;

1141

insert into t2 select A.a + 10 * (B.a + 10 * C.a), 10, 'filler' from t1 A,

1142

t1 B, t1 C where A.a < 5;

1143

insert into t2 select 1000, b, 'filler' from t2;

1147

In following EXPLAIN the access method should be ref, #rows~=500 (and not 2)

1148

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

1149

id select_type table type possible_keys key key_len ref rows Extra

1150

1 SIMPLE t2 ref a a 5 const 499 Using where

1150

1 SIMPLE t2 ref a a 5 const 502 Using where

1151

drop table t1, t2;

1152

End of 5.1 tests

1153

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