aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* 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
* 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
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-20 11:19:02 +0000