/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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