aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* Since SQLite considers NaN to be like NULL and NULL sorts before any integer,drh2023-10-28
| | | | | | make sure the sqlite3IntFloatCompare() routine reports that the integer argument is larger if the floating-point argument is NaN. FossilOrigin-Name: de1cf31a34b0f21288e7e30434a06baf25ee579929107c22e65c57236577fc4a
* Fix cosmetic flaw in SQLITE_TXN_* doc. (no code change)larrybr2023-10-27
| | | FossilOrigin-Name: 72d7c18f80f41529811f74855ac198681a0cfe7634225233ec4b8df219c2e73b
* Cleanup shell.c comments. Hide -utf8 option, as it is undocumented and ↵larrybr2023-10-27
| | | | | accepted only for backward compatibility. No functional changes except for -help content. FossilOrigin-Name: 3a87995560b5acbebeb5af407aa9eddf4c37c6a27ec9429ece0ea931918f9d9c
* Back out [2904fcbeebba9189], mostly. The page bitmap is needed even for adrh2023-10-27
| | | | | | partial integrity_check in order to avoid an infinite loops while walking the database. FossilOrigin-Name: dd6e03b37356e2961abd97f636402c09744c98c3033f3435503958c6219f9121
*-. Handle utf8 mode restore better for redirected input or output. Move utf8 ↵larrybr2023-10-26
|\ \ | | | | | | | | | | | | mode setup to before any invocation command processing. Sync w/trunk. FossilOrigin-Name: 59452e7c72de02c2b6d40974c91173d87fd5f6f2e28c0b1f6f53eb1a09693fb6
| | * Further enhancements to make sure the correct returnning trigger is run whendrh2023-10-26
| | | | | | | | | | | | | | | there are nested INSERT RETURNING statements. FossilOrigin-Name: d83405e870b071540b56e76291bdce1388db80b860afd68a34e4233f6ff2a3ab
| | * Handle the case where a virtual table xBestIndex method called while coding ↵dan2023-10-26
| |/ | | | | | | | | a trigger fired by a top-level statement with a RETURNING clause prepares a statement that also contains a RETURNING clause. FossilOrigin-Name: ec6bffa3b0fbf7cdee852cb0208de1f5869dafd88e2ee64c23cec89634219adc
| * Deal with the case of a reentrant INSERT on a virtual table where thedrh2023-10-26
| | | | | | | | | | | | outer INSERT has a RETURNING clause but the inner does not. dbsqlfuzz 3ac9a1e33f676254e02c0f297263b0a7aeb0c1a5. FossilOrigin-Name: 8aba78e4dbf5c196aa50a28579f4bcd7c96103661c5968d62b2fded075bc73e4
| * Fix harmless compiler warnings.drh2023-10-25
| | | | | | FossilOrigin-Name: cc8efe0494b8fe0df18aa67b1675779bf704d1ac53647fe1f7f55d8048041680
| * Provide dummy parameter names in the prototype for the new xIntegrity methoddrh2023-10-25
| | | | | | | | | | of the sqlite3_module object. FossilOrigin-Name: 131374d720a365cbbe3031a2bc0a34ba1c74e751e39c66e484dbce07ab49fb62
* | Ready for merge, but could use testing on some dusty old Windows machines.larrybr2023-10-26
| | | | | | FossilOrigin-Name: 20220615621e01ff83fd26133840e2553a6087bcb56bbb8e9bf1408dd881cd9b
* | In CLI for Windows builds, do MBCS/UTF-8 translation independently for input ↵larrybr2023-10-25
|/ | | | | and output. (WIP) FossilOrigin-Name: 47b13e66e07be3a26cf7fa0b7b65ad8576c3b4be50fc422be8fe93be93d681ac
* Add an ALWAYS on branch that was made always-true by the DISTINCT ORDER BYdrh2023-10-25
| | | | | fix. FossilOrigin-Name: c29ebcb0be8e969c359c077bd4ce752a9c952d2659062868f12efdd2cc77186d
* When doing a DISTINCT aggregate that contains an ORDER BY, only thedrh2023-10-25
| | | | | arguments to the aggregate need to be distinct, not the ORDER BY terms. FossilOrigin-Name: d2dbbdf7194bab4e5e3b74d3dbffb012a335829824c775c72dd7347c013d2125
* Enhance the new xIntegrity method of the sqlite3_module object with newdrh2023-10-25
| | | | | | | parameters that provide the name of the table being checked and a flag to indicate a "quick_check". Based on feedback in [forum:/forumpost/965c0d02ea|forum post 965c0d02ea]. FossilOrigin-Name: bc8afa3f15954bb35f65dbf940bf069de5e14d333036676c24430cf17b658d05
* Implement check-in [477577120b897bf1] differently, so as not to disruptdrh2023-10-24
| | | | | | non-standard build configuration. See [forum:/forumpost/c11523ca2df50293|forum post c11523ca2df50293]. FossilOrigin-Name: 50448fe4fdc8fd93303fe26bdcd885ecc606080c8e66e69d5be8dac28a77492b
* New #ifdefs to fix certain compile-time options.drh2023-10-24
| | | FossilOrigin-Name: 688c6279ef1d4ff8d58e83a1c73ca0221ab8570a7cd89459946a86afdad6ec1c
* Spelling improvements, in comments onlylarrybr2023-10-24
| | | FossilOrigin-Name: 9ee25eeaf17124dbe34b961384e74c1ae239ee1798bb01907938600ed6b4066f
* Spelling improvements, in comments onlylarrybr2023-10-24
| | | FossilOrigin-Name: 65bcc583784476f8cc52dfe72ecc52df93d0ec5817c313ad7a83905c0047dd8c
* Fix various harmless scan-build warnings.drh2023-10-24
| | | FossilOrigin-Name: 54be9af4469d7e31ee852f67e5aa32996557c10de654a60103fd165d2fedf311
* Revert an earlier change that considered passing a NULL callback to ↵dan2023-10-23
| | | | | sqlite3_preupdate_hook() to be a misuse. This is required to clear the preupdate hook altogether. FossilOrigin-Name: 1bf6f0f3bb54933e4e6c730554144934f73a7fac87c97a916b275afd7379f397
* Fix sqlite3ExprDup() alignment assertions so that they work on 32-bitdrh2023-10-23
| | | | | platforms. FossilOrigin-Name: 143f95efc7114455b1920f1d2f9a867392740f608d1dda4306005f01238103f8
* Add an SQLITE_OMIT_VIRTUALTABLE block around the new vtab code in "PRAGMA ↵dan2023-10-23
| | | | | integrity_check". FossilOrigin-Name: ab99eb2b6c50f4f0bb42918b9bdda37e2ef9316bed07de18fa4bd373c49a8b00
* Fix [f5c01676fd281e93] so that it always preserves 8-byte alignment for Exprdrh2023-10-22
| | | | | objects. Add new assert() statement to verify this. FossilOrigin-Name: 678a9728dc6b88d8ef924c86603056df18204bc9a9c4776b9baffd7c5b10c5f2
* Do not do backslash excape processing on any unquoted strings in dot-commandsdrh2023-10-22
| | | | | | | | in the CLI - on Windows or on posix-like systems either one. This brings the processing into alignment with the documentation, allows backslash-delimited filenames on Windows (as long as they are unquoted), and causes the CLI to work the same with regard to backslash escapes on both Windows and posix. FossilOrigin-Name: bce807cd4876327396b4ffcdf77f6931dd3bbd3314336eedf38bcf01d17af32c
* In the CLI, do not translate unquoted backslash escapes on dot-commandsdrh2023-10-21
| | | | | as that can damage filename arguments. FossilOrigin-Name: 4a0e2c6e17eefb296b7e91a13305b2260d6eb869a37bc5e5b79edaf3c19c810a
* Remove a branch that cannot affect the outcome from FkNoAction processing indrh2023-10-21
| | | | | fkey.c. Replace it with an assert(). FossilOrigin-Name: 023a9dbe83c0042e9d500e3ae6c0592a468982e4ac278d08c9201967506c7555
* Replace the patch at [5cb61c6788d7c017] with a better way to avoid failingdrh2023-10-21
| | | | | | PRAGMA integrity_check if a module implementation is not loaded, as the use of suppressErr can lead to problems. FossilOrigin-Name: be5737ee4f4f1d5f8b3126f6eb70210bf3d8b1cdaef51aae818eaaba43ccf722
* Extra comment on the implementation of SQLITE_TESTCTRL_FK_NO_ACTION,drh2023-10-21
| | | | | | warning about the need to reset the schema in order for the setting change to take full effect. FossilOrigin-Name: a50a333ae11ba5d92f432108308ac0bec9afb00f466b78c8d3f3aa7e2851ef21
* Fix a problem with SQLITE_CHANGESETAPPLY_FKNOACTION and the ↵dan2023-10-21
| | | | | foreign-key-trigger-cache. FossilOrigin-Name: 95304ec6c9654b4366dc58ae263270cb42861cb5017174936f816922b5eb61e6
* Add SQLITE_TESTCTRL_FK_NO_ACTION.drh2023-10-21
| | | FossilOrigin-Name: 563cf5f782cdddbbd7f727c65118edfd109aeb731c8aaf0d6ee5ee7030e61ea9
* Create the new string_agg(X,Y) aggregate function which is an alias fordrh2023-10-21
|\ | | | | | | | | | | the two-argument group_concat(X,Y) function, for compatibility with SQL-Server and PostgreSQL. FossilOrigin-Name: a3b3df8a9e43f1880a904b76027db56ed504a84622831c96ba1962a19bbed762
| * Add string_agg(X,Y) as an alias for group_concat(X,Y), for compatibilitydrh2023-10-20
| | | | | | | | | | with SQLServer and PG. FossilOrigin-Name: b91c19bf2680f60d7826ab5d9e7902e2dc2a55d847bbea565a6489d47f2cc8f1
* | Avoid an unnecessary malloc() for the page usage bitmap when runningdrh2023-10-21
|/ | | | | a partial integrity_check. FossilOrigin-Name: 2904fcbeebba9189cebc48e58d12fc46f78ee23d8c4d46644606691f8cabb80c
* Fix PRAGMA integrity_check so that it does not raise an error if thedrh2023-10-20
| | | | | | schema contains a CREATE VIRTUAL TABLE that does not have its module loaded. FossilOrigin-Name: 5cb61c6788d7c0170b587e4667ee57d588c991a9901951762e33b97c6a135a82
* Omit some redundant calls to strlen() used to find the size ofdrh2023-10-20
| | | | | | | Expr.u.zToken in sqliteExprDup(). This inefficiency was seen while working on the previous check-in, and I thought it best to fix it while it was fresh in mind. FossilOrigin-Name: b7a84eff5dcdf5b2ff81331097cdc64d0c5d16a4ae224320f39b64541ec72dc7
* Improvements to the sqlite3ExprDup() logic for faster performance and betterdrh2023-10-20
| | | | | | | | run-time error detection. This check-in fixes the 5x oversize memory allocation bug from [f371e4c0f8ea73ae] as well as all other known issues that result from handing the ORDER BY clause of an aggregate function off of the pLeft pointer of the Expr object. FossilOrigin-Name: f5c01676fd281e938181b846dd2024d050f597dc6a7a91928beab9d8553dfdb5
* Add the SQLITE_CHANGESETAPPLY_FKNOACTION flag to sqlite3session.h, for ↵dan2023-10-20
| | | | | passing to sqlite3changeset_apply_v2() to cause all foreign key constraints to behave as if they were declared NO ACTION. FossilOrigin-Name: fc9f82ea084159eaf3dd1757b96d17d1201b00c4e06455a7dcd8067172b25f28
* Simplifications and optimizations to the Expr object duplication logic.drh2023-10-20
| | | | | | The 5x multiplier crutch from [f371e4c0f8ea73ae] is still present. More fixes are still needed. FossilOrigin-Name: 56142a78163b755f16afc05201f623a7a19d9a4b0620a67f7fa20d2a965a288d
* Use sqlite3ParserAddCleanup() instead of calling sqlite3ExprListDelete()drh2023-10-20
| | | | | | directly when disposing of an unused ORDER BY in an aggregate function, to avoid disrupting ALTER TABLE data structures. FossilOrigin-Name: d083e42086733ecd79aba8c268e020b01782bfe1cfa9684ce1c277af9c8bf92a
* Remove a faulty assert() that was added just a few check-ins ago bydrh2023-10-19
| | | | | [8b6fffb552c30f9c]. FossilOrigin-Name: 18e7c826f08bce51719ef045daa60200b33790f2fe312c6853f9ef6c7e9d5030
* For TK_ORDER expression nodes to always be full-size.drh2023-10-19
| | | FossilOrigin-Name: a5c73b46f4772f214ffbfa31cb87dce82ebd690addabef539bd09def26b7744d
* Fix an adverse interaction between the new aggregate ORDER BY logic and thedrh2023-10-19
| | | | | expression compressor. FossilOrigin-Name: f371e4c0f8ea73aee9ea0645f396e3da20f1eb97be34c83de9d94c9cbb959934
* In the TreeView logic (used for debugging only) do not show unnecessary fieldsdrh2023-10-19
| | | | | of the Window object when a function has a FILTER. FossilOrigin-Name: d2c6b82c346dbf39e07f09d187e4a8216a56caa7df3dcfafc82e32f676a1db8a
* Simplify the Expr compression logic slightly by adding the new EP_FullSizedrh2023-10-19
| | | | | | property to expressions that are exceptions to the rule and should not be compressed. FossilOrigin-Name: d5ae82ec52eafed5e3dc8c9d99685f6523fce7d973ef7e8d9d75ed9b8912426a
* Simplification to sqlite3GetVarint32() to avoid confusing gcov.drh2023-10-19
| | | FossilOrigin-Name: 89862c51ad9715bedf5b029db484602e740f0db7404970d482ce503c1b9a0ed2
* Fix an error in a debugging routine used inside of testcase(). Does notdrh2023-10-19
| | | | | appear in production. Problem discovered by scan-build. FossilOrigin-Name: c6c9d7ed6dbc71b998aeaaa1bdeb36b1bb9b902f9d6088ad36db29f8ea8b7ef6
* New assert() statements to help verify correctness of the ORDER BY aggregatedrh2023-10-19
| | | | | code. FossilOrigin-Name: 8b6fffb552c30f9cbf7102c2e26a7b486c4c9edd9f494d803de7004db3018277
* Fix the sqlite3ReferencesSrcList() routine so that it recognizes columnsdrh2023-10-19
| | | | | | in the ORDER BY clause of an aggregate. Fixes a problem with [634286828dad873d] discoverd by dbsqlfuzz. FossilOrigin-Name: 3d26f1aaa4876f21f2c3abf13bbc37933c8f32471153e29019880cc9530cb011
* Merge the latest changes from trunk.drh2023-10-19
|\ | | | | FossilOrigin-Name: d18bc400146812c8c5048af7eaf4a5371ddd80fc9ce895d253b6114b9eae7fc3
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-19 05:10:22 +0000