aboutsummaryrefslogtreecommitdiff
path: root/src/resolve.c
Commit message (Collapse)AuthorAge
...
* Fix incorrect column-usage accounting associated with generated columnsdrh2019-12-08
| | | | | and added by check-in [6601da58032d18ae]. Fix for ticket [b92e5e8ec2cdbaa1]. FossilOrigin-Name: 9d75e1ccc72e9f536f45df3b24e9ecd25076cc1f7cf16b806b19e0e1b68e8326
* Fix a harmless compiler warning.drh2019-11-22
| | | FossilOrigin-Name: 34343c4b0657767f2676a2a9feb670cf000824e3eadfb1a6d87b57404191d8f9
* Whenever a generated column is used, assume that all columns are used.drh2019-11-21
| | | FossilOrigin-Name: 6601da58032d18ae00b466c0f2077fb2b1ecd84225b56e1787724bea478eedc9
* Always disallow the use of non-deterministic functions in CHECK constraints,drh2019-10-30
| | | | | | | even date/time functions that use the 'now' or similar keywords. Provide improved error messages when this requirement is not met. Ticket [830277d9db6c3ba1] FossilOrigin-Name: 2978b65ebe25eeabe543b67cb266308cceb20082a4ae71565d6d083d7c08bc9f
* Minor adjustments for clarity and test coverage.drh2019-10-23
| | | FossilOrigin-Name: 30065716878d4058e75eb510b0b27b68e5193d04625eb173210de8061f20f499
* Initial experimental code for generated column support. Non-functional.drh2019-10-16
| | | FossilOrigin-Name: 11d472c1df707b8d03ec57d8fc582a34f5eb89a9d02a154a9871650c65065b45
* Test for an OOM condition in resolveAlias().drh2019-09-26
| | | FossilOrigin-Name: 322eca7f6ad2234059669015aabb773a790e8bc3da95431c9c851ff5342c969b
* Fix a window-functions problem that could occur if an ORDER BY clause ↵dan2019-09-26
| | | | | contains an alias for a window-function that is not a top-level expression. FossilOrigin-Name: 1cc6cf6407c6e25aeafeca379a93d0ad2614839c07fb3644e46926fce5f1cfab
* Fix the likely(), unlikely(), and likelihood() functions so that they havedrh2019-08-22
| | | | | | no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] FossilOrigin-Name: 44578865fa7baf9760e355691ca9ce753295aaba7a4ee0bba29d4f85d9335bab
* Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibitsdrh2019-08-15
| | | | | the use of those functions within triggers or views. FossilOrigin-Name: fc745845d8d76adc165575e2192f4176e3c28e614c72571d56f4011560499fe1
* Ensure that SQLite does not attempt to process incompatible window functions ↵dan2019-08-15
| | | | | in a single scan. Fix for [256741a1]. FossilOrigin-Name: 4f5b2d938194fab7627486e2ced633def2c90d9d3328e3700612feb9dbfa3d9a
* Fix harmless compiler warnings.drh2019-08-08
| | | FossilOrigin-Name: 1eef4ddea9a2a8c97b97183402c774caa40ef906ea9cccade307381b29a9785d
* Fix a case of the Expr.affinity to Expr.affExpr refactor that was misseddrh2019-08-08
| | | | | in the [a29f2a7d07beff64] check-in. FossilOrigin-Name: 83450d10707e2c7c075f3930a8c231c49c593b9cdf0e6097b0187eb877755d2d
* Refactor field Expr.affinity into Expr.affExpr to avoid confusion with otherdrh2019-08-05
| | | | | | fields and variables named "affinity" and display affExpr it in sqlite3TreeViewExpr() output. FossilOrigin-Name: a29f2a7d07beff64e489e8f824babc6228c4a499fadc0ee701caa60a63baadcd
* Fix a problem with renaming a table when a view or trigger within the schema ↵dan2019-08-05
| | | | | uses a FILTER with an aggregate function that is not currently registered with the database. FossilOrigin-Name: 2ac0e42f8ab7a9184c2a2efd13bd50ab51bc01f9f34e9e63591fd18db02dff54
* Fix a problem in ALTER TABLE triggered by views or triggers that include the ↵dan2019-08-01
| | | | | construction "ORDER BY true" or "ORDER BY false". FossilOrigin-Name: 8168021f9ab5fb8b4888257963c9ec68fd1dfeedaf6bba4b8e07438001d0be0f
* Consolidate the removal of Window objects from the Select.pWin list intodrh2019-07-22
| | | | | a single subroutine. FossilOrigin-Name: e46b2afc99329c43de08d4a2e6ade4d2239d7409c5d5626bf272a3e0dd24d1b4
* Remove Window objects from the corresponding Select.pWin list when they are ↵dan2019-07-22
|\ | | | | | | | | deleted, as they are, for example, when the ORDER BY clause is optimized out. FossilOrigin-Name: fd7316cda0fdfe86985f41a97dff3beba188606ec9bc6fef38a686a6976a6e01
| * Remove Window objects from the corresponding Select.pWin list when they are ↵dan2019-07-22
| | | | | | | | | | deleted. FossilOrigin-Name: d23f33168222dfa40a67dc7de58057418151989e81429e4af47617e86db04667
| * Make sure any window definitions in an ORDER BY clause are removed fromdrh2019-07-20
| | | | | | | | | | the SELECT statement if the ORDER BY clause gets optimized out. FossilOrigin-Name: 23b119671f0be3c6b72cf2dc5f7707a0626766db7aa56529ab00d33d1a0a1bee
* | Fix a problem with renaming tables when the schema contains an invocation of ↵dan2019-07-22
|/ | | | | a currently unregistered aggregate with a FILTER clause. FossilOrigin-Name: bd37ce3fb8dee8d538f6afc0bfc13cdc3ebdd504e6461f0130c6ecc8af585f68
* Fix a problem with renaming a table when the schema contains an invocation ↵dan2019-07-19
| | | | | of a window function that is not currently registered. FossilOrigin-Name: ff290feb97f689cf6ce4162d6aa36f9f9dcf1bff3096847d53a85f39f728d2de
* Fix error handling for the case where a window function is passed the wrong ↵dan2019-07-13
| | | | | number of arguments. FossilOrigin-Name: 871796bb19e61c1282d8ac97a82d8b57bde50f2a2a08004ab53136d77c138df4
* Rework the FILTER clause implementation to share more code with window ↵dan2019-07-13
| | | | | functions. FossilOrigin-Name: 5dac8c38dfc3f41c5c8fb49ca35de7fd1b21f269d72e8ba6ba59ed0a4030a54d
* Minor performance improvement in sqlite3ExprDeleteNN().dan2019-07-10
| | | FossilOrigin-Name: bcc8b38ac75b731a4cd2873ab83f423be036467a511b617c779869de9bbb5383
* Add tests for the FILTER clause. And a bugfix.dan2019-07-03
| | | FossilOrigin-Name: 28aa1702f7f0334abd1b30e7aa48ea3679539b11bfbba32bc9f0d6049cf18a7b
* Experimental implementation of FILTER clause for aggregate functions.dan2019-07-02
| | | FossilOrigin-Name: 1f1ae2d6ac8dcbb62e5aa3dc17bc67d559cb565fc0d0a8c00a596075d35f8130
* Improved interface to double-quoted string literal enabling/disabling.drh2019-06-17
| | | FossilOrigin-Name: 923cfd53fcff2fcb91530bf819d2ecb0eda3f6a27dae29c7460f9ce3a3ffce7b
* Add SQLITE_DBCONFIG options LEGACY_ALTER_TABLE, NO_DQS_SCHEMA, and NO_DQS.drh2019-06-14
| | | FossilOrigin-Name: 1fad20925efa70d0c242e9cba8fa55456fb07a81229c1068da84c6e27d0c0be8
* Handle expressions like "expr IS TRUE COLLATE xyz" in the same way as "expr ↵dan2019-06-12
| | | | | IS TRUE". Fix for [4d01eda8115b10d1]. FossilOrigin-Name: 5c6146b56a75a94f4baa10e95407c54dd0b9314a57a8702a4b96b15c4d7ac48c
* The affinity of the unlikely() function and its cousins should be "none".drh2019-06-11
| | | | | Ticket [0c620df60bffd9ef] FossilOrigin-Name: 614ecb0af47038848e8ba2aed6b92db6f33ddc4aea6361795dbde440380f5a35
* A minor variation on check-in [1685610ef8e0dc] which (hopefully) makes thedrh2019-05-20
| | | | | | | | logic a little easier to follow. Also disallows the use of the double-quoted string hack in the query expression used for VACUUM INTO, which is not strictly required, but moves us toward the goal of disallowing the double-quoted string hack everywhere. FossilOrigin-Name: 3e1b55f3ab85710ed81574904718205c7370b5f0b5a41029e961486d2e3f37c7
* Disallow string constants enclosed in double-quotes within new CREATE TABLE ↵dan2019-05-20
| | | | | and CREATE INDEX statements. It is still possible to enclose column names in double-quotes, and existing database schemas that use double-quotes for strings can still be loaded. This addresses ticket [9b78184b]. FossilOrigin-Name: 1685610ef8e0dc9218b02461ceab14dc6114f4f5ef7fcda0da395094aff443e1
* Fix a stack overflow that could occur when renaming a table that has a ↵dan2019-04-29
| | | | | trigger containing a window function invocation that itself contains a specific syntax error. FossilOrigin-Name: c621fc668c6538f9f5bdac204f012c64998679a61aa8e224d212503820224c09
* Recover a some of the performance lost by window function alias fix twodrh2019-03-29
| | | | | check-ins back. FossilOrigin-Name: 965cbcea117835d2c6d2ec58c8025b227f491c35805e282cb31228436bc6bec1
* Prevent aliases of window functions expressions from being used as arguments ↵dan2019-03-28
| | | | | to aggregate or other window functions. FossilOrigin-Name: 1e16d3e8fc60d39ca3899759ff15d355fdd7d3e23b325d8d2b0f954e11ce8dce
* Fix a problem with a window function in a correlated sub-query where at ↵dan2019-03-22
| | | | | least one reference to the outer SELECT appears in a FROM clause sub-select. FossilOrigin-Name: 9aca86f98388ff66b2bccb3fbfc486a3931398d2a8da139f905826ae2cdbb205
* Internally, remove all references to a Window object that belongs to an ↵dan2019-02-22
| | | | | expression in an ORDER BY clause if that expression is converted to an alias of a result-set expression. Fix for [4feb3159c6]. FossilOrigin-Name: 579b66eaa0816561c6e47ea116b46f229188f0fc84c1173bfe0d21df2dff9a9a
* Build and test fixes for SQLITE_OMIT_WINDOWFUNC builds.dan2019-02-11
| | | FossilOrigin-Name: 8824115a9776e876a3677f0cb479e311ee65584d43872b37766a146afec72d8f
* Fix a problem with renaming a table within a schema that contains a ↵dan2019-01-23
| | | | | composite query that uses a column alias as an ORDER BY term. FossilOrigin-Name: 2ca6b8f84ec07e313aa4e1c0894827401b418dcc4221e9c54c384f1c3893952a
* Fix problems with sub-selects in WINDOW definitions. Also rename-column ↵dan2019-01-23
| | | | | operations when the column being renamed appears in a WINDOW definition that is part of a VIEW or TRIGGER. FossilOrigin-Name: 0387cb3add992b2028efe4f2100188d8f9fdfdcb233329857aa4b46a293cfc97
* Fix a problem with fix [b4b57413].dan2019-01-16
| | | FossilOrigin-Name: ca7b7aaed010ec67bec5355a9ac1d7f229d6d5f2ba2d796b76f5e908b1267688
* Fix a problem with renaming a column that is used as part of an ORDER BY on adan2019-01-16
| | | | | compound SELECT within a database view or trigger. FossilOrigin-Name: b4b5741366578b25ec6e4c415ab8239215e53b1c900be613575f40a826cfccc9
* Raise an error if the argument to VACUUM INTO is an identifier.drh2019-01-02
| | | FossilOrigin-Name: 6c6fb1c6ea452c70b56fd4ac796affebee21512adba0455ae81c291b715f544f
* Fix harmless compiler warnings.drh2018-12-14
| | | FossilOrigin-Name: 27221c69901d2b4546167639c4a3c8f54b2e18820f1346870fa26b7c919027db
* Further refinements to the sqlite3_normalized_sql() interface. TH3 nowdrh2018-12-10
| | | | | gives 100% MC/DC on that interface. FossilOrigin-Name: c96bf6cca220e363b099455ce35195ce7e89d374a52dc787f56e7b11e587bced
* Fix the sqlite3_normalized_sql() interface so that it rendersdrh2018-12-07
| | | | | double-quoted string literals as "?". FossilOrigin-Name: 0d8e150434bbd179696f1ffe71d1e06cb3d43e6468496c7e481fca8486387bad
* Issue a warning whenever a double-quoted string literal is used.drh2018-12-06
| | | FossilOrigin-Name: ac9ad5043026b30394812457e1535df2759aea0d4510029561e92e386672796f
* Omit a line of code that has no affect on the outcome.drh2018-12-02
| | | FossilOrigin-Name: 5d933aa659eb7a13f9ab44fe7762be292a1c3c75b957a3b7e0bc6188257b62f4
* Do not allow direct access to internal-use SQL functions such asdrh2018-11-26
| | | | | | sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. FossilOrigin-Name: 6e1330545e7b74fe5f1f20751a3425e2788441485fc07fcb7626e448c72027ce
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-19 16:22:09 +0000