aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* Now supports result sets of the form "TABLE.*" with nested FROM clauses.drh2013-01-03
| | | FossilOrigin-Name: 4cf5ed7ea198abc32f8118e79490e77f847f08c1
* Better resolution of table and column names in joins where some of thedrh2012-12-19
| | | | | terms of the FROM clause are parenthesized. FossilOrigin-Name: 7344e791b9456286ecdca6d45f2f5260fb3f10e2
* Resolve names in FROM-clause subqueries prior to resolving names in thedrh2012-12-18
| | | | | result set expressions of a SELECT statement. FossilOrigin-Name: 9b67c633d932f3e566f521ee6a9cf3be193436fa
* Improved error messages when column integers in an ORDER BY clause are drh2012-12-07
| | | | | out of range. FossilOrigin-Name: bd960d937f8d6521c8ec4b7bd8a77a498dd432d4
* Fix a long-standing issue with the distinct-as-aggregate optimization thatdrh2012-12-07
| | | | | only expressed when the new collating-sequence logic is turned on. FossilOrigin-Name: 0aaf52a339808386984c30cca0c0c35ac2e70e7e
* Fix the processing of ORDER BY clauses with COLLATE terms on compounddrh2012-12-07
| | | | | queries. 52 veryquick test failures remain. FossilOrigin-Name: 49654453ad157693414c1f86fa3afa0918acffd4
* 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
* Attempt to suppress warnings generated by Coverity.drh2012-10-09
| | | FossilOrigin-Name: 7b1a6e6cb5099076bf19db142b17c99044a869cd
* 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
* Convert the NameContext object from using u8 booleans to using individualdrh2012-05-21
| | | | | | bits in a single u8 as its booleans. This change might become a basis for a fix for [c2ad16f997ee9c]. FossilOrigin-Name: 722260969306778029b738402f22e3c154dd77a1
* Enhance the processing of ORDER BY clauses on compound queries to betterdrh2012-04-27
| | | | | | match terms of the order by against expressions in the result set, in order to enable better query optimization. FossilOrigin-Name: a49e909c8738317c8383ce93771c0a9c4cf270bc
* Fix the application-defined function logic so that functions with a variabledrh2012-04-07
| | | | | | number of parameters can be replaced or deleted correctly. Also refactor some of the function-finder code for clarity of presentation. FossilOrigin-Name: 09d5581c81fb6a9bf6a369d0abf5ef6b54637576
* Minor cleanups of the compound-subquery flattening logic. New test casesdrh2011-12-10
| | | | | added for joins the compound subquery. FossilOrigin-Name: 5061d85ff934db3c217c97acbbbed3286d9e02aa
* Improved handling of USING and NATURAL JOIN in 3-way and higher joins.drh2011-10-18
| | | | | Ticket [3338b3fa19ac4ab] FossilOrigin-Name: 551ce407bd77149865423511bd52eba2f404161a
* Fix for [54844eea3f]: Do not create automatic indexes on correlated sub-queries.dan2011-07-08
| | | FossilOrigin-Name: 9f14fa56ba31afe3de8b0cf26ed09573a2cc2283
* Currently, if SQLite cannot find a table or index referred to by a query, it ↵dan2010-06-28
| | | | | reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.). FossilOrigin-Name: 4932f22848b3d15a2b6dc5fa2cd69ce19182e2a4
* Fix a typo in a comment. No changes to code.drh2010-04-08
| | | FossilOrigin-Name: 332cb55113a621456c6522830585434146c388e7
* New test cases for automatic indices. New testcase() macros associateddrh2010-04-08
| | | | | with column-used bitmasks. FossilOrigin-Name: e1aa48ace7e43c3805278120b8228ee597e2cee7
* Log all error messages if logging is enabled.drh2010-02-22
| | | FossilOrigin-Name: a8076aede33c07e9a2aaa05be8a888f37b45e41c
* Fix the expression comparison logic to take the COLLATE operator into account.drh2010-01-07
| | | | | Ticket [360c6073e197] FossilOrigin-Name: 44bb1bfe5dedd8054ddd933941ee4112ed8d3b68
* Add evidence marks associated with autoincrement.drh2010-01-01
| | | FossilOrigin-Name: 0e918c54893c361fb005295847f89aadcbfae35d
* Within the special new.* and old.* tables of a trigger, recognize all thedrh2009-12-29
| | | | | | original table names even if those names overload the "rowid", "oid", or "_rowid_" special names. Ticket [34d2ae1c6d0]. FossilOrigin-Name: 1a0e5fa9f0ff792c678c99d49960601a0cef925b
* Move [7d30880114] to the trunk. Add optimizations to reduce the number of ↵dan2009-11-27
| | | | | opcodes used for BEFORE UPDATE triggers. FossilOrigin-Name: 1b7c5250ccb63182324bfc3f1ea28f17b6db357a
* Change so that deleting an Expr structure requires only one frame per level ↵dan2009-11-23
| | | | | in the expression tree, not two. FossilOrigin-Name: a4380ab326e4b0de29271c824d041193e86b7139
* Remove the obsolete "$Id:$" RCS identifier strings from the source code.drh2009-11-10
| | | FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
* Create a new datatype "ynVar" to hold "nVar" (number of variable) values.drh2009-11-04
| | | | | | This is normally 16-bits can can be 32-bits if SQLITE_MAX_VARIABLE_NUMBER is large enough. FossilOrigin-Name: 24a4d520d540d92b611abc4eb57dc6da9be4eac6
* Fix compiler warnings on MSVC build.shane2009-11-03
| | | FossilOrigin-Name: 01c4b5b84ec7ce589e20ea66e80011f092ab32f0
* When generating WHERE clause terms internally for NATURAL and USING joins, ↵dan2009-10-19
| | | | | identify the table by its position in the FROM list, not by its name or alias. Fix for [b73fb0bd64]. FossilOrigin-Name: 6fe6371175482d38ac4aeea994c7b20c18b7de01
* Warning cleanup from the MSVC compile.shane2009-09-07
| | | FossilOrigin-Name: 26cd015c0ee1c18dd37f11b47ce35cfa320b3514
* More fixes and comment updates.dan2009-09-01
| | | FossilOrigin-Name: 38a9327bad1a01e3d7a47fad44ece2f6c7e88643
* More fixes for test cases.dan2009-08-31
| | | FossilOrigin-Name: 85d9f23be1e8673dbda42e43b9b23332ada9225f
* Fix some authorization callback problems.dan2009-08-31
| | | FossilOrigin-Name: 8a746fbfd51f70f56e25ade59df49d2dc03c131c
* Changes to support recursive triggers.dan2009-08-28
| | | FossilOrigin-Name: 9b9c19211593d5ff7b39254a29c284560a8bcedb
* Additional updates to the symbol resolver and expression tree walker todrh2009-06-15
| | | | | facilitate test coverage. (CVS 6764) FossilOrigin-Name: a49c2d4befcc33dd98543fe7b4d4f0bae56f1a90
* Updates to resolve.c to facilitate full coverage testing. (CVS 6762)drh2009-06-15
| | | FossilOrigin-Name: c50f0f28df1dfdccf1d159c983b616cd9b823955
* Fix compiler warnings with MSVC build. (CVS 6699)shane2009-06-01
| | | FossilOrigin-Name: 0791588520603d106aa0b8ce24d68b740b7b80c8
* Refinements in expression handling logic that have resulted from recentdrh2009-05-29
| | | | | structural testing. (CVS 6690) FossilOrigin-Name: bd89f2c29b00e6b473f30c2e929d2f626721ad92
* Fix a NULL pointer dereference following an OOM error in the column namedrh2009-05-28
| | | | | resolver. (CVS 6685) FossilOrigin-Name: 3b46142532934d17aa136c2e56e58e7828df0f54
* Make sure the column name resolver does not try to duplicate Expr.u.zTokendrh2009-05-28
| | | | | when the Expr.u.iValue union member is the element being used. (CVS 6684) FossilOrigin-Name: 376ecf0d87e4a2329f5861401f83ed9ceb35d528
* Additional refinements to Expr handling. Restore compression of triggerdrh2009-05-28
| | | | | | expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) FossilOrigin-Name: 4ac2bdfbb4230b6ceaae87e738fa61036bbe03cb
* Simplifications to the Expr object: Remove Expr.span completely and convertdrh2009-05-27
| | | | | | Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) FossilOrigin-Name: 7cb1c3ba0759539cb035978fdaff6316775986f3
* Make sure the left-shift operator never overflows. (CVS 6605)drh2009-05-05
| | | FossilOrigin-Name: 300da30178c46ab9f2ceb0c3e3ee3eac73d5d8e1
* Record within the Token structure itself whether or not the token hasdrh2009-05-01
| | | | | | been dequoted. This steals one bit from the length of a token and thus limits the size of tokens to 1GiB. (CVS 6589) FossilOrigin-Name: 12bcb03d9b9e1a31c1a3c67cbb4263cc0af2f3d0
* Added some asserts and a check for a null pointer dereference. (CVS 6337)shane2009-03-05
| | | FossilOrigin-Name: 6b0cabd017ed25530b2d918d2c069fcbdd60a3f6
* Fix a bug in the GROUP BY alias name resolution. The bug was bydrh2009-03-02
| | | | | | check-in (6305). Discovered by regression test on 64-bit linux. Test cases added so that the problems is detected on 32-bit systems. (CVS 6332) FossilOrigin-Name: fa0008502ec4f891bfed4a11f01650d274f95c44
* Reverse commit (6315) for now. (CVS 6317)danielk19772009-02-24
| | | FossilOrigin-Name: 0e7c369c23a8767b4d3e5cdd47c14716992fb71a
* Scan an index instead of a table for "SELECT count(*) FROM <tbl>" queries. ↵danielk19772009-02-23
| | | | | Because an index is usually smaller than a table on disk, this saves some IO. (CVS 6315) FossilOrigin-Name: 294ba6f743c9132dce0e73da480bd3c2071e7239