aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* | Change the name of the two-argument unlikely() function to likelihood().drh2013-09-11
| | | | | | | | | | Add test cases. FossilOrigin-Name: 29a359b8d7f90e6fa2b28ce2a112284fd3870494
* | Tweaks to the index selection logic.drh2013-09-11
| | | | | | FossilOrigin-Name: 52d52688644f635a50a60ff17b160f3affa8fa6c
* | Continuing refinements of the logic to take WHERE clause terms not used fordrh2013-09-07
| | | | | | | | | | | | indexing into account when computing the number of output rows from each table. FossilOrigin-Name: b65dc53415f42d8402d0ec7f4bedf59d7b39b486
* | Enhance the plan solver to take into account the number of output rows whendrh2013-09-06
| | | | | | | | | | computing the set of paths to retain for the next cycle. FossilOrigin-Name: 1a46a7242313da96420985fa52e1de3f84533e5b
* | Initial implementation of the unlikely() SQL function used as a hint todrh2013-09-06
|/ | | | | the query planner. FossilOrigin-Name: 036fc37a034093a4c6fc190633bd41c2b7230d77
* Make sure that GROUP BY terms select input column names in preference todrh2013-08-15
| | | | | | output column names, in compliance with the SQL standard. Ticket [1c69be2dafc28]. FossilOrigin-Name: f2d175f975cd0be63425424ec322a98fb650019e
* Bare identifiers in ORDER BY clauses bind more tightly to output column name,drh2013-08-15
| | | | | | | but identifiers in expressions bind more tightly to input column names. This is a compromise between SQL92 and SQL99 behavior and is what PostgreSQL and MS-SQL do. Ticket [f617ea3125e9c]. FossilOrigin-Name: c78b357c00a35ed48ce2ffbc041de8d22570d1e2
* Clarification and typo fixes in comments related to name resolution.drh2013-08-15
| | | | | No changes to code. FossilOrigin-Name: f30abdf9d814d6c75bf1c803054737c737ad636f
* Silently ignore database name qualifiers in CHECK constraints and indrh2013-08-02
| | | | | partial index WHERE clauses. FossilOrigin-Name: 2e8c845eb5011a2743dace333aa38383588f2080
* Fill out an initial implementation of the sqlite3ExprImpliesExpr() function.drh2013-08-01
| | | FossilOrigin-Name: 8e07aa2ad5579aeb82174ce5bd432ddb9c058bc1
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-18 04:01:50 +0000