~drizzle-trunk/drizzle/development

Initial mods for making all tests work again. Some tests adapted+added.
List of tests in Makefile now alphabetically sorted, dups removed.

added added

removed removed

insert into t1 values ("a"),("abc"),("abcd"),("hello"),("test");

explain extended select * from t1 where a like 'abc%';

id select_type table type possible_keys key key_len ref rows filtered Extra

1 SIMPLE t1 index a a 13 NULL 5 20.00 Using where; Using index

1 SIMPLE t1 index a a 13 NULL 5 40.00 Using where; Using index

Warnings:

Note 1003 select "test"."t1"."a" AS "a" from "test"."t1" where ("test"."t1"."a" like 'abc%')

Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` like 'abc%')

explain extended select * from t1 where a like concat('abc','%');

id select_type table type possible_keys key key_len ref rows filtered Extra

1 SIMPLE t1 index a a 13 NULL 5 20.00 Using where; Using index

1 SIMPLE t1 index a a 13 NULL 5 40.00 Using where; Using index

Warnings:

Note 1003 select "test"."t1"."a" AS "a" from "test"."t1" where ("test"."t1"."a" like concat('abc','%'))

Note 1003 select `test`.`t1`.`a` AS `a` from `test`.`t1` where (`test`.`t1`.`a` like concat('abc','%'))

select * from t1 where a like "abc%";

abc