Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of test/in.test
|
2019-09-02
| ||
| 22:13 | Fix a bug introduced earlier today by check-in [88833a9c2849c959]. Ticket [29f635e0af71234b] file: [3e9bd585] check-in: [6e7b4527] user: drh branch: trunk, size: 20230 | |
| 02:21 | 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]. file: [47b0666a] check-in: [88833a9c] user: drh branch: trunk, size: 19912 | |
|
2019-08-27
| ||
| 17:28 | 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. file: [1f82966f] check-in: [aff20980] user: drh branch: trunk, size: 19346 | |
|
2019-06-11
| ||
| 18:07 | 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] file: [63e642e9] check-in: [0f748fe5] user: drh branch: trunk, size: 19110 | |
|
2019-04-04
| ||
| 20:55 | Add further test cases to improve VDBE branch coverage. file: [4b985774] check-in: [51a95e52] user: dan branch: trunk, size: 18783 | |
|
2019-02-20
| ||
| 12:52 | 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]. file: [63933d7b] check-in: [fa792714] user: drh branch: trunk, size: 18298 | |
| 03:38 | 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]. file: [474a7f36] check-in: [b5f90bfe] user: drh branch: tkt-df46dfb631, size: 17469 | |
|
2017-07-19
| ||
| 18:01 | Remove some 'breakpoint' commands in test files. file: [2fa2dfba] check-in: [d14fc621] user: mistachkin branch: trunk, size: 16068 | |
|
2016-07-27
| ||
| 19:33 | Fix some problems with multi-column IN(SELECT...) processing. file: [20c55299] check-in: [719a3b20] user: dan branch: rowvalue, size: 16079 | |
| 16:03 | Initialize a variable in where.c to avoid a valgrind warning. file: [61d940ce] check-in: [4d59df02] user: dan branch: trunk, size: 16278 | |
|
2016-07-26
| ||
| 18:06 | 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. file: [41d18d4b] check-in: [061b8006] user: dan branch: rowvalue, size: 15773 | |
|
2015-06-23
| ||
| 12:19 | 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. file: [61a24ae3] check-in: [4df852ce] user: dan branch: trunk, size: 15972 | |
|
2015-04-15
| ||
| 04:20 | 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. file: [b52fa96b] check-in: [38727425] user: drh branch: trunk, size: 15471 | |
|
2013-11-05
| ||
| 13:33 | 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. file: [047c4671] check-in: [54b22192] user: drh branch: omit-rowid, size: 15305 | |
|
2012-03-31
| ||
| 02:34 | Do more aggressive optimization of the AND operator where one side or the other is always false. file: [59410964] check-in: [f9a7e179] user: drh branch: trunk, size: 15295 | |
|
2012-02-13
| ||
| 10:00 | Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. file: [a7b8a0f4] check-in: [76bb649e] user: dan branch: trunk, size: 15101 | |
|
2010-09-02
| ||
| 19:01 | 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. file: [19b642bb] check-in: [a55842cf] user: dan branch: trunk, size: 15057 | |
|
2008-08-04
| ||
| 03:51 | Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) file: [d49419c6] check-in: [9ca975c8] user: danielk1977 branch: trunk, size: 14223 | |
|
2008-06-26
| ||
| 18:04 | Fix handling of "x IN (...)" and "x NOT IN (...)" expressions when the set contains an SQL NULL value. (CVS 5314) file: [b35fc31c] check-in: [d45a97be] user: danielk1977 branch: trunk, size: 14200 | |
|
2008-06-24
| ||
| 12:46 | 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) file: [ca4ea8ac] check-in: [95037e6d] user: drh branch: trunk, size: 10707 | |
|
2008-01-16
| ||
| 18:20 | Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) file: [763a2900] check-in: [3a289b6d] user: danielk1977 branch: trunk, size: 10698 | |
|
2007-12-13
| ||
| 18:24 | Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement is a compound SELECT. No faults found. (CVS 4626) file: [87270d14] check-in: [49b67adf] user: danielk1977 branch: trunk, size: 10707 | |
|
2006-05-23
| ||
| 23:25 | Additional tests for ticket #1821. (CVS 3189) file: [369cb2aa] check-in: [b93e3fb0] user: drh branch: trunk, size: 8807 | |
| 23:22 | Fix type coercion rules for the IN operator. Ticket #1821. (CVS 3188) file: [ff339115] check-in: [6e5a4976] user: drh branch: trunk, size: 8471 | |
|
2006-01-30
| ||
| 14:36 | Fix bug with CHECK constraints contain an IN operator. Ticket #1645. (CVS 3035) file: [40feeebc] check-in: [944df310] user: drh branch: trunk, size: 7921 | |
|
2005-07-08
| ||
| 18:25 | 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) file: [cead6165] check-in: [ba56478d] user: drh branch: trunk, size: 7602 | |
|
2005-01-21
| ||
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) file: [ed134f8d] check-in: [bb0254ab] user: danielk1977 branch: trunk, size: 7948 | |
|
2004-05-27
| ||
| 17:22 | Remove the COPY command. (CVS 1477) file: [b92a2df9] check-in: [287f8673] user: drh branch: trunk, size: 7716 | |
|
2004-01-15
| ||
| 03:30 | Allow "expr IN table" as a shorthand for "expr IN (SELECT * FROM table)" (CVS 1180) file: [0de39b02] check-in: [01874d25] user: drh branch: trunk, size: 7764 | |
|
2003-04-19
| ||
| 17:27 | Modify the optimizer so that it does not assume that functions are constant. (CVS 920) file: [22de8a3e] check-in: [767f1af2] user: drh branch: trunk, size: 7270 | |
|
2003-01-31
| ||
| 17:16 | 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) file: [3171a2b3] check-in: [187d9c40] user: drh branch: trunk, size: 7243 | |
|
2002-10-30
| ||
| 22:42 | In the VDBE, check to make sure a set has been initialized before using it. Ticket #185. (CVS 772) file: [15428c85] check-in: [8c4cbdd0] user: drh branch: trunk, size: 7055 | |
|
2002-07-01
| ||
| 00:31 | Added additional tests. No new errors found. (CVS 653) file: [e59461f1] check-in: [8924a7f5] user: drh branch: trunk, size: 6396 | |
|
2002-01-28
| ||
| 15:53 | Bug fix: The IN operator was not working if either side derived from an INTEGER PRIMARY KEY. (CVS 354) file: [c0931267] check-in: [dbcfe198] user: drh branch: trunk, size: 6149 | |
|
2001-09-16
| ||
| 00:13 | Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [93236813] check-in: [4e926efe] user: drh branch: trunk, size: 4657 | |
|
2001-04-04
| ||
| 11:48 | Added transaction support (CVS 196) file: [ea48016c] check-in: [35a8feed] user: drh branch: trunk, size: 5200 | |
|
2000-06-21
| ||
| 13:59 | :-) (CVS 104) file: [2c560c0f] check-in: [e1bf96a4] user: drh branch: trunk, size: 5052 | |
|
2000-06-07
| ||
| 23:51 | :-) (CVS 74) file: [962a605b] check-in: [2ffeb850] user: drh branch: trunk, size: 5051 | |
|
2000-06-06
| ||
| 13:54 | added IN and BETWEEN operators (CVS 57) file: [17cd46a9] check-in: [54d19818] user: drh branch: trunk, size: 4498 Added | |