~drizzle-trunk/drizzle/development

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

added added

removed removed

404

405

# Test problem with using key_column= constant in ON and WHERE

406

407

create table t1 (bug_id mediumint, reporter mediumint);

408

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

407

create table t1 (bug_id bigint, reporter bigint);

408

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

409

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

410

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

411

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);