diff options
author | Michael Widenius <monty@askmonty.org> | 2012-02-21 01:58:50 +0200 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2012-02-21 01:58:50 +0200 |
commit | 15c5a2686f6367d5a280813ad96ef86bd0ee0fc0 (patch) | |
tree | a1e008c4e92b63efa9cea54ed5ab837fa2b7e229 /mysql-test/r/range.result | |
parent | 84a3767c1912c34e79cde72a51e4cf69d235587e (diff) | |
parent | 522b289607ce10ff3e44fdf8035ae1c29bffe4f4 (diff) | |
download | mariadb-git-15c5a2686f6367d5a280813ad96ef86bd0ee0fc0.tar.gz |
Merge with MariaDB 5.2
Diffstat (limited to 'mysql-test/r/range.result')
-rw-r--r-- | mysql-test/r/range.result | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index 09da355be1c..32dfaf417c0 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -1769,6 +1769,21 @@ SELECT * FROM t1, t1 as t2 WHERE t1.i4 BETWEEN t2.pk AND t2.pk; pk i4 pk i4 DROP TABLE t1; End of 5.1 tests +# +# LP Bug #533117: Wrong use_count in SEL_ARG trees +# (Bug #58731) +# +create table t1 (a int, b int, c int, key idx (a,b,c)); +insert into t1 values (0,0,0), (2,2,0), (1,1,1), (2,2,1); +explain +select * from t1 force index (idx) where a >=1 and c <= 1 and a=b and b > 1; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range idx idx 5 NULL 3 Using where; Using index +select * from t1 force index (idx) where a >=1 and c <= 1 and a=b and b > 1; +a b c +2 2 0 +2 2 1 +drop table t1; create table t1 (f1 datetime, key (f1)); insert into t1 values ('2000-03-09 15:56:59'),('2000-05-05 23:24:28'),('2000-06-13 13:12:06'); select min(f1) from t1 where f1 >= '2006-05-25 07:00:20' and f1 between '2003-11-23 10:00:09' and '2010-01-01 01:01:01' and f1 > '2001-01-01 01:01:01'; |