aboutsummaryrefslogtreecommitdiff
path: root/src/expr.c
Commit message (Collapse)AuthorAge
...
* 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
* | Modify the OP_Once opcode so that it works correctly in trigger ↵dan2011-12-09
| | | | | | | | | | sub-programs. This is a candidate fix for [7bbfb7d442]. FossilOrigin-Name: 557c69055a300b4082830b5f4803091dca1c3140
* | Cherrypick the [7e5b56b1c6] fix for the sqlite3SelectDup() routine drh2011-12-07
| | | | | | | | | | into trunk. FossilOrigin-Name: 7fc535090ca3416706dff4abce10ac2d7f775e02
| * More compact notation for the parse-tree view.drh2011-12-07
| | | | | | FossilOrigin-Name: 0eb3f8b1e3a196811fb54a5e2645debe6119610a
| * Bug fix in sqlite3SelectDup(). Make sure the pNext pointer is valid.drh2011-12-07
| | | | | | FossilOrigin-Name: 7e5b56b1c602d4adfd4496a9c877f3b685b2d360
| * Improvements to the data-structure explain subsystem. Most queries nowdrh2011-12-07
| | | | | | | | | | give a reasonably detailed graph of their parse tree. FossilOrigin-Name: 0aa7d3d2346bdddcc4e1e25ee26d13c8594885e5
| * Begin adding the data-structure explaining subsystem. All is contained withindrh2011-12-06
|/ | | FossilOrigin-Name: 79ae51c5b1b20ed0a425a87e65a32a096a80b7e1
* Do not reuse temp registers originally allocated to a subroutine withindrh2011-12-06
| | | | | | | the main body of the program logic, since if the subroutine is called while the reused temp registers are in use, their values will get clobbered. Candidate fix for ticket [3a77c9714e63330] FossilOrigin-Name: 092d53315e50be42b51ef7b3069c82c32a129b6a
* Add assert() statements and eliminate needless variable assignments in orderdrh2011-10-14
| | | | | | | to get the clang scan-build utility to report zero problems against the SQLite core. Clang's static analysis did find one real problem - but it was in the command-line shell, not in the SQLite core. FossilOrigin-Name: 60fee9574b0125705787e33c16f116cf188c8323
* Make sure the query optimizer for aggregate queries knows that expressionsdrh2011-10-13
| | | | | (x='a') and (x='A') are different. Ticket [fa7bf5ec94801e7e] FossilOrigin-Name: e43da426e66e6b63d5ed9610a6308aba0089313b
* Fix a problem with SQLITE_OMIT_TRACE that was introduced by the recentdrh2011-09-16
| | | | | OP_Once change. FossilOrigin-Name: 96be3f7b59b3ed4703b907e29db629df34b2b56f
* Add the new OP_Once opcode. Use it to clean up and simplify variousdrh2011-09-16
| | | | | | one-time initialization sections in the code, including the fix for ticket [002caede898ae]. FossilOrigin-Name: 7f00552b739fad79517b042a6ed61abe743a917b
* Materialize subqueries using a subroutine and invoke that subroutinedrh2011-09-15
| | | | | | prior to each use of the subqueries manifestation. Fix for ticket [002caede898aee4] FossilOrigin-Name: 4b8357ee3c4ccdbd34e0cd077efd84cca677f496
* Instead of a temporary b-tree, use a linked-list and merge-sort to sort ↵dan2011-09-02
| | | | | records in main memory in vdbesort.c. FossilOrigin-Name: 7769fb988d9be0f2d8129aaac19620ac88f9b4a6
* Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries.dan2011-07-08
| | | FossilOrigin-Name: 9f14fa56ba31afe3de8b0cf26ed09573a2cc2283
* Avoid unnecessary duplication of SQL parameter names.drh2011-06-01
| | | FossilOrigin-Name: e704e8690ae35decc9769a45cf8d519ccad8b79d
* Refactor the SQL parameter processing so that parameter names for valuesdrh2011-06-01
| | | | | that are optimized out of the prepare statement are not forgotten. FossilOrigin-Name: b3aaf715b60b8a338cc6c92dad1ead4a3f7146a3
* Fix the P4_TRANSIENT constant so that it works correct - so that it reallydrh2011-04-05
| | | | | | makes a copy of the string for the P4 argument. Use P4_TRANSIENT wherever appropriate. Change P4_STATICs of schema names to P4_TRANSIENT. FossilOrigin-Name: bf664b206bf6f5c1941da1986dfe2c0d1831d5e4
* Fix additional cases of possible signed integer overflow, especially withdrh2011-03-08
| | | | | regard to negation. FossilOrigin-Name: 2d5800bd8cfc7d7f5578a71b1aeaa74b2ec4b372
* Fix all known instances of signed-integer overflow. Within SQL expressions,drh2011-03-05
| | | | | | | integer overflow now forces coercion to floating point. The shift operators work with any integer right-hand operand with negative values reversing the direction of the shift. FossilOrigin-Name: abf21394124a0af46f072793718964cee2ce55d0
* Fix an instance of signed arithmetic overflow and an one bit-shift overflow.drh2011-03-05
| | | | | Mark six other signed arithmetic overflow locations that need fixing. FossilOrigin-Name: 04abab71ecd52f6070b9f84781a3df3d6dba7722