/ History for test/in.test
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History for test/in.test

2020-01-28
18:09
[ae4ba0fe] part of check-in [8ac26a23] Reinstate the optimization of converting "a IN (C)" into "a=C" but only if C is a constant. If the RHS is a table column, the complications of managing affinity and collations become too involved to mess with. (check-in: [8ac26a23] user: drh branch: trunk, size: 20321)
2019-09-02
22:13
[3e9bd585] part of check-in [6e7b4527] Fix a bug introduced earlier today by check-in [88833a9c2849c959]. Ticket [29f635e0af71234b] (check-in: [6e7b4527] user: drh branch: trunk, size: 20230)
02:21
[47b0666a] part of check-in [88833a9c] When applying the IN_INDEX_NOOP optimization and the LHS has REAL affinity, also apply REAL affinity to each element of the RHS. Ticket [2841e99d104c6436]. (check-in: [88833a9c] user: drh branch: trunk, size: 19912)
2019-08-27
17:28
[1f82966f] part of check-in [aff20980] Add ALWAYS() to an always true conditional that results from the previous check-in. Add a test case for ticket [dbaf8a6820be1ece] to supplement those already checked into TH3. (check-in: [aff20980] user: drh branch: trunk, size: 19346)
2019-06-11
18:07
[63e642e9] part of check-in [0f748fe5] Make sure the affinity of the RHS of an IN operator does not affect the outcome even if the RHS expression contains a COLLATE clause. Ticket [57353f8243c637c0] (check-in: [0f748fe5] user: drh branch: trunk, size: 19110)
2019-04-04
20:55
[4b985774] part of check-in [51a95e52] Add further test cases to improve VDBE branch coverage. (check-in: [51a95e52] user: dan branch: trunk, size: 18783)
2019-02-20
12:52
[63933d7b] part of check-in [fa792714] When an IN operator drives a query loop, mark it as "CODED" so that it will not be used afterwards for a (pointless) membership test. This is a better fix for ticket [df46dfb631f75694] than the previous fix that is now on a branch as it preserves the full optimization of check-in [e130319317e76119]. (check-in: [fa792714] user: drh branch: trunk, size: 18298)
03:38
[474a7f36] part of check-in [b5f90bfe] Back off the optimization of check-in [e130319317e76119] slightly so that it only applies to IN operators that are used for membership tests. Proposed fix for ticket [df46dfb631f75694]. (check-in: [b5f90bfe] user: drh branch: tkt-df46dfb631, size: 17469)
2017-07-19
18:01
[2fa2dfba] part of check-in [d14fc621] Remove some 'breakpoint' commands in test files. (check-in: [d14fc621] user: mistachkin branch: trunk, size: 16068)
2016-07-27
19:33
[20c55299] part of check-in [719a3b20] Fix some problems with multi-column IN(SELECT...) processing. (check-in: [719a3b20] user: dan branch: rowvalue, size: 16079)
16:03
[61d940ce] part of check-in [4d59df02] Initialize a variable in where.c to avoid a valgrind warning. (check-in: [4d59df02] user: dan branch: trunk, size: 16278)
2016-07-26
18:06
[41d18d4b] part of check-in [061b8006] Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT returns more than one result column. Also error handling for other row value constructor cases. (check-in: [061b8006] user: dan branch: rowvalue, size: 15773)
2015-06-23
12:19
[61a24ae3] part of check-in [4df852ce] Test that the left and right sides of a compound SELECT operator have the same number of expressions in the expanded expression list before beginning to generate code. (check-in: [4df852ce] user: dan branch: trunk, size: 15972)
2015-04-15
04:20
[b52fa96b] part of check-in [38727425] Add a test case for what was formerly thought to be an unreachable condition: when the LHS of an OR operator contains an error and the RHS contains an IN operator. (check-in: [38727425] user: drh branch: trunk, size: 15471)
2013-11-05
13:33
[047c4671] part of check-in [54b22192] Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. (check-in: [54b22192] user: drh branch: omit-rowid, size: 15305)
2012-03-31
02:34
[59410964] part of check-in [f9a7e179] Do more aggressive optimization of the AND operator where one side or the other is always false. (check-in: [f9a7e179] user: drh branch: trunk, size: 15295)
2012-02-13
10:00
[a7b8a0f4] part of check-in [76bb649e] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649e] user: dan branch: trunk, size: 15101)
2010-09-02
19:01
[19b642bb] part of check-in [a55842cf] Move the test for an (illegal) scalar sub-query that returns more than one column to earlier in SELECT processing in order to avoid an assert() that can happen later on. (check-in: [a55842cf] user: dan branch: trunk, size: 15057)
2008-08-04
03:51
[d49419c6] part of check-in [9ca975c8] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (check-in: [9ca975c8] user: danielk1977 branch: trunk, size: 14223)
2008-06-26
18:04
[b35fc31c] part of check-in [d45a97be] Fix handling of "x IN (...)" and "x NOT IN (...)" expressions when the set contains an SQL NULL value. (CVS 5314) (check-in: [d45a97be] user: danielk1977 branch: trunk, size: 14200)
2008-06-24
12:46
[ca4ea8ac] part of check-in [95037e6d] Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2. Other bug fixes in compound-merge. The compound-merge is still disabled in this check-in using "#if 0" due to additional bugs. (CVS 5295) (check-in: [95037e6d] user: drh branch: trunk, size: 10707)
2008-01-16
18:20
[763a2900] part of check-in [3a289b6d] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 10698)
2007-12-13
18:24
[87270d14] part of check-in [49b67adf] Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement is a compound SELECT. No faults found. (CVS 4626) (check-in: [49b67adf] user: danielk1977 branch: trunk, size: 10707)
2006-05-23
23:25
[369cb2aa] part of check-in [b93e3fb0] Additional tests for ticket #1821. (CVS 3189) (check-in: [b93e3fb0] user: drh branch: trunk, size: 8807)
23:22
[ff339115] part of check-in [6e5a4976] Fix type coercion rules for the IN operator. Ticket #1821. (CVS 3188) (check-in: [6e5a4976] user: drh branch: trunk, size: 8471)
2006-01-30
14:36
[40feeebc] part of check-in [944df310] Fix bug with CHECK constraints contain an IN operator. Ticket #1645. (CVS 3035) (check-in: [944df310] user: drh branch: trunk, size: 7921)
2005-07-08
18:25
[cead6165] part of check-in [ba56478d] Allow the IN operator to take a list of arbitrary expressions on its right-hand side. The expressions no longer need to be constant. The current implementation seems to work but needs more testing and optimization. (CVS 2542) (check-in: [ba56478d] user: drh branch: trunk, size: 7602)
2005-01-21
03:12
[ed134f8d] part of check-in [bb0254ab] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 7948)
2004-05-27
17:22
[b92a2df9] part of check-in [287f8673] Remove the COPY command. (CVS 1477) (check-in: [287f8673] user: drh branch: trunk, size: 7716)
2004-01-15
03:30
[0de39b02] part of check-in [01874d25] Allow "expr IN table" as a shorthand for "expr IN (SELECT * FROM table)" (CVS 1180) (check-in: [01874d25] user: drh branch: trunk, size: 7764)
2003-04-19
17:27
[22de8a3e] part of check-in [767f1af2] Modify the optimizer so that it does not assume that functions are constant. (CVS 920) (check-in: [767f1af2] user: drh branch: trunk, size: 7270)
2003-01-31
17:16
[3171a2b3] part of check-in [187d9c40] Allow double-quoted strings as string constants in the IN operator. As a side-efffect, allow the GROUP BY clause to refer to columns by their integer column number. Ticket #237. (CVS 856) (check-in: [187d9c40] user: drh branch: trunk, size: 7243)
2002-10-30
22:42
[15428c85] part of check-in [8c4cbdd0] In the VDBE, check to make sure a set has been initialized before using it. Ticket #185. (CVS 772) (check-in: [8c4cbdd0] user: drh branch: trunk, size: 7055)
2002-07-01
00:31
[e59461f1] part of check-in [8924a7f5] Added additional tests. No new errors found. (CVS 653) (check-in: [8924a7f5] user: drh branch: trunk, size: 6396)
2002-01-28
15:53
[c0931267] part of check-in [dbcfe198] Bug fix: The IN operator was not working if either side derived from an INTEGER PRIMARY KEY. (CVS 354) (check-in: [dbcfe198] user: drh branch: trunk, size: 6149)
2001-09-16
00:13
[93236813] part of check-in [4e926efe] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe] user: drh branch: trunk, size: 4657)
2001-04-04
11:48
[ea48016c] part of check-in [35a8feed] Added transaction support (CVS 196) (check-in: [35a8feed] user: drh branch: trunk, size: 5200)
2000-06-21
13:59
[2c560c0f] part of check-in [e1bf96a4] :-) (CVS 104) (check-in: [e1bf96a4] user: drh branch: trunk, size: 5052)
2000-06-07
23:51
[962a605b] part of check-in [2ffeb850] :-) (CVS 74) (check-in: [2ffeb850] user: drh branch: trunk, size: 5051)
2000-06-06
13:54
[17cd46a9] part of check-in [54d19818] added IN and BETWEEN operators (CVS 57) (check-in: [54d19818] user: drh branch: trunk, size: 4498) Added