From 07b1f0dccdf7f58dd79448e293eff85383f450e1 Mon Sep 17 00:00:00 2001 From: "monty@donna.mysql.com" <> Date: Fri, 29 Dec 2000 16:06:10 +0200 Subject: Fixed --no-defaults in mysqltest --- mysql-test/t/key_diff.test | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mysql-test/t/key_diff.test') diff --git a/mysql-test/t/key_diff.test b/mysql-test/t/key_diff.test index d35644ae192..60afb5f81a4 100644 --- a/mysql-test/t/key_diff.test +++ b/mysql-test/t/key_diff.test @@ -14,6 +14,6 @@ INSERT INTO t1 VALUES ('A','B'),('b','A'),('C','c'),('D','E'),('a','a'); select * from t1,t1 as t2; explain select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; #select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B; -select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by t1.a; +select t1.*,t2.* from t1,t1 as t2 where t1.A=t2.B order by binary t1.a,t2.a; select * from t1 where a='a'; drop table t1; -- cgit v1.2.1