Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Add a test case for ticket [3557ad65a076c]. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
4f34d7077b9acf7926c5e7375ca870d4 |
User & Date: | drh 2012-03-03 01:44:12.761 |
Context
2012-03-05
| ||
15:33 | Merge the fts4-languageid branch with the trunk. (check-in: 99a9073b5e user: dan tags: trunk) | |
2012-03-03
| ||
01:44 | Add a test case for ticket [3557ad65a076c]. (check-in: 4f34d7077b user: drh tags: trunk) | |
00:34 | Fix a bug [3557ad65a07] that causes incorrect DISTINCT processing on an indexed query involving the IN operator. (check-in: dec9a995d7 user: drh tags: trunk) | |
Changes
Changes to test/select4.test.
︙ | ︙ | |||
801 802 803 804 805 806 807 808 | catchsql { SELECT 1 UNION SELECT 2,3 UNION SELECT 4,5 ORDER BY 1; } db2 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}} } ;# ifcapable compound finish_test | > > > > > > > > > > > > > > > > > > > | 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 | catchsql { SELECT 1 UNION SELECT 2,3 UNION SELECT 4,5 ORDER BY 1; } db2 } {1 {SELECTs to the left and right of UNION do not have the same number of result columns}} } ;# 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 |