diff options
| author | Hans-Christoph Steiner <hans@eds.org> | 2012-09-20 18:34:38 -0400 |
|---|---|---|
| committer | Hans-Christoph Steiner <hans@eds.org> | 2012-09-20 18:34:38 -0400 |
| commit | 487e15dc239ccdb3344d1c99ce120e872bab4a74 (patch) | |
| tree | c986d492f6092ca7b4401d91515f74daed17fae2 /test/select4.test | |
| parent | 7bb481fda9ecb134804b49c2ce77ca28f7eea583 (diff) | |
Imported Upstream version 2.0.6
Diffstat (limited to 'test/select4.test')
| -rw-r--r-- | test/select4.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/test/select4.test b/test/select4.test index dff0b90..e205b37 100644 --- a/test/select4.test +++ b/test/select4.test @@ -805,4 +805,23 @@ do_test select4-12.1 { } ;# ifcapable compound + +# Ticket [3557ad65a076c] - Incorrect DISTINCT processing with an +# indexed query using IN. +# +do_test select4-13.1 { + sqlite3 db test.db + db eval { + CREATE TABLE t13(a,b); + INSERT INTO t13 VALUES(1,1); + INSERT INTO t13 VALUES(2,1); + INSERT INTO t13 VALUES(3,1); + INSERT INTO t13 VALUES(2,2); + INSERT INTO t13 VALUES(3,2); + INSERT INTO t13 VALUES(4,2); + CREATE INDEX t13ab ON t13(a,b); + SELECT DISTINCT b from t13 WHERE a IN (1,2,3); + } +} {1 2} + finish_test |