aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
...
* Fix a harmless compiler warning.drh2023-04-08
| | | FossilOrigin-Name: c9559ba62191fe7fa2a718233afaa841e2594d1fc833314bf5b0a6b775e87c35
* Optimizations to btree.c save about 4.5 million CPU cycles:drh2023-04-08
|\ | | | | | | | | | | | | (1) Clone insertCell() into a separate insertCellFast() routine for use by sqlite3BtreeInsert(). (2) Mark allocateSpace() as always-inline. (3) Improved coalesence of adjacent free blocks in pageFreeArray(). FossilOrigin-Name: 5c12c400fe8eb4e86e14c69a6c34d0d78d9861e5d40a36c6a596a81c6dd65977
| * Guard against oversized cells in the newly enhanced pageFreeArray().drh2023-04-07
| | | | | | FossilOrigin-Name: 2dcdbb50356edbd3a79e53fa0bee4e700c2bdea78e27173b62ddabe44b066726
| * Add NEVER on an unreachable branch.drh2023-04-07
| | | | | | FossilOrigin-Name: 9b3febbd988be05807ada20146d3e196ae17c966722fff049feb32292157bff2
| * Fix an assert().drh2023-04-07
| | | | | | FossilOrigin-Name: 7eff46ba97dd8a3d6a5d01d5d61e98a2805deceafa47335eded7d784a8304525
| * Tweaks to the new insertCellFast().drh2023-04-07
| | | | | | FossilOrigin-Name: 203a581a9177c1083e8d5b49e8ff026af33b5c5e3e144aeda126f07a3a2953bf
| * Clone insertCell() into insertCellFast() for use by sqlite3BtreeInsert() fordrh2023-04-07
| | | | | | | | | | a substantial performance increase. FossilOrigin-Name: f225afd90c8e65661d8b855050f0ee1a8fe4c0f3bcec824aa5a66d906f3c7119
| * Small performance improvement in freeSpace().drh2023-04-07
| | | | | | FossilOrigin-Name: 8dc5292ee592f16451441e33ad0800ba10a21ecd63f1f9926d6915a59a1552d3
| * Increase the size of the cache of free blocks inside of pageFreeArray() todrh2023-04-06
| | | | | | | | | | reduce the number of calls to freeSpace(). FossilOrigin-Name: 27c59f1ea789f3ff245f23e79ded5cd71c48e3a51ffbb8c220b51101a4e69fd7
* | Fix a problem causing the rbu_exclusive_checkpoint=1 to be ignored with ↵dan2023-04-07
| | | | | | | | | | zipvfs databases. FossilOrigin-Name: d8f50b31e8d64fce5141da4a016767a15482703364692a55df346f059fc9d30c
* | Add further tests for the rbu_exclusive_lock=1 URI option.dan2023-04-07
|/ | | FossilOrigin-Name: c07b62bef96bb69e9b1ce08f0084fdce8de981f4d8ea9689c87a41f1e4451ac7
* Work around a harmless assertion fault associated withdrh2023-04-06
| | | | | | | | | sqlite3VdbeMemAboutToChange() such that the detection of stale values in registers is preserved in debugging builds, but we avoid a false-positive assertion fault in cases involving a virtual table with a LIMIT clause in an IN-operator loop. dbsqlfuzz 3fd70d4ab4950acf1deb8f610a7a7c67cd38713b FossilOrigin-Name: 56ea2c2fe6108d39833ac40957afab59ade01a216639d5bafdeeca53bbf4cd67
* A prepared statement that aborts due to SQLITE_SCHEMA should not invalidatedrh2023-04-06
| | | | | | | cursors in other prepared statements that are already running. See [forum:/forumpost/cae4367d9b|forum post cae4367d9b] for the original trouble report. FossilOrigin-Name: 857d0f5e16ba69ac9e5ee581befca2f7ed933edfe6e36396b10dae7979b44a57
* In the CLI, during error processing while looking for a word boundary,drh2023-04-06
| | | | | | | avoid being deceived by malformed input that has a very long sequence of 0x80 characters. [forum:/forumpost/ab93a23ba1|forum post ab93a23ba1]. FossilOrigin-Name: 82609d5a2d4eba741d48ea265f4e749578964961903c072c7b222ffe2aefaa3c
* In the zipfile extension, defend against corrupt ZIP files that containdrh2023-04-06
| | | | | | a zero-length filename. [forum:/forumpost/b15f5e3ad8|Forum post b15f5e3ad8]. FossilOrigin-Name: 46db2e42a5f9b18da9661ccedca68cb70257ea5c58b33b401db2a5e030c1346a
* In the new .scanstatus command in the CLI, make sure the database is openeddrh2023-04-06
| | | | | | before invoking sqlite3_db_config(). [forum:/forumpost/6e26dcf544|Forum post 6e26dcf544]. FossilOrigin-Name: 1cd993c45cd6b60e00d1426dd01d63efad13f7258636b5fa694f21499e77955a
* Add a test case for the ALWAYS() macro removed by the previous check-in.drh2023-04-05
| | | FossilOrigin-Name: 68a1a837493a0bc5e0e0f2373ac76cb575078cec08990c017fdcb51a4ba363a1
* Remove an ALWAYS() that might now be false due to the prior check-in.drh2023-04-05
| | | FossilOrigin-Name: fc68993501aaa7180f5457dcb3c296e5b199904a385d98e2bcad7854e34d428e
* Fix the function that determines the collating function for an expressiondrh2023-04-05
| | | | | | | tree to handle new cases that arise as a result of the recently added ability to use indexed expressions in aggregate queries. [forum/forumpost/0713a16a44|Forum post 0713a16a44]. FossilOrigin-Name: cc5041f3f067cf610adffb868b4e2d1b5d248dc5a0ecc551339b670800ecb0ff
* Shell to use SQLITE_SHELL_HAVE_RECOVER consistently (correcting check-in ↵larrybr2023-04-04
| | | | | 0421cc03e0efa8f1) FossilOrigin-Name: 5b980d72a03fa1cfd0f1bf3ed04068b9f216b75a304deb2b7bbe8ddce0e6fb96
* Fix an incorrect entry in the array that maps sqlite3_value values intodrh2023-04-04
| | | | | actual datatype numbers. dbsqlfuzz f660c659bcec48577a43d3bab37f46baaa22f59e FossilOrigin-Name: fa8537dc90cad962dec695418d48da2890a172801ecad0c7c804023a063d3a02
* Remove an assert() statement that is no longer valid due to enhancementsdrh2023-04-04
| | | | | | to query planner for improved use of indexes. [forum:/forumpost/dc16ec63d3 |Forum post dc16ec63d3]. FossilOrigin-Name: 2b23dd249d0bc254308f5539936d33ee558f1100dec616caac7317dbe70db761
* Expose the new SQLITE_VTAB_USES_ALL_SCHEMAS to JS.stephan2023-04-04
| | | FossilOrigin-Name: b7ef09be667dd349e195842304c03cbebb1693164e1c3587a5d7c96baa713edf
* Omit shell call to sqlite3_dbdata_init() when it is omitted.larrybr2023-04-04
| | | FossilOrigin-Name: 0421cc03e0efa8f1a83e46e91f26837366c10eef0903d099e25eb0cc99c297df
* When translating arguments of aggregate functions into references todrh2023-04-03
| | | | | | | expression indexes, make sure to only translate them for the current aggregate when there are nested aggregates. [forum/forumpost/409ebc7368|Forum post 409ebc7368]. FossilOrigin-Name: 898bfa1afd8260eaaf2aa6db94e74d99ebf4e8a6dc02cf21d20cd981393609a5
* Improved diagnostic output from PRAGMA vdbe_addoptrace.drh2023-04-03
| | | FossilOrigin-Name: 050958c1828f7446e7ee7e458123a23b735e213b76a67c3dd8356da256cbc170
* When changing a COLLATE expression node into TK_AGG_COLUMN because the nodesdrh2023-04-03
| | | | | | | | value is contained in an indexed expression, be sure to clear the EP_Collate property from the expression node. Fix for the assertion faults reported by [forum:/forumpost/e45108732c|forum post e45108732c] and [forum:/forumpost/44270909bb|forum post 44270909bb]. FossilOrigin-Name: cf6454ce26983b9c3ae924c44a802f3f760eaaae9547b40aee9e14e7b0c47cab
* Add the SQLITE_VTAB_USES_ALL_SCHEMAS option to sqlite3_vtab_config(). Updatedrh2023-04-03
| | | | | | | | | | the sqlite_dbpage, sqlite_dbdata, and sqlite_dbptr virtual tables to make use of that interface. This was formerly handled by the internal sqlite3VtabUsesAllSchemas() routine that was called directly from sqlite_dbpage. But since sqlite_dbdata and sqlite_dbptr are an extension, an external interface to that functionality had to be provided. dbsqlfuzz 1a29c245175a63393b6a78c5b8cab5199939d6a8 FossilOrigin-Name: bcd51abee0b0f82bb5dbb881025a92d55baf9df6adeaf3a305e2e0da96a81d58
* Make the sqlite_dbdata and sqlite3_dbptr virtual tables accessible todrh2023-04-03
| | | | | the CLI. FossilOrigin-Name: c0eff02854d469bcdb949c09531760d6f96b49c17375abd1c131d41f38b9b2f0
* Stronger constraint checking in allocateSpace().drh2023-04-03
| | | | | dbsqlfuzz 93d4c9ff5ef7cd29f16e767af1ee71c29ec5a4c0 FossilOrigin-Name: 9e968f4fbce061190f10f31ce9d3eb4fce6706ea6b7e5011bfa1e893d37ca68d
* With the -DSQLITE_ENABLE_JSON_NAN_INF compile-time option, non-standarddrh2023-04-02
|\ | | | | | | | | | | | | JSON numeric values "Inf", "Infinity", "-Inf", "-Infinity", "NaN", "QNaN", and "SNaN" are all accepted. SQLite should never generate these values, but it will accept that with the appropriate compile-time option. FossilOrigin-Name: 0a050e9013331595e13ca9f859180057b59291c70a6cedb6230eefb25956df9e
| * More off-by-one errors in the new JSON parsing.drh2023-04-02
| | | | | | FossilOrigin-Name: dbc99662087b63c9ed5b398535a6091fc2c5e507907dd1fcb7ad0b6ab3f17144
| * Fix an off-by-one error in the recognition of -Infinity.drh2023-04-02
| | | | | | FossilOrigin-Name: f7ebf3e6286ddc8cdaa9446235407785d1be2be2d9992e21ef59fcd655f68432
| * Allow special floating-point value names in JSON: "inf", "-inf", "infinity",drh2023-04-01
| | | | | | | | | | | | | | "-infinity", "nan", "qnan", and "snan". All are converted into valid JSON values: 9e999, -9e999, or null. Requires the SQLITE_ENABLE_JSON_NAN_INF compile-time option to operate. FossilOrigin-Name: fc8793e5acac7351749e360c6bace5d5a8b3de3aa600ae23e260557db650c461
* | Earlier detection of corruption in sqlite3BtreeDelete().drh2023-04-02
| | | | | | | | | | dbsqlfuzz a4c48c291d6e40157a1b749a05eaa7c7faf5a625. FossilOrigin-Name: 978dc71c388b37740da38c310674315c7d7fe814d1daa16a146b4df71385d1e1
* | Clear executable bit on base64.clarrybr2023-04-02
| | | | | | FossilOrigin-Name: ec1ddbce7db270afc25f71546fa745935ad74bc72920fccfcb37e98649612bf2
* | Swat grammar nit on README.mdlarrybr2023-04-01
|/ | | FossilOrigin-Name: 715c00e58b774d6a29e2f60fd33a2ecb960307192ae1fdb8ed396f74fd62b444
* Fix harmless compiler warnings.drh2023-04-01
| | | FossilOrigin-Name: a4fb2864fe01cce9694242a0750623ca47fcecd68f74c4239d3eb5fbf978770a
* Improved error messages from PRAGMA integrity_check. Identify the root ofdrh2023-04-01
| | | | | | the tree when a problem is found in a b-tree, making it easier to track the problem to a specific table or index. FossilOrigin-Name: a1cb152e69c7c6cdd99300c91a8104716089de459d9d19e33ef38432aad70908
* In the b-tree module use %u instead of %d to print unsigned quantities suchdrh2023-04-01
| | | | | as page numbers and offsets. FossilOrigin-Name: 33ac62d8eec56eb71f20ccd28a5d6e4e8051522feb2db0199abee9e18ce1f64e
* Omit the the count-of-view optimization if there is a HAVING clause.drh2023-03-31
| | | | | dbsqlfuzz 6a107e3055bd22afab31cfddabc2d9d54fcbaf69 FossilOrigin-Name: babe2b5e59647ac9db4601e67c25190aac14eb76d5fcb9fa5b3692b955fefd61
* Earlier error detection for index expression usage by aggregate functions.drh2023-03-30
| | | | | dbsqlfuzz 29214ace4e25c98d2ddff8fbcf97afdda23f28b9 FossilOrigin-Name: 8e841e7f025f7205959453875f2d9db36271642045593970a2b2fc20b2f847c3
* Omit a branch that is no longer needed following [c9c4f287652933eb].drh2023-03-30
| | | FossilOrigin-Name: 960a488a2db92f5437bc8171cdbed44618d9381c57fd41b2f0e357b6012c80b5
* Fix an error in new test script test/aggfault.test.dan2023-03-30
| | | FossilOrigin-Name: 8724fe7426da55d19dba7b30e09321ba30c73286513864cb05de32f72e50ee31
* Fix a crash that could follow an OOM error while processing aggregate functions.dan2023-03-30
| | | FossilOrigin-Name: 804435a2731bd3c26278c47098854b9ee7727a686587f6208e793738fbfc0555
* Avoid having OP_SeekScan jump over an OP_IdxGT or OP_IdxGE that follows the ↵dan2023-03-29
| | | | | OP_SeekGE opcode. Fix for [b50528af4468237c]. FossilOrigin-Name: c9c4f287652933eb6262a3419efe7e7288f55d3db7e2ac032eeae025f665d306
* Fix a problem with sqlite3_stmt_scanstatus() from within an ↵dan2023-03-29
| | | | | SQLITE_TRACE_STMT callback made from within a trigger. FossilOrigin-Name: 1fa78fafa1340de458546526b03cf8b3e9c823913c4225d7c747ad182df5c0fc
* Another #ifdef to omit code that is only used by STAT4.drh2023-03-29
| | | FossilOrigin-Name: 445c75567de9bf9c8075dfc62c60dc4abeefab59c7803a5ef2cc5d69c08d7633
* New #ifdefs to omit code that is unused except under STAT4.drh2023-03-29
| | | FossilOrigin-Name: 09a9b30ba7828a487a33a3ebf8028dfaa147dff67d2724584123b90a88d9814b
* Enhance PRAGMA integrity_check so that it can detect that a NOT NULL columndrh2023-03-29
| | | | | | contains a NaN value and report that as an error. dbsqlfuzz f144b642fe6f1a1c196f258ac6e60118a0cb59b2. FossilOrigin-Name: 7638d9755dc90fd353b874d03ed418fa8aaee4440290ff69b1b552eae84e5baa