aboutsummaryrefslogtreecommitdiff
path: root/src/expr.c
Commit message (Collapse)AuthorAge
...
* Fill out an initial implementation of the sqlite3ExprImpliesExpr() function.drh2013-08-01
| | | FossilOrigin-Name: 8e07aa2ad5579aeb82174ce5bd432ddb9c058bc1
* Add the logic to keep partial indices up to date through DML statements anddrh2013-08-01
| | | | | | when new partial indices are created. This new logic is untested except to verify that it does not interfere with full indices. FossilOrigin-Name: fb9044d15ad4fd6ae4a38858c0c0e6fe9d4faa25
* Add logic to the query planner to only use partial indices if the WHERE clausedrh2013-07-31
| | | | | | | constrains the search to rows covered by the partial index. This is just infrastructure. The key routine, sqlite3ExprImpliesExpr(), is currently a no-op so that partial indices will never be used. FossilOrigin-Name: 8ca3eac111e06a1854f878a74bffe8f20eb47f1b
* Fix an uninitialized variable detected by valgrind. Unclear whether or notdrh2013-06-26
| | | | | this should apply to trunk. FossilOrigin-Name: 19ab4811d542ba781aeb6a4eb3c74642677225e1
* Adjustments to testcase() macros for improved testability.drh2013-06-18
| | | FossilOrigin-Name: 4fbb0c4d26c54aaefbe5397cde2a0b9d2ce3885f
* Fix the Parse.nQueryLoop state variable to work with NGQP.drh2013-06-11
| | | FossilOrigin-Name: f1cac24f06b9c71cfa472fdcf2da4cd8689a7cc3
* Many small harmless comment changes. Removal of obsolete comments anddrh2013-05-28
| | | | | fixing misspelled words. No changes to code. FossilOrigin-Name: a0d5cc9315dc6e9ef7dee4c3dfabf4e562d64376
* The sqlite3ExprCollSeq() function can no longer be called while parsedrh2013-05-15
| | | | | | the schema, so remove the code path inside of sqlite3ExprCollSeq() that dealt with that case. FossilOrigin-Name: 867b3e3b29a357f68e48f0898bf323c5dd0575a4
* Make sure the affinity and datatype of sub-subqueries are initializeddrh2013-04-25
| | | | | prior to subqueries as the latter relies on the former. FossilOrigin-Name: 39b4e6ff9316cc78ea88349091e195b8104d1e9e
* Many spelling fixes in comments. No changes to code.mistachkin2013-03-21
| | | FossilOrigin-Name: 6f6e2d50941e444ebc83604daddcc034137a05b7
* Fix the ORDER BY optimization with IN constraints when the RHS of thedrh2013-03-12
| | | | | IN constraint is a descending index. FossilOrigin-Name: 62316ebaca933f7e5df2018e8360a2b74234f30a
* Always use strncmp() rather than memcmp() when comparing strings where onedrh2013-03-01
| | | | | | | or other string might be less than the length parameter, since optimized versions of memcmp() might read past the first difference and in so doing generate an access violation. FossilOrigin-Name: d73435587ba7459e2e2c32980d0e17abdeceb4bc
* Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the drh2013-02-09
| | | | | | extended constraint error codes in alphabetical order. Add many test cases for the extended constraint error codes. FossilOrigin-Name: 3f67437536591a1b0742a25b983707933aaa16d5
* Add extended error codes for constraint errors.drh2013-02-09
| | | FossilOrigin-Name: 5461104668a49529577f21df97f6a0e7d8f0c679
* Now supports result sets of the form "TABLE.*" with nested FROM clauses.drh2013-01-03
| | | FossilOrigin-Name: 4cf5ed7ea198abc32f8118e79490e77f847f08c1
* Adjustments to the collating-sequence refactoring to facilitate full-coveragedrh2012-12-08
| | | | | testing and to fix some minor issues found by TH3. FossilOrigin-Name: cdbfa664839a409589ec7cebfc9111235d2f3b38
* Veryquick passes all tests now.drh2012-12-08
| | | FossilOrigin-Name: 7b96115e81deab0aa0472839cf787ba3f2fc64a7
* Recognize TK_COLLATE operators that have been transformed into TK_REGISTER.drh2012-12-08
| | | | | | Skip both TK_COLLATE and TK_AS operators when looking for the top of an expression. FossilOrigin-Name: f66c1db2965054f38125218202b6a6ec62d57666
* Do not report missing collating functions while parsing the schema.drh2012-12-07
| | | | | Also remove a stray comment. FossilOrigin-Name: e313edca0472f07e9b872b92120d80b4bc177328
* Many more tests are passing. Only about 100 failures remain in veryquick.drh2012-12-07
| | | FossilOrigin-Name: f9fa7581c0371fe0feb4e97487741ade18595810
* Some errors in veryquick resolved. Many more to go.drh2012-12-07
| | | FossilOrigin-Name: 972443b4eb282d45507da06c75e2cd46dd72326b
* Veryquick now row to completion without segfaulting or asserting. But theredrh2012-12-07
| | | | | are still lots of errors. FossilOrigin-Name: 7fafab12e4c0c832c421975f8329c3214403d281
* Remove the Expr.pColl field and compute the collating sequence as it is needed.drh2012-12-06
| | | | | | This fixes the test script "shared9.test", though there is still a memory leak. And there are other problems. Consider this a work-in-progress. FossilOrigin-Name: fd011cb22f2d899d94ec7ce22641d7a8f5e19972
* Proposed fix for ticket [bfbf38e5e9].drh2012-11-02
| | | FossilOrigin-Name: 18ae030dad30303129186738c27cdc4ba06362b9
* Fix an out-of-date comment. No changes to code.drh2012-11-02
| | | FossilOrigin-Name: 10cc12b16b2f1ae4e6b3a84cef5a44564d282e9c
* Add an optimization that attempts to run a subquery as a coroutine ratherdrh2012-10-30
| | | | | than manifesting it into a temporary table. FossilOrigin-Name: 7af3acbbd49a2114fcdada9ec907c68ba9b053bd
* Shared-cache mode fixes for views and virtual tables.dan2012-10-04
| | | FossilOrigin-Name: 2b370dea704b59262c604af0efcef5660b194454
* Add more bits to the bit vector that is used to disable optimizations fordrh2012-09-27
| | | | | | | built-in test. Add specific bit patterns to disable ORDER BY using an index in general and for joins. Use macros to test for bits in the disabled-optimization bit vector, in order to make the code clearer. FossilOrigin-Name: d2fcba1e143beca8c45724d2108870657c269e17
* Consolidate more of the DISTINCT processing logic into a single spot in thedrh2012-09-21
| | | | | | code. Reduce the number of OP_Column operations needed to perform a WHERE_DISTINCT_ORDERED. FossilOrigin-Name: 79e922f7ae29bbe06d639d648fbd72523cf9a28e
* Enhance IN processing to allow efficient use of indices with numeric affinities.drh2012-09-18
| | | | | | Add test cases for IN processing that would have spotted the error in the [2be661a48023f4] check-in. FossilOrigin-Name: 5ded9b68388f4024425c11f09b03529ac89454ce
* Enhancements to the comments on sqlite3FindInIndex(). No code changes.drh2012-09-18
| | | FossilOrigin-Name: b1a4c394995eb90b3fb43ab204704bda03799303
* Make sure the KeyInfo.aSortOrder array is always allocated so that we neverdrh2012-09-17
| | | | | have to test for KeyInfo.aSortOrder==0 in performance-critical loops. FossilOrigin-Name: 45793f0b844fee7445bc9269b403f89a58f77150
* Merge the nested aggregate query enhancements into trunk.drh2012-08-24
|\ | | | | FossilOrigin-Name: d4cd6017c9875947a05b1dc36538d4272fb18739
| * Add test cases and fix bugs associated with the previous check-indrh2012-08-23
| | | | | | | | | | enhancements to nested aggregate subquery processing. FossilOrigin-Name: 00b1dc71be4c3420730b5f7840af824ea86165e7
| * Further improvements to the processing of nested aggregate queries.drh2012-08-23
|/ | | FossilOrigin-Name: 3c3ffa901f5ce8a523028ff15563ce3e0f55a641
* Refactor field names in the SelectDest object to make them distinct and easierdrh2012-07-23
| | | | | to grep for. FossilOrigin-Name: b589f1efb3907a68058bf2ee981dca126d083e83
* Mark and always-true conditional as such. Add the fuzz-oss1.test test module.drh2012-05-21
| | | FossilOrigin-Name: bdc01fd0fa0c15efbb32bf18527c71e3e4dc48ed
* Candidate fix for the nested aggregate query problem of ticketdrh2012-05-21
| | | | | [c2ad16f997ee9c8e]. FossilOrigin-Name: f3dd1fafd4718558de1f06139419a8c560d727f5
* Fix harmless compiler warnings (unused parameter warnings) in the aggregatedrh2012-04-19
| | | | | query analyzer. FossilOrigin-Name: 2d43562084316ec180a4c2cfc3fee08d58432204
* Improved handling of aggregate subqueries within an aggregate query.drh2012-04-17
| | | FossilOrigin-Name: 430bb59d798286a86c351de92c429345f016b3f0
* Do more aggressive optimization of the AND operator where one side or thedrh2012-03-31
| | | | | other is always false. FossilOrigin-Name: f9a7e179cbbeeab5e57bbf392bef89750215546b
* Fix compiler warnings on GCC and MSVC and fix a C89-ism thatdrh2012-03-30
| | | | | broke the build for MSVC. FossilOrigin-Name: b451c0f97f0abe78ebe6c62ff489ec1ad8a1f767
* Fix the typeof() and length() optimization so that it works for aggregatesdrh2012-03-28
| | | | | as well as scalar queries. FossilOrigin-Name: bc18215a8a660442db6ddeeda4a88df0acffe0f7
* Evaluate typeof(X) and length(Y) where X is any column and Y is a blob columndrh2012-03-28
| | | | | without actually loading X and Y from disk. FossilOrigin-Name: b899dbeb60752843287e2c6ad3577e1d00f0d587
* Simplified array allocation in the IdList and AggInfo objects.drh2012-02-02
| | | FossilOrigin-Name: 25df2a7458d025bc00380b4a0893637639f9f0d4
* Remove the nAlloc field from the ExprList object.drh2012-02-02
| | | FossilOrigin-Name: 5963de303a9106b446a9423aa838bfdf6bc1e7f3
* Minor cleanups of the compound-subquery flattening logic. New test casesdrh2011-12-10
| | | | | added for joins the compound subquery. FossilOrigin-Name: 5061d85ff934db3c217c97acbbbed3286d9e02aa
* Import the experimental parse-tree explainer, with fixes, from thedrh2011-12-10
|\ | | | | | | | | tree-explain branch. FossilOrigin-Name: bcbc7152d49107afa926c8950360c61a6cf3d244
| * Merge the latest trunk changes into tree-explain branch.drh2011-12-10
| |\ | |/ |/| FossilOrigin-Name: 1a360da0f8314f232c224c71829646bc7558892b
* | Make no assumptions about the initial state of VDBE registers.drh2011-12-09
| | | | | | FossilOrigin-Name: 521d72bdf67b4b1972331307345a18c231a6e1d6