~drizzle-trunk/drizzle/development

First pass for removing mediumint (3 byte INT type).

added added

removed removed

615

id name id idx

616

2 no NULL NULL

617

drop table t1,t2;

618

create table t1 (bug_id mediumint, reporter mediumint);

619

create table t2 (bug_id mediumint, who mediumint, index(who));

618

create table t1 (bug_id bigint, reporter bigint);

619

create table t2 (bug_id bigint, who bigint, index(who));

620

insert into t2 values (1,1),(1,2);

621

insert into t1 values (1,1),(2,1);

622

SELECT * FROM t1 LEFT JOIN t2 ON (t1.bug_id = t2.bug_id AND t2.who = 2) WHERE (t1.reporter = 2 OR t2.who = 2);