diff options
| author | unknown <monty@mysql.com> | 2003-11-28 15:45:34 +0200 |
|---|---|---|
| committer | unknown <monty@mysql.com> | 2003-11-28 15:45:34 +0200 |
| commit | e5cc604eabf843f25fad2e8e91c4360416b72471 (patch) | |
| tree | 403c144e6d9ba62c5422206d587a381c17c7dee9 /mysql-test/r/range.result | |
| parent | e56d603a098f8082785329249af73209eb52b8fb (diff) | |
| download | mariadb-git-e5cc604eabf843f25fad2e8e91c4360416b72471.tar.gz | |
Fixed range optimzier bug (Bug #1828)
mysql-test/r/range.result:
test for range optimzier bug
mysql-test/t/range.test:
test for range optimzier bug
Diffstat (limited to 'mysql-test/r/range.result')
| -rw-r--r-- | mysql-test/r/range.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/range.result b/mysql-test/r/range.result index 68987009598..e87df9a6c24 100644 --- a/mysql-test/r/range.result +++ b/mysql-test/r/range.result @@ -290,3 +290,13 @@ t1 range a,b a 5 NULL 2 Using where SELECT * FROM t1 WHERE a IN(1,2) AND b=5; a b DROP TABLE t1; +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); +SELECT COUNT(*) FROM t1 WHERE (c=0 and a=1) or (c=0 and b=1); +COUNT(*) +6 +SELECT COUNT(*) FROM t1 WHERE (c=0 and b=1) or (c=0 and a=1); +COUNT(*) +6 +DROP TABLE t1; |