aboutsummaryrefslogtreecommitdiff
path: root/src/sqliteInt.h
Commit message (Collapse)AuthorAge
...
* 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. 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
* Always use the stdlib.h intptr_t type for pointer-integer conversions, whendrh2019-07-17
| | | | | it is available. FossilOrigin-Name: c0d932449db3deed42a99bd948aab61e56b2d8441d7de5243688695ff04e8177
* Add support for attaching a FILTER clause to an aggregate function.dan2019-07-13
|\ | | | | FossilOrigin-Name: ee293e5aeac0b05a8b809095610fd8b4fdaf8e68cd368de90ec0d45e3582ffe5
| * Rework the FILTER clause implementation to share more code with window ↵dan2019-07-13
| | | | | | | | | | functions. FossilOrigin-Name: 5dac8c38dfc3f41c5c8fb49ca35de7fd1b21f269d72e8ba6ba59ed0a4030a54d
| * 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
* The affinity of the unlikely() function and its cousins should be "none".drh2019-06-11
| | | | | Ticket [0c620df60bffd9ef] FossilOrigin-Name: 614ecb0af47038848e8ba2aed6b92db6f33ddc4aea6361795dbde440380f5a35
* Add the new sqlite3ExprUnmapAndDelete() function and use it in place ofdrh2019-06-11
| | | | | separate calls to sqlite3RenameExprUnmap() and sqlite3ExprDelete(). FossilOrigin-Name: 36ea13e0a851a749c9ef292377ecd82dbd4797d38df907b362487fa234c98ca5
* Smaller and faster sqlite3IsNaN() implementation makes deserialization ofdrh2019-05-30
| | | | | floating point values much faster. FossilOrigin-Name: ea748edecb261f2b862d542daff6e99a6fd8879a8ace94b440d99e110577d1c1
* Much faster implementation of applyNumericAffinity() by avoiding somedrh2019-05-29
| | | | | unnecessary calls to sqlite3Atoi64(). FossilOrigin-Name: c1d8a3f65490eef2216f360d708b1746cbaa6dadce42c0950dc8e09b9ab28ee2
* Improvements to the automatic compile-time selection of byte-order, asdrh2019-05-20
| | | | | suggested on the mailing list by Seb Kemper. FossilOrigin-Name: b7aad929619f7043b1685a6477d50f6b4436e85511eb365eceae3dd4dbab571a
* 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
* Update the sqlite3ExprCompare() routine so that it does not think "? IS NOT ↵dan2019-05-20
| | | | | TRUE" is the same as "? IS TRUE". Fix for [d3e7f2ba5b3]. FossilOrigin-Name: 99eba69b3a64741c69d167bf7a05dbe138c9e7faecc54a1b8d8220cb23902830
* Disable index seek optimizations on REINDEX when the order of primary keysdrh2019-05-14
| | | | | | in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. FossilOrigin-Name: f7aadfab3bb8eb8eb2cd62dc8a6823538387b3329f1efc23ef75482488109478
* Add the SQLITE_TESTCTRL_RESULT_INTREAL test-control and use it to createdrh2019-05-03
| | | | | | the intreal() SQL function in testfixture. Write a few simple tests to prove this all works. TH3 will hold most of the INTREAL tests, probably. FossilOrigin-Name: c9838731325e0ca73bd8784c10c74ae043fed7861e6de269fd90e29fa4a19955
* Improved optimization of the AND and OR operators.drh2019-04-19
| | | FossilOrigin-Name: 0fbd154eb419b57b9c064c1f47346835d6324388b966b73f8a0122de065f08b1
* Use macros to determine if an expression is always true or always false.drh2019-04-19
| | | FossilOrigin-Name: 6de980a09c3a7adf71f2c9a63a242673b5e1f246e8ee071b26844275f0dad0fc
* Streamline the processing of the AND operator. Slightly smaller and faster.drh2019-04-19
| | | FossilOrigin-Name: 7713996aa99ce6dd35b5a2db74dd26658fb8d9817169b2a7531cdef6edb41403
* Improved reporting of SQLITE_TOOBIG errors while parsing.drh2019-04-09
| | | FossilOrigin-Name: ea2d4b65e20e44e19219c821bf68e97ff3af1760b3b4762250d020ba2a5a6343
* Only preserve rowid values for VACUUM INTO. Keep the legacy behavior ofdrh2019-04-04
| | | | | renumbering rowids for ordinary VACUUM. FossilOrigin-Name: 13a0ea6466b051ea5281865ed5285b8b5a99ec4307f400c5f7b03692723f1cd1
* Use a separate bit on db->dbOptFlags to disable the xInverse optimization ondrh2019-04-02
| | | | | window functions, rather than reusing the query-flattener disable bit. FossilOrigin-Name: bc0fb1c324be2fd668bc4398c7d364b7e3c5a98537fe5fb58a125b66f3e6d041
* 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
* Improved TreeView display of Window objects.drh2019-03-28
| | | | | | Change the Window.eType field to Window.eFrmType to avoid confusion with other "eType" values. FossilOrigin-Name: ec2f207dedb223077bbd3e4584499250eb12219712c917e930acccfa2c46e23b
* In order to identify the first row of each partition, check if the rowid in ↵dan2019-03-16
| | | | | the ephemeral table is 1 instead of using a dedicated flag register. FossilOrigin-Name: f2d5f7a24c7aa483c579706c5bd7268a74da6d53025d78fa8642908c2aed1707
* Parse EXCLUDE clauses in window frames. They do not yet work.dan2019-03-14
| | | FossilOrigin-Name: d03c7533a1e993f1b12392a5193b2127484307b27072236a1255e7a30849a381
* Add things to this branch that will be required to support the EXCLUDE clause.dan2019-03-14
| | | FossilOrigin-Name: 7d66cd2013206ebad50c7cdb7dab9211fa8b47f5cb7067dcb314b3e0180875f8
* Avoid allocating excessive registers for the PARTITION BY expressions when ↵dan2019-03-13
| | | | | processing window functions. FossilOrigin-Name: 180be266238e18c01f8bd52c75dd9aa3e26e553620258141cd95189a0ae59ddb
* Remove "cache mode" from the window frame code generator. Handle the same ↵dan2019-03-11
| | | | | cases by editing the window frame specification itself. FossilOrigin-Name: 081263538332bb9c07e62630629007ccbba31bef5dc890f60b4ba58a355f70ac
* Improvements to the way built-in window functions are handled.dan2019-03-06
| | | FossilOrigin-Name: e8eee566dfca6f4c8af074731dfe91f7fbcd9ca72f0303235b52e4e2e80d5b71
* Merge trunk changes into this branch.dan2019-03-04
|\ | | | | FossilOrigin-Name: 9b4d561f68febdab6624d8c567fb4357bf67dda500664cf708d16a76f37b8ec1
| * Make all ephemeral tables built to hold the RHS of an IN operator bedrh2019-02-22
| | | | | | | | | | | | | | index-btrees, never table-btrees, regardless of whether or not they are used as IN_INDEX_LOOP or IN_INDEX_MEMBERSHIP. That way, the same ephmerial table can be reused for both cases. FossilOrigin-Name: c2d50df8fd1a1fdae6226a3e77296ded09b53a74540caedd4868e686a93cbc10
* | Support some "ROWS BETWEEN N PRECEDING AND M FOLLOWING" window functions ↵dan2019-03-04
| | | | | | | | | | without caching entire partitions. FossilOrigin-Name: e7a91f12282afb5d5d7d78397a11d18e0268ee0c931d85e21fce00d13929494e
* | Add support for chaining of WINDOW definitions.dan2019-02-16
|/ | | FossilOrigin-Name: c155125fd5dddb438c09d40f5137c47d88defb7a6ede4261f09d7bdaad250d37
* Give the sqlite3 object a pointer to the current Parse so that if an OOMdrh2019-02-08
| | | | | | occurs, it can automatically set the Parse.rc value to SQLITE_NOMEM. This avoids a frequent extra test of db.mallocFailed in the innermost parser loop. FossilOrigin-Name: 5c6638040b3017c6be016441422d965a3ca00dd6ae1f78cadc0b54562978f64e
* Honor key query parameters for SEE on the URI filename for ATTACH drh2019-02-02
| | | | | and VACUUM INTO. FossilOrigin-Name: 2e01096b8933a2315e3dffcd7d0de84c744c1b4be1d909388c61f0fd636ddb99
* Add the SQLITE_CONFIG_MEMDB_MAXSIZE configuration option for configuringdrh2019-01-31
| | | | | | | the default maximum size of an in-memory database created using sqlite3_deserialize(). This is necessary to make the interface reasonably testable. FossilOrigin-Name: cb72ee0478ce98c48aae059fd5de4e36caf2b8c953e08fcb799bfd119ad46b73
* Improvements to "PRAGMA parser_trace=ON": Make it a flag pragma, and thendrh2019-01-31
| | | | | use the flag to show the complete SQL text at the beginning of the parse. FossilOrigin-Name: 507c43537f00d089efb3c3020fb6e826e8f89f3efa2caaa12c5309d35dd0c22e
* Detect if two indexes of the same table share a common rootpage whiledrh2019-01-30
| | | | | parsing the schema, and throw an error immediately. FossilOrigin-Name: f21c6f1343edc4ba68f9f8e68caac34da0d1c651526ecaf61c0e2d66593a555e
* Revamp the SrcList allocator routines to be methods of Parse instead ofdrh2019-01-17
| | | | | | being methods of the "sqlite3" object, so that they can leave better error messages when the SrcList object grows too large. FossilOrigin-Name: df08d472b090b212fb77ce2aae0e1ffe79ae5db4b1accf55e6fdb18e8b0a7098
* The keywords TRUE and FALSE should only act as boolean literal values ifdrh2019-01-11
| | | | | unquoted. FossilOrigin-Name: 5547f39de993c708f72301ef25df190a2f007e0c4253799bdd9e86bb1ae41777
* Use the new SQLITE_IDXTYPE_IPK values (3) on Index.idxType to indicate thedrh2019-01-10
| | | | | fake INTEGER PRIMARY KEY index used during query planning. FossilOrigin-Name: e22d2f905fe840bea51b536ebedc9b637190ea0a37f16559668d99a61e971411
* Enhance the ALTER TABLE RENAME COLUMN feature so that it works on tablesdrh2019-01-09
| | | | | | that have redundant UNIQUE and/or PRIMARY KEY constraints. Fix for ticket [bc8d94f0fbd633fd9a051e3] FossilOrigin-Name: f09aa3248e2b4a32ff5b5d37084cb2a27445322cb06a3354cef723f4f0b2cd34
* If the OP_ParseSchema opcode with a non-NULL P4 operand does not parse anydrh2019-01-05
| | | | | | rows out of the sqlite_master table, that indicates that the sqlite_master table is corrupt, so raise an SQLITE_CORRUPT error. FossilOrigin-Name: 598d7358e7329f0de6e3defc217665909e46874258ac29592ee2fd53e6411cda
* Raise an error if the argument to VACUUM INTO is an identifier.drh2019-01-02
| | | FossilOrigin-Name: 6c6fb1c6ea452c70b56fd4ac796affebee21512adba0455ae81c291b715f544f
* Merge enhancements and bug fixes from trunk.drh2018-12-31
|\ | | | | FossilOrigin-Name: 9fb646f29c05bca5f677a2c7c4f45c36bfe0a0c6a88cb7968b4a0459bdd63bb2
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 08:10:33 +0000