~drizzle-trunk/drizzle/development

fix select_found test for innodb (and other engines) by adding order by (so that result set is same as myisam)

added added

removed removed

`kid` int NOT NULL default '0',

PRIMARY KEY (`id`),

KEY `kid` (`kid`)

) engine=myisam;

);

CREATE TABLE t2 (

id int NOT NULL auto_increment,

name varchar(50) NOT NULL default '',

email varchar(50) NOT NULL default '',

PRIMARY KEY (id),

UNIQUE KEY e_n (email,name)

) engine=myisam;

EXPLAIN SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1 ON kid = t2.id WHERE t1.id IS NULL LIMIT 10;

);

EXPLAIN SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1 ON kid = t2.id WHERE t1.id IS NULL ORDER BY t2.email LIMIT 10;

id select_type table type possible_keys key key_len ref rows Extra

1 SIMPLE t1 system PRIMARY,kid NULL NULL NULL 0 const row not found

1 SIMPLE t2 index NULL e_n 404 NULL 10

SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1 ON kid = t2.id WHERE t1.id IS NULL LIMIT 10;

1 SIMPLE t2 index NULL PRIMARY 4 NULL 200 Using temporary; Using filesort

1 SIMPLE t1 ref kid kid 4 test.t2.id 1 Using where; Using index; Not exists; Distinct

SELECT SQL_CALC_FOUND_ROWS DISTINCT email FROM t2 LEFT JOIN t1 ON kid = t2.id WHERE t1.id IS NULL ORDER BY t2.email LIMIT 10;

email1

email10