aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* Resolve names in CREATE INDEX WHERE clauses and detect errors. Disallowdrh2013-07-31
| | | | | | | expressions that contain variables, subqueries, or functions. The expression is still not used for anything, however. still unused. FossilOrigin-Name: f2aa7842c8b9df24294f09e2bde27b3f08c455c7
* Treat identifiers in the HAVING clause the same as in the WHERE clause.drh2013-05-16
| | | | | | | | Only consider AS names from the result set to match if there are no other matches. Continuation of the fix for [2500cdb9be05]. This check-in fixes a bug found by [http://www.sqlite.org/sqllogictest/ | SqlLogicTest] during release testing for version 3.7.17. FossilOrigin-Name: 9ffff3d05226bbd01a0745dd0a511776358253c0
* 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
* Only consider AS names from the result set as candidates for resolvingdrh2013-04-13
| | | | | | | identifiers in the WHERE clause if there are no other matches. In the ORDER BY clause, AS names take priority over any column names. Candidate fix for ticket [2500cdb9be]. FossilOrigin-Name: ad53924dcadffb95c6497c46c228c67e8f5370e4
* When comparing names during name resolution, make sure the names matchdrh2013-02-26
| | | | | | exactly and that one name isn't merely a prefix of the other. Fix for ticket [7a31705a7e6c95d51]. FossilOrigin-Name: c2d5a23b1ab39918e97c596cf75c42f86a5fe2b7
* Fix harmless compiler warnings.drh2013-02-07
| | | FossilOrigin-Name: 4a7b4ee011fea911b981206c242e3d5553303b52
* Do not raise an error if an unknown SQL function is found in a CHECKdrh2013-01-08
| | | | | constraint while parsing the schema of an existing database. FossilOrigin-Name: cda790280a52d65f98a45bacb9123367b159ac7c
* Further corner-case fixes to the name resolution logic.drh2013-01-03
| | | FossilOrigin-Name: 20730bad7082b559a65e8cfedb31b6afca50df58
* Remove an incorrect assert() statement (ticket [beba9cae6345a]). Fix otherdrh2013-01-03
| | | | | minor problems in the name resolution logic. FossilOrigin-Name: afe96a118c8a9627819ba5960aa83a607e734087
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 19:13:43 +0000