From 611e20d8e15d8e5fa6fddbd571ee721d12c222df Mon Sep 17 00:00:00 2001
From: "sergefp@mysql.com" <>
Date: Fri, 30 Jun 2006 09:05:12 +0400
Subject: BUG#16168: Wrong results from range optimizer, "Use_count: Wrong
 count for key ..." warnings:  - Added comments.  - Make SEL_ARG::clone() set
 SEL_ARG::elements in the created copy.

---
 mysql-test/t/range.test | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)

(limited to 'mysql-test/t/range.test')

diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test
index 944cf6ced18..9280911df2c 100644
--- a/mysql-test/t/range.test
+++ b/mysql-test/t/range.test
@@ -484,4 +484,30 @@ SELECT count(*) FROM t1 WHERE CLIENT='000' AND (ARG1 != ' 1' OR ARG1 != ' 2');
 SELECT count(*) FROM t1 WHERE CLIENT='000' AND (ARG1 != ' 2' OR ARG1 != ' 1');
 drop table t1;
 
+# BUG#16168: Wrong range optimizer results, "Use_count: Wrong count ..."
+#            warnings in server stderr.
+create table t1 (a int);
+insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
+
+DROP TABLE IF EXISTS t2;
+CREATE TABLE t2 (
+  pk1 int(11) NOT NULL,
+  pk2 int(11) NOT NULL,
+  pk3 int(11) NOT NULL,
+  pk4 int(11) NOT NULL,
+  filler char(82),
+  PRIMARY KEY (pk1,pk2,pk3,pk4)
+) DEFAULT CHARSET=latin1;
+
+insert into t2 select 1, A.a+10*B.a, 432, 44, 'fillerZ' from t1 A, t1 B;
+INSERT INTO t2 VALUES (2621, 2635, 0, 0,'filler'), (2621, 2635, 1, 0,'filler'),
+  (2621, 2635, 10, 0,'filler'), (2621, 2635, 11, 0,'filler'),
+  (2621, 2635, 14, 0,'filler'), (2621, 2635, 1000015, 0,'filler');
+
+SELECT * FROM t2
+WHERE ((((pk4 =0) AND (pk1 =2621) AND (pk2 =2635)))
+OR ((pk4 =1) AND (((pk1 IN ( 7, 2, 1 ))) OR (pk1 =522)) AND ((pk2 IN ( 0, 2635))))
+) AND (pk3 >=1000000);
+drop table t1, t2;
+
 # End of 4.1 tests
-- 
cgit v1.2.1


From 775ec4fb852e753c2daa1b52a73ebf650789c4ed Mon Sep 17 00:00:00 2001
From: "sergefp@mysql.com" <>
Date: Sat, 1 Jul 2006 09:28:41 +0400
Subject: Post-merge fix

---
 mysql-test/t/range.test | 1 -
 1 file changed, 1 deletion(-)

(limited to 'mysql-test/t/range.test')

diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test
index 13770f962f8..d53b05b98b1 100644
--- a/mysql-test/t/range.test
+++ b/mysql-test/t/range.test
@@ -495,7 +495,6 @@ drop table t1;
 create table t1 (a int);
 insert into t1 values (0),(1),(2),(3),(4),(5),(6),(7),(8),(9);
 
-DROP TABLE IF EXISTS t2;
 CREATE TABLE t2 (
   pk1 int(11) NOT NULL,
   pk2 int(11) NOT NULL,
-- 
cgit v1.2.1