diff options
| author | unknown <igor@rurik.mysql.com> | 2003-12-01 18:47:19 -0800 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2003-12-01 18:47:19 -0800 |
| commit | 7b853c645db94e179be5a4086feb5ccb4088280e (patch) | |
| tree | 31494d26df6b929335d01f1c5d1433017038d9f5 /mysql-test/t/range.test | |
| parent | f6697593d252efc2d4a41897fb503e1598af97ad (diff) | |
| parent | 7daa6cdc1358b0abcf24a28ed6eda57ba3533d23 (diff) | |
| download | mariadb-git-7b853c645db94e179be5a4086feb5ccb4088280e.tar.gz | |
Merge
mysql-test/t/range.test:
Auto merged
sql/item.cc:
Auto merged
sql/item.h:
Auto merged
sql/item_cmpfunc.cc:
Auto merged
sql/item_cmpfunc.h:
Auto merged
sql/item_func.cc:
Auto merged
sql/opt_range.cc:
Auto merged
sql/opt_sum.cc:
Auto merged
sql/sql_list.h:
Auto merged
sql/sql_select.h:
Auto merged
Diffstat (limited to 'mysql-test/t/range.test')
| -rw-r--r-- | mysql-test/t/range.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/range.test b/mysql-test/t/range.test index a1d227459fd..bdbbce5cdfb 100644 --- a/mysql-test/t/range.test +++ b/mysql-test/t/range.test @@ -226,7 +226,18 @@ INSERT INTO t1 VALUES # we expect that optimizer will choose index on A EXPLAIN SELECT * FROM t1 WHERE a IN(1,2) AND b=5; SELECT * FROM t1 WHERE a IN(1,2) AND b=5; +DROP TABLE t1; + +# +# Test error with +# +CREATE TABLE t1 (a int, b int, c int, INDEX (c,a,b)); +INSERT INTO t1 VALUES (1,0,0),(1,0,0),(1,0,0); +INSERT INTO t1 VALUES (0,1,0),(0,1,0),(0,1,0); +# -- First reports 3; second reports 6 +SELECT COUNT(*) FROM t1 WHERE (c=0 and a=1) or (c=0 and b=1); +SELECT COUNT(*) FROM t1 WHERE (c=0 and b=1) or (c=0 and a=1); DROP TABLE t1; # test for a bug with in() and unique key |