aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* Increase the resolution of the second parameter to the likelihood() SQLdrh2014-10-25
| | | | | | function (the probability value) so that it can handle probabilities as small as 0.00000001. Formerly, it ran out of precision at 0.001. FossilOrigin-Name: 0f08924fe0c52a85a103f67bee9809e0f8f884b0
* Enhance the automatic index logic so that it creates a partial index whendrh2014-10-24
| | | | | doing so gives the same answer for less work. FossilOrigin-Name: d95d0313c447f5baeabdb17284d8606331ab7d49
* Do not flatten aggregate subqueries that contain min() or max() functionsdrh2014-09-15
| | | | | | | so that if the min()/max() are discarded by the outer query, they still function and cause non-aggregate expression to be evaluated on the minimal or maximal row. FossilOrigin-Name: 0bdf1a086b3946722f4d4b328e25917f61c14713
* Fix typos in comments. No code changes.peter.d.reid2014-09-06
| | | FossilOrigin-Name: e62aab5e9290503869e1f4d5e0fefd2b4dee0a69
* Updates to evidence marks and requirements. No changes to code.drh2014-08-11
| | | FossilOrigin-Name: 62d38308b519a5362f559b296a0cf1acccf8f673
* Update requirements marks. No changes to code.drh2014-08-08
| | | FossilOrigin-Name: 7556bd9aa5db1b9cd92d0e48effcda9fe96f3128
* Add the likely() function for symmetry with unlikely(). The likely(X)drh2014-06-17
| | | | | function means the same thing as likelihood(X,0.9375). FossilOrigin-Name: 38965484199153e3e5b999f5196c1d66e5296f60
* Fix name resolution problem in sub-selects within triggers, ticket [4ef7e3cfca].mistachkin2014-03-04
| | | FossilOrigin-Name: 5bcd0b1ca5d73ffbe7978ee9d73fe5e769e3d3a2
* Make sure "rowid" columns are correctly resolved in joins between normaldrh2014-02-12
| | | | | tables and WITHOUT ROWID tables. Fix for ticket [c34d0557f740c45070]. FossilOrigin-Name: 5d01426ddfb2d47c57f93f71378594e637424be0
* Make sure the update hook is not invoked for WITHOUT ROWID tables, asdrh2013-11-26
| | | | | | | the documentation specifies. This bug was found while adding requirements marks, so a few extraneous requirements marks are included in this check-in. FossilOrigin-Name: 0978bac6b8aee229d7a0d148546f50d380d06a06
* Remove the obsolete TK_CONST_FUNC token type.drh2013-11-21
| | | FossilOrigin-Name: 9b4217f055e9bced186b4c56a5753bd6da7115b5
* Add the ability to factor constant functions out of inner loops. But dodrh2013-11-21
| | | | | not factor out non-constant functions, like random(). FossilOrigin-Name: 1b0f779e19a5c0d51eddd2d88db50034d77d132c
* Changes to make the new constant expression factoring logic more generaldrh2013-11-15
| | | | | and more testable. FossilOrigin-Name: d10fb49a92f5f6e93093ae83544e5aec7984361a
* Fix harmless compiler warnings.drh2013-11-08
| | | FossilOrigin-Name: 0077c0772a884b54d81fa3733aac6f0c364ef1a8
* Report an error when trying to resolve column name "rowid" in adrh2013-10-23
| | | | | WITHOUT ROWID table. FossilOrigin-Name: 36bcc9cb885523fba2f3b0d152de9e08073668c1
* Fix a typo in a requirements mark comment. No changes to code.drh2013-10-16
| | | FossilOrigin-Name: e5a439cfa5c921187e4aa7050832ec2660fba13d
* Additional test cases and requirements marks for the unlikely(),drh2013-10-11
| | | | | likelihood() and instr() functions. FossilOrigin-Name: 5f01cd36ee8678a07b79f9e01855daffb6bb8c43
* Refactor the ExprSetIrreducible() macro into ExprSetVVAProperty(*,EP_NoReduce).drh2013-09-12
| | | | | This is a naming change only. The logic is the same. FossilOrigin-Name: 695aee46e9bdf15159ab52db7f522b30c91aed0f
* Merge in the Expr.flags expansion to 32-bits. Use an extra bit to helpdrh2013-09-12
|\ | | | | | | | | optimize the sqlite3ExprSkipCollate() routine. FossilOrigin-Name: 4c84d1b4c20f18921dd705bf67e8225975b83e86
| * Increase the number of bits available in Expr.flags. Other tweaks aimed atdrh2013-09-12
| | | | | | | | | | making expression processing more robust. FossilOrigin-Name: 579a512538528cf4bb4381ba393c5d9e7310086b
* | Additional unlikely() test cases. Logic tweaks to support test coverage.drh2013-09-11
| | | | | | FossilOrigin-Name: 5d00cce74a7aefaf30022ae971ab1e0451e0ad6e
* | 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-22 16:28:39 +0000