[Commits] Rev 4033: BUG#13731380: RANGE OPTIMIZER CALLS RECORDS_IN_RANGE() FOR OPEN RANGE in file:///home/psergey/dev2/10.0/

Sergey Petrunya psergey at askmonty.org
Fri Mar 7 13:49:49 EET 2014


At file:///home/psergey/dev2/10.0/

------------------------------------------------------------
revno: 4033
revision-id: psergey at askmonty.org-20140307114940-fdrrc83h0ib7kz0r
parent: svoj at mariadb.org-20140306121912-i1p8iilpsgc8m4bn
committer: Sergey Petrunya <psergey at askmonty.org>
branch nick: 10.0
timestamp: Fri 2014-03-07 12:49:40 +0100
message:
  BUG#13731380: RANGE OPTIMIZER CALLS RECORDS_IN_RANGE() FOR OPEN RANGE
  - Backport testcase from mysql-5.6
=== modified file 'mysql-test/r/range.result'
--- a/mysql-test/r/range.result	2014-02-26 14:28:07 +0000
+++ b/mysql-test/r/range.result	2014-03-07 11:49:40 +0000
@@ -2047,6 +2047,17 @@ f1	f2	f3	f4
 DROP TABLE t1;
 DROP VIEW v3;
 #
+# BUG#13731380: RANGE OPTIMIZER CALLS RECORDS_IN_RANGE() FOR OPEN RANGE
+#
+CREATE TABLE t1 (pk INT PRIMARY KEY);
+INSERT INTO t1 VALUES (1),(3),(5);
+SELECT * FROM t1 WHERE pk <> 3 OR pk < 4;
+pk
+1
+3
+5
+DROP TABLE t1;
+#
 #  MDEV-5606: range optimizer: "x < y" is sargable, while "y > x" is not
 #
 create table t1(a int);

=== modified file 'mysql-test/r/range_mrr_icp.result'
--- a/mysql-test/r/range_mrr_icp.result	2014-02-26 14:28:07 +0000
+++ b/mysql-test/r/range_mrr_icp.result	2014-03-07 11:49:40 +0000
@@ -2049,6 +2049,17 @@ f1	f2	f3	f4
 DROP TABLE t1;
 DROP VIEW v3;
 #
+# BUG#13731380: RANGE OPTIMIZER CALLS RECORDS_IN_RANGE() FOR OPEN RANGE
+#
+CREATE TABLE t1 (pk INT PRIMARY KEY);
+INSERT INTO t1 VALUES (1),(3),(5);
+SELECT * FROM t1 WHERE pk <> 3 OR pk < 4;
+pk
+1
+3
+5
+DROP TABLE t1;
+#
 #  MDEV-5606: range optimizer: "x < y" is sargable, while "y > x" is not
 #
 create table t1(a int);

=== modified file 'mysql-test/t/range.test'
--- a/mysql-test/t/range.test	2014-02-26 14:28:07 +0000
+++ b/mysql-test/t/range.test	2014-03-07 11:49:40 +0000
@@ -1640,6 +1640,15 @@ DROP TABLE t1;
 DROP VIEW v3;
 
 --echo #
+--echo # BUG#13731380: RANGE OPTIMIZER CALLS RECORDS_IN_RANGE() FOR OPEN RANGE
+--echo #
+
+CREATE TABLE t1 (pk INT PRIMARY KEY);
+INSERT INTO t1 VALUES (1),(3),(5);
+SELECT * FROM t1 WHERE pk <> 3 OR pk < 4;
+DROP TABLE t1;
+
+--echo #
 --echo #  MDEV-5606: range optimizer: "x < y" is sargable, while "y > x" is not
 --echo #
 create table t1(a int);



More information about the commits mailing list