From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:00:34 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- mysql-test/main/key_diff.test | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 mysql-test/main/key_diff.test (limited to 'mysql-test/main/key_diff.test') diff --git a/mysql-test/main/key_diff.test b/mysql-test/main/key_diff.test new file mode 100644 index 00000000..b490c613 --- /dev/null +++ b/mysql-test/main/key_diff.test @@ -0,0 +1,24 @@ +# +# Check on condition on different length keys. + +--disable_warnings +drop table if exists t1; +--enable_warnings + +CREATE TABLE t1 ( + a char(5) NOT NULL, + b char(4) NOT NULL, + KEY (a), + KEY (b) +); + +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 binary t1.a,t2.a; +select * from t1 where a='a'; +drop table t1; + +# End of 4.1 tests -- cgit v1.2.3