SQLite

All files named ”test/in.test”
Login

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

History for test/in.test

2025-04-10
10:18
[edf979bff3] part of check-in [20acd630b9] Remove unnecessary "www." prefixes on domain names in URLs. (check-in: [20acd630b9] user: drh branch: trunk, size: 22463)
2023-04-05
02:55
[d1cad4eded] part of check-in [68a1a83749] Add a test case for the ALWAYS() macro removed by the previous check-in. (check-in: [68a1a83749] user: drh branch: trunk, size: 22475)
02:21
[291d881dea] part of check-in [cc5041f3f0] Fix the function that determines the collating function for an expression tree to handle new cases that arise as a result of the recently added ability to use indexed expressions in aggregate queries. [forum/forumpost/0713a16a44|Forum post 0713a16a44]. (check-in: [cc5041f3f0] user: drh branch: trunk, size: 22227)
2023-04-04
18:10
[faf3be786a] part of check-in [2b23dd249d] Remove an assert() statement that is no longer valid due to enhancements to query planner for improved use of indexes. Forum post dc16ec63d3. (check-in: [2b23dd249d] user: drh branch: trunk, size: 21987)
2023-02-13
19:32
[7399a6562f] part of check-in [ecdeef43b2] Ignore extra parentheses around a subquery on the RHS of an IN operator, because that is what PostgreSQL does. (check-in: [ecdeef43b2] user: drh branch: trunk, size: 21462)
2022-05-17
15:01
[55503d3633] part of check-in [d8b249e8cd] Avoid treating constant expressions like "? IN ()" or "? NOT IN ()" as integers if they appear in a GROUP BY or ORDER BY clause. (check-in: [d8b249e8cd] user: dan branch: trunk, size: 20650)
2022-01-16
19:11
[15de58ee01] part of check-in [4883776669] Fix test cases so that they all still work even with -DSQLITE_DQS=0. (check-in: [4883776669] user: drh branch: trunk, size: 20471)
2020-08-27
18:36
[688ed2011d] part of check-in [5ce34a955b] Include the original text of the CHECK constraint in the error message for anonymous CHECK constraints. (check-in: [5ce34a955b] user: drh branch: trunk, size: 20422)
2020-08-24
10:52
[95a704448e] part of check-in [493a25949b] Correctly handle expressions like "x IS (not) true/false" within the rhs of IN() expressions. Fix for [f3ff1472]. (check-in: [493a25949b] user: dan branch: trunk, size: 20406)
2020-07-29
16:18
[d8d43b78bf] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 20323)
2020-01-28
18:09
[ae4ba0fe32] part of check-in [8ac26a23d7] 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: [8ac26a23d7] user: drh branch: trunk, size: 20321)
2019-09-02
22:13
[3e9bd58597] part of check-in [6e7b4527d3] Fix a bug introduced earlier today by check-in [88833a9c2849c959]. Ticket [29f635e0af71234b] (check-in: [6e7b4527d3] user: drh branch: trunk, size: 20230)
02:21
[47b0666a90] part of check-in [88833a9c28] 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: [88833a9c28] user: drh branch: trunk, size: 19912)
2019-08-27
17:28
[1f82966f8c] part of check-in [aff2098047] 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: [aff2098047] user: drh branch: trunk, size: 19346)
2019-06-11
18:07
[63e642e97b] part of check-in [0f748fe58b] 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: [0f748fe58b] user: drh branch: trunk, size: 19110)
2019-04-04
20:55
[4b985774a6] part of check-in [51a95e52fc] Add further test cases to improve VDBE branch coverage. (check-in: [51a95e52fc] user: dan branch: trunk, size: 18783)
2019-02-20
12:52
[63933d7b71] part of check-in [fa792714ae] 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: [fa792714ae] user: drh branch: trunk, size: 18298)
03:38
[474a7f36f7] part of check-in [b5f90bfe62] 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: [b5f90bfe62] user: drh branch: tkt-df46dfb631, size: 17469)
2017-07-19
18:01
[2fa2dfba1a] part of check-in [d14fc621e9] Remove some 'breakpoint' commands in test files. (check-in: [d14fc621e9] user: mistachkin branch: trunk, size: 16068)
2016-07-27
19:33
[20c5529986] part of check-in [719a3b2035] Fix some problems with multi-column IN(SELECT...) processing. (check-in: [719a3b2035] user: dan branch: rowvalue, size: 16079)
16:03
[61d940ced6] part of check-in [4d59df02d3] Initialize a variable in where.c to avoid a valgrind warning. (check-in: [4d59df02d3] user: dan branch: trunk, size: 16278)
2016-07-26
18:06
[41d18d4bcd] part of check-in [061b800603] 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: [061b800603] user: dan branch: rowvalue, size: 15773)
2015-06-23
12:19
[61a24ae38d] part of check-in [4df852ce26] 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: [4df852ce26] user: dan branch: trunk, size: 15972)
2015-04-15
04:20
[b52fa96bcf] part of check-in [3872742591] 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: [3872742591] user: drh branch: trunk, size: 15471)
2013-11-05
13:33
[047c467132] part of check-in [54b2219297] 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: [54b2219297] user: drh branch: omit-rowid, size: 15305)
2012-03-31
02:34
[5941096407] part of check-in [f9a7e179cb] Do more aggressive optimization of the AND operator where one side or the other is always false. (check-in: [f9a7e179cb] user: drh branch: trunk, size: 15295)
2012-02-13
10:00
[a7b8a0f43d] part of check-in [76bb649ee2] Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. (check-in: [76bb649ee2] user: dan branch: trunk, size: 15101)
2010-09-02
19:01
[19b642bb13] part of check-in [a55842cfb5] 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: [a55842cfb5] user: dan branch: trunk, size: 15057)
2008-08-04
03:51
[d49419c6df] part of check-in [9ca975c8fd] Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530) (check-in: [9ca975c8fd] user: danielk1977 branch: trunk, size: 14223)
2008-06-26
18:04
[b35fc31caf] part of check-in [d45a97be71] Fix handling of "x IN (...)" and "x NOT IN (...)" expressions when the set contains an SQL NULL value. (CVS 5314) (check-in: [d45a97be71] user: danielk1977 branch: trunk, size: 14200)
2008-06-24
12:46
[ca4ea8ac10] part of check-in [95037e6dbf] 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: [95037e6dbf] user: drh branch: trunk, size: 10707)
2008-01-16
18:20
[763a29007a] part of check-in [3a289b6d28] Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715) (check-in: [3a289b6d28] user: danielk1977 branch: trunk, size: 10698)
2007-12-13
18:24
[87270d14e2] part of check-in [49b67adfe9] Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT statement is a compound SELECT. No faults found. (CVS 4626) (check-in: [49b67adfe9] user: danielk1977 branch: trunk, size: 10707)
2006-05-23
23:25
[369cb2aa1e] part of check-in [b93e3fb02a] Additional tests for ticket #1821. (CVS 3189) (check-in: [b93e3fb02a] user: drh branch: trunk, size: 8807)
23:22
[ff339115cf] part of check-in [6e5a497621] Fix type coercion rules for the IN operator. Ticket #1821. (CVS 3188) (check-in: [6e5a497621] user: drh branch: trunk, size: 8471)
2006-01-30
14:36
[40feeebc7e] part of check-in [944df310ce] Fix bug with CHECK constraints contain an IN operator. Ticket #1645. (CVS 3035) (check-in: [944df310ce] user: drh branch: trunk, size: 7921)
2005-07-08
18:25
[cead6165ae] part of check-in [ba56478dd8] 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: [ba56478dd8] user: drh branch: trunk, size: 7602)
2005-01-21
03:12
[ed134f8d47] part of check-in [bb0254ab14] Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: [bb0254ab14] user: danielk1977 branch: trunk, size: 7948)
2004-05-27
17:22
[b92a2df916] part of check-in [287f86731c] Remove the COPY command. (CVS 1477) (check-in: [287f86731c] user: drh branch: trunk, size: 7716)
2004-01-15
03:30
[0de39b02ce] part of check-in [01874d252a] Allow "expr IN table" as a shorthand for "expr IN (SELECT * FROM table)" (CVS 1180) (check-in: [01874d252a] user: drh branch: trunk, size: 7764)
2003-04-19
17:27
[22de8a3eb2] part of check-in [767f1af236] Modify the optimizer so that it does not assume that functions are constant. (CVS 920) (check-in: [767f1af236] user: drh branch: trunk, size: 7270)
2003-01-31
17:16
[3171a2b317] part of check-in [187d9c4058] 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: [187d9c4058] user: drh branch: trunk, size: 7243)
2002-10-30
22:42
[15428c85d1] part of check-in [8c4cbdd055] In the VDBE, check to make sure a set has been initialized before using it. Ticket #185. (CVS 772) (check-in: [8c4cbdd055] user: drh branch: trunk, size: 7055)
2002-07-01
00:31
[e59461f170] part of check-in [8924a7f5ba] Added additional tests. No new errors found. (CVS 653) (check-in: [8924a7f5ba] user: drh branch: trunk, size: 6396)
2002-01-28
15:53
[c09312672e] part of check-in [dbcfe198fb] Bug fix: The IN operator was not working if either side derived from an INTEGER PRIMARY KEY. (CVS 354) (check-in: [dbcfe198fb] user: drh branch: trunk, size: 6149)
2001-09-16
00:13
[9323681388] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe2b] user: drh branch: trunk, size: 4657)
2001-04-04
11:48
[ea48016c4f] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 5200)
2000-06-21
13:59
[2c560c0f55] part of check-in [e1bf96a467] :-) (CVS 104) (check-in: [e1bf96a467] user: drh branch: trunk, size: 5052)
2000-06-07
23:51
[962a605b6a] part of check-in [2ffeb8509c] :-) (CVS 74) (check-in: [2ffeb8509c] user: drh branch: trunk, size: 5051)
2000-06-06
13:54
Added: [17cd46a9ca] part of check-in [54d198189b] added IN and BETWEEN operators (CVS 57) (check-in: [54d198189b] user: drh branch: trunk, size: 4498)