aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* Remove some redundant code: Call sqlite3ResolveExprListNames() rather thandrh2015-08-24
| | | | | calling sqlite3ResolveExprNames() in a loop - in two places. FossilOrigin-Name: bdaf66465b6b1bdad10c08d9527b98e7000a41e4
* Fix a couple C99-isms that cause compile errors on MSVC.drh2015-08-20
| | | FossilOrigin-Name: bc577fe6cbbe5385d81d6fa0f3c34bb1c833f0d6
* Fix corner-case memory management issues in table-valued functions. Changedrh2015-08-20
| | | | | | virtual table handling so that if xDestroy is missing the table is eponymous only even if xCreate is present. FossilOrigin-Name: 774e6a14b124bbae4da0e188b62aee9ffb8c3745
* Correctly handle empty function argument lists on table-valued functions.drh2015-08-20
| | | FossilOrigin-Name: a7acc7878b8bb8e27a0da67b2dbb7bd51df4859b
* A list of arguments following a table name translates into equalitydrh2015-08-19
| | | | | constraints against hidden columns in that table. FossilOrigin-Name: 40e12cfe4c29475417ba89fb637b4c763cf74016
* Minor refactor of the SrcList object so that it is able to hold the argumentdrh2015-08-19
| | | | | list to a table-valued-function in the FROM clause. FossilOrigin-Name: b919376147597c4b73421abe5788f893baf1560b
* Test that the left and right sides of a compound SELECT operator have the ↵dan2015-06-23
| | | | | same number of expressions in the expanded expression list before beginning to generate code. FossilOrigin-Name: 4df852ce26c95d5d23c83dbe9c59d2c3435acddf
* CTEs have never add working rowids. So disallow the use of the "rowid" columndrh2015-05-27
| | | | | within CTEs. FossilOrigin-Name: 0055df0445932a43e42b318ef88672dcbe312c3a
* Remove a faulty assert() statement.drh2015-05-07
| | | FossilOrigin-Name: 5f2539da8cb9df99029ab4ab7023804722697673
* Fix a faulty assert() in the "AS" alias resolution logic of the parser.drh2015-04-23
| | | FossilOrigin-Name: b5e43602833249aa4b73337bf85b7f308450dab6
* In the expression-tree comparison routine, do not compiler Expr.iColumndrh2015-04-17
| | | | | and Expr.iTable for TK_STRING expressions. FossilOrigin-Name: b67bb16c72c3e015ea82665ada9b5d3289ef6fb2
* Always resolve symbols in all ORDER BY clauses of a compound-SELECT, evendrh2015-04-17
| | | | | illegal ORDER BY clauses. FossilOrigin-Name: 6c39ef73d5899eabdb46db50c2b00c2d8381a41a
* Fix a faulty assert() statement in the name resolver associated with thedrh2015-04-15
| | | | | | optimization that converts compound selects with ORDER BY COLLATE into subqueries. FossilOrigin-Name: c72324ef9243946550ae3d974826502b1cc5eb10
* Correctly handle COLLATE operators applied to COLLATE operators in andrh2015-04-15
| | | | | ORDER BY clause. FossilOrigin-Name: 9e1f837b08facbc7a2b6196770599a58233e725c
* When doing the (dubious) conversion of double-quoted identifier into stringdrh2015-04-15
| | | | | | literal for MySQL compatibility, be sure to also clear the iTable value from the Expr entry to avoid an assert. FossilOrigin-Name: d7211b68107ea669de39e0aa81a1be40901e1487
* Fix a problem with resolving ORDER BY clauses that feature COLLATE clauses ↵dan2015-04-04
| | | | | attached to compound SELECT statements. FossilOrigin-Name: 427b50fba7362e5b447e79d39050f25ed2ef10af
* Rename the internal "EP_Constant" bitmask to a less misleading "EP_ConstFunc".drh2015-02-09
| | | FossilOrigin-Name: 4ef7ceced2b0000d21f7f8014384c04a0e4661d3
* Fix over-length source code lines in resolver.c. No logic changes.drh2015-02-09
| | | FossilOrigin-Name: c12edb85076d0832e3a0abbbba4d07f3cb5d7f0e
* If a table is the right operand of a LEFT JOIN, then any column of thatdrh2014-12-04
| | | | | | table can be NULL even if that column as a NOT NULL constraint. Fix for ticket [6f2222d550f5b0ee7ed]. FossilOrigin-Name: 6f6fcbe4736b9468a495c684d5eebc8bfe5c566a
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 10:00:19 +0000