aboutsummaryrefslogtreecommitdiff
path: root/test/in.test
Commit message (Collapse)AuthorAge
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Add a test case for the ALWAYS() macro removed by the previous check-in.drh2023-04-05
| | | FossilOrigin-Name: 68a1a837493a0bc5e0e0f2373ac76cb575078cec08990c017fdcb51a4ba363a1
* Fix the function that determines the collating function for an expressiondrh2023-04-05
| | | | | | | 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]. FossilOrigin-Name: cc5041f3f067cf610adffb868b4e2d1b5d248dc5a0ecc551339b670800ecb0ff
* Remove an assert() statement that is no longer valid due to enhancementsdrh2023-04-04
| | | | | | to query planner for improved use of indexes. [forum:/forumpost/dc16ec63d3 |Forum post dc16ec63d3]. FossilOrigin-Name: 2b23dd249d0bc254308f5539936d33ee558f1100dec616caac7317dbe70db761
* Ignore extra parentheses around a subquery on the RHS of an IN operator,drh2023-02-13
| | | | | because that is what PostgreSQL does. FossilOrigin-Name: ecdeef43b27412b0b0b09e09a62ad3a03836a3fc80f2070268090e7ca8f02712
* Avoid treating constant expressions like "? IN ()" or "? NOT IN ()" as ↵dan2022-05-17
| | | | | integers if they appear in a GROUP BY or ORDER BY clause. FossilOrigin-Name: d8b249e8cdf0babe1427d0587dbdc27a52ec06a5ef3a20dfb05a0ea4adb85858
* Fix test cases so that they all still work even with -DSQLITE_DQS=0.drh2022-01-16
| | | FossilOrigin-Name: 4883776669ee2f2310ea82b0d6df4d008eebaa7cb252102539cf21a635402ebb
* Include the original text of the CHECK constraint in the error message fordrh2020-08-27
| | | | | anonymous CHECK constraints. FossilOrigin-Name: 5ce34a955bb36d77edc9951cb7ac2ef9c876d7d3ff5852af682f558e248f428c
* Correctly handle expressions like "x IS (not) true/false" within the rhs of ↵dan2020-08-24
| | | | | IN() expressions. Fix for [f3ff1472]. FossilOrigin-Name: 493a25949b9a6d0be82169b597133e491d8be4f4147b6eae135b06c1d810abd3
* Reinstate the optimization of converting "a IN (C)" into "a=C" but onlydrh2020-01-28
| | | | | | 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. FossilOrigin-Name: 8ac26a23d7f0ef29c5eb007c7467181f8b96102c8600ea8a5b15cc7584af27bd
* Fix a bug introduced earlier today by check-in [88833a9c2849c959].drh2019-09-02
| | | | | Ticket [29f635e0af71234b] FossilOrigin-Name: 6e7b4527d32cc1be0294614b9d7363d4b59cf654a954b86515b3f6888975ce73
* When applying the IN_INDEX_NOOP optimization and the LHS has REAL affinity,drh2019-09-02
| | | | | | also apply REAL affinity to each element of the RHS. Ticket [2841e99d104c6436]. FossilOrigin-Name: 88833a9c2849c959a37a80e0e4d2b211ce3c83a48319724c89b172b060c876b4
* Add ALWAYS() to an always true conditional that results from thedrh2019-08-27
| | | | | | previous check-in. Add a test case for ticket [dbaf8a6820be1ece] to supplement those already checked into TH3. FossilOrigin-Name: aff209804722ac902c7abfde80ad2677e0f51beb2c7f28f65d51105d984a1640
* Make sure the affinity of the RHS of an IN operator does not affect thedrh2019-06-11
| | | | | | outcome even if the RHS expression contains a COLLATE clause. Ticket [57353f8243c637c0] FossilOrigin-Name: 0f748fe58bbbb7ce3f30303da25ec811b2bbce249549aa9c7927979ac5b38013
* Add further test cases to improve VDBE branch coverage.dan2019-04-04
| | | FossilOrigin-Name: 51a95e52fc58d8be2c9c51576dff7258c705735b66d203948f80db017b4c10d2
* When an IN operator drives a query loop, mark it as "CODED" so that itdrh2019-02-20
| | | | | | | | 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]. FossilOrigin-Name: fa792714ae62fa980f1767acc6d622a6727ceb677870243c88548423795dcb5b
* Remove some 'breakpoint' commands in test files.mistachkin2017-07-19
| | | FossilOrigin-Name: d14fc621e918915bbf8e04597eb238ea78dff3d9c5eb4402cb88692d00dbdfee
* Fix some problems with multi-column IN(SELECT...) processing.dan2016-07-27
|\ | | | | FossilOrigin-Name: 719a3b2035a335ca8b9704646b1d641011e3ea0e
| * Initialize a variable in where.c to avoid a valgrind warning.dan2016-07-27
| | | | | | FossilOrigin-Name: 4d59df02d3713b3e3804e1a88e676749b2794286
* | Fix where.c handling of "IN (SELECT ...)" expressions when the SELECT ↵dan2016-07-26
|/ | | | | returns more than one result column. Also error handling for other row value constructor cases. FossilOrigin-Name: 061b8006034f06a0311b4304c8b14d2c8b0153df
* Test that the left and right sides of a compound SELECT operator have the ↵dan2015-06-23
| | | | | same number of expressions in the expanded expression list before beginning to generate code. FossilOrigin-Name: 4df852ce26c95d5d23c83dbe9c59d2c3435acddf
* Add a test case for what was formerly thought to be an unreachable condition:drh2015-04-15
| | | | | | when the LHS of an OR operator contains an error and the RHS contains an IN operator. FossilOrigin-Name: 3872742591add4e94033484c2844e7d7ab69674b
* Standardize the error messages generated by constraint failures to a formatdrh2013-11-05
| | | | | | of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41
* Do more aggressive optimization of the AND operator where one side or thedrh2012-03-31
| | | | | other is always false. FossilOrigin-Name: f9a7e179cbbeeab5e57bbf392bef89750215546b
* Changes to various test scripts so that veryquick.test runs with ↵dan2012-02-13
| | | | | OMIT_COMPOUND_SELECT defined. FossilOrigin-Name: 76bb649ee2633226324130f5898622c348f93769
* Move the test for an (illegal) scalar sub-query that returns more than one ↵dan2010-09-02
| | | | | column to earlier in SELECT processing in order to avoid an assert() that can happen later on. FossilOrigin-Name: a55842cfb56b659c88832dce9ce7bafb50258211
* Fix (make test) with SQLITE_OMIT_COMPOUND_SELECT. Ticket #3235. (CVS 5530)danielk19772008-08-04
| | | FossilOrigin-Name: 9ca975c8fdeaae7d5af8fe62e097d8d251362cfe
* Fix handling of "x IN (...)" and "x NOT IN (...)" expressions when the set ↵danielk19772008-06-26
| | | | | contains an SQL NULL value. (CVS 5314) FossilOrigin-Name: d45a97be71fa61ab4a692bd807ab762130f7f5b9
* Fix a problem in sqlite3ExprIsInteger() causing failures on select1-4.9.2.drh2008-06-24
| | | | | | 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) FossilOrigin-Name: 95037e6dbf4ed0ffd38790f3270dcaa4c1ae64ed
* Use 1<<$x instead of pow(2,$x) in the test suite code. (CVS 4715)danielk19772008-01-16
| | | FossilOrigin-Name: 3a289b6d28bcf399845586b15f100d7c3a78b550
* Add test cases for errors in "IN(SELECT ...)" expressions where the SELECT ↵danielk19772007-12-13
| | | | | statement is a compound SELECT. No faults found. (CVS 4626) FossilOrigin-Name: 49b67adfe9f15dfac34cb30f965920bf61bceee7
* Additional tests for ticket #1821. (CVS 3189)drh2006-05-23
| | | FossilOrigin-Name: b93e3fb02aeff7fe6cae56c3a45c43ffdb2f030b
* Fix type coercion rules for the IN operator. Ticket #1821. (CVS 3188)drh2006-05-23
| | | FossilOrigin-Name: 6e5a49762166a942e1b2c3beae8a30c07187eb10
* Fix bug with CHECK constraints contain an IN operator. Ticket #1645. (CVS 3035)drh2006-01-30
| | | FossilOrigin-Name: 944df310ce8d32798135c70becee7845676520ae
* Allow the IN operator to take a list of arbitrary expressions on itsdrh2005-07-08
| | | | | | 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) FossilOrigin-Name: ba56478dd8bc2135749966ff55831fd497883781
* Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT ↵danielk19772005-01-21
| | | | | macros) is defined. (CVS 2251) FossilOrigin-Name: bb0254ab14417f0ab40f10f37cb63a60507f070a
* Remove the COPY command. (CVS 1477)drh2004-05-27
| | | FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43
* Allow "<expr> IN <table>" as a shorthand fordrh2004-01-15
| | | | | "<expr> IN (SELECT * FROM <table>)" (CVS 1180) FossilOrigin-Name: 01874d252ac44861e927dea3f5534f67e19b1fa8
* Modify the optimizer so that it does not assume that functions aredrh2003-04-19
| | | | | constant. (CVS 920) FossilOrigin-Name: 767f1af236d115e8388e1dcc28a4df1be48d6c85
* Allow double-quoted strings as string constants in the IN operator. As adrh2003-01-31
| | | | | | side-efffect, allow the GROUP BY clause to refer to columns by their integer column number. Ticket #237. (CVS 856) FossilOrigin-Name: 187d9c405891e543fc706f8ddb41f3966a842214
* In the VDBE, check to make sure a set has been initialized before using it.drh2002-10-30
| | | | | Ticket #185. (CVS 772) FossilOrigin-Name: 8c4cbdd05517e91879a0f2c4559d0f0518d2385b
* Added additional tests. No new errors found. (CVS 653)drh2002-07-01
| | | FossilOrigin-Name: 8924a7f5bab790ab552332d6359028d0d1825e4a
* Bug fix: The IN operator was not working if either side derived fromdrh2002-01-28
| | | | | an INTEGER PRIMARY KEY. (CVS 354) FossilOrigin-Name: dbcfe198fbaa155874ef82a96b6a4b993ccf3931
* Disclaimed copyright. Preparing for release 2.0. (CVS 250)drh2001-09-16
| | | FossilOrigin-Name: 4e926efe2b59adfec4086eb1d2ba830238facb4c
* Added transaction support (CVS 196)drh2001-04-04
| | | FossilOrigin-Name: 35a8feed0d10e780c477f7440fbe80637fcf9906
* :-) (CVS 104)drh2000-06-21
| | | FossilOrigin-Name: e1bf96a467b739373191bf75e6a097fc0f24bffc
* :-) (CVS 74)drh2000-06-07
| | | FossilOrigin-Name: 2ffeb8509c469f5a499d56bb109da079fcdff570
* added IN and BETWEEN operators (CVS 57)drh2000-06-06
FossilOrigin-Name: 54d198189b58366e4e40139102bc6de94ac55e18
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-19 17:02:40 +0000