aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Inserts invalid JSONB should return "malformed JSON", not a json path error.drh2023-11-21
| | | FossilOrigin-Name: 306ee66fbd0231a9f5b229e5630d5cc66c9cf08b466d2d9204e79e1f44a16374
* Direct editing of JSONB using json_insert() and json_set().drh2023-11-21
| | | FossilOrigin-Name: fffb7a9538838e26991e6f16ea3138346a30c33ea6c3d3834680ee6d1f6eece2
* Correct blob-to-text rendering in some corner cases.drh2023-11-21
| | | FossilOrigin-Name: 7822e0e59f9b611fe6289cc762b0aff61f9b87c3a82c60de110f447589a2c125
* Fix the translation of JSON5 numeric values from BLOB into text.drh2023-11-21
| | | FossilOrigin-Name: 40c4fb441f220982e4d61fd42597cf18546791a302fbcc8eec2eed29ee15ef35
* Merge all recent trunk fixes and enhancements into the jsonb branch.drh2023-11-21
|\ | | | | FossilOrigin-Name: 6d78d50ed2357e6c943c1ef97b1d2ea0902cbadef90c2c35dccdbdc2bdf8702f
| * Back out an incorrect change to the sqlite3ExprCompareSkip() function thatdrh2023-11-20
| | | | | | | | | | | | | | was added way back on 2019-08-22 for [44578865fa7baf97|check-in 44578865fa7ba] and which was only today discovered to be incorrect by [forum:/forumpost/45ec3d9788|forum post 45ec3d9788]. FossilOrigin-Name: f5b3eb0fc8936ba274a7654ff6dfa7d4654bd8dbca7f3a5ec1134b0b5260d59d
| * Convert an assert in OP_VCheck into a branch that aborts the opcode, as thisdrh2023-11-20
| | | | | | | | | | | | can happen on some very obscure conditions, as discovered by dbsqlfuzz. Test case in TH3. FossilOrigin-Name: 7946c79567b0ccd3a00d12390e99896d7dc11407d0b52bc39338a16a493f56f6
| * Correct conditional compilation issue seen with MSVC in the Win32 mutex ↵mistachkin2023-11-18
| | | | | | | | | | subsystem. FossilOrigin-Name: 6f8f4bfe607f1405d313bb88a33490621002f63e8c02c980f4c083630ad3a6d2
| * When ENABLE_SETLK is defined, avoid ever blocking on the lock mutex in ↵dan2023-11-18
| | | | | | | | | | os_unix.c when requesting an exclusive lock. FossilOrigin-Name: eb36d475e91bfdbf4a18b6fd9751fbcecf15d960dcd1c00d2d18b5bf1d7503fe
| * Another assertion fault fix, similar to [a9443dbfbe25e588]. dbsqlfuzzdrh2023-11-18
| | | | | | | | | | 2d9af4e94aca188e0092900eec711401c5d51687. FossilOrigin-Name: 3afaeac56dff58db596360bf6f8dca97cb31405f73be8e189e8c0e6a1e5b239d
| * When SQLITE_ENABLE_SETLK_TIMEOUT is defined, use a separate mutex in ↵dan2023-11-17
| |\ | | | | | | | | | | | | os_unix.c for each shm locking slot. FossilOrigin-Name: 64691df980cdf73ddc00aabe15baa6c018e1d76b0e87f55ab33a9348fd5680bd
| | * When SQLITE_ENABLE_SETLK_TIMEOUT is defined, use a separate mutex in ↵dan2023-11-17
| | | | | | | | | | | | | | | os_unix.c for each shm locking slot. FossilOrigin-Name: 4098df9652d90f2d22d5591d915d672c5413471f7916223510ba6fd932bfdd36
| * | Add an assert() to prove the sqlite3_prepare() always either returnsdrh2023-11-17
| |/ | | | | | | | | | | SQLITE_OK or else leaves *ppStmt set to NULL. See [forum:/forumpost/70bb8576c6c084c2|forum post 70bb8576c6c084c2]. FossilOrigin-Name: feadd4024228e578811447c4b2d2b60780ff3d3681f80ca903585aa7b289d758
* | Make edits directly to the JSONB BLOB when the input to json_replace()drh2023-11-21
| | | | | | | | | | is a JSONB. FossilOrigin-Name: d69c6acef54a81f46a97a05d443fe648635b4b70772069d6705ef829b718e985
* | Merge the latest trunk enhancements and fixes into the jsonb branch.drh2023-11-17
|\| | | | | FossilOrigin-Name: 162f0509ef27bcd3ec87629640281a71c773e7c3bbd2cd0df76faf481531e7f1
| * Fix harmless compiler warnings in debugging code.drh2023-11-17
| | | | | | FossilOrigin-Name: ce6a75622ea5bca517bc6613e738aa670c9e1dd863596220eded5c2379c616c7
| * Fix an incorrect assert() associated with ALTER TABLE where an unknowndrh2023-11-17
| | | | | | | | | | | | aggregate function contains an ORDER BY clause. dbsqlfuzz e0900262dadd5c78c2226ad6a435c7f0255be2cd. FossilOrigin-Name: a9443dbfbe25e588b4adddde664ddf482f19f71c704fbf356d49cf3a6135e7fb
| * Changes so that if SQLITE_ENABLE_SETLK_TIMEOUT is defined as 2 instead of 1, ↵dan2023-11-15
| |\ | | | | | | | | | | | | all blocking locks are taken for a single millisecond and the default busy-handler invoked as normal. FossilOrigin-Name: 79e24ec3dd40373bbb93792829b18d9ef40daf19d4606174e36c8e19e61a7529
| | * Passive checkpoints do not use the busy-handler. So, in order to minimize ↵dan2020-06-29
| | | | | | | | | | | | | | | visible changes for legacy applications, do not enable blocking locks for passive checkpoints. FossilOrigin-Name: 9c2b4bdd03716bf492ba85198717f3084ebf187bdb068893bd1ff8662362df89
| | * Change things so that if SQLITE_ENABLE_SETLK_TIMEOUT is defined as 2 instead ↵dan2020-06-29
| | | | | | | | | | | | | | | of 1, all blocking locks are taken for a single millisecond and the default busy-handler invoked as normal. FossilOrigin-Name: ac381e6eb3c9284e65f7aad66d21bee1bca9ef4123684ccaf069b8a6d157a56d
| * | Improvements to the description of sqlite3_errmsg() and sqlite3_errstr().drh2023-11-15
| | | | | | | | | FossilOrigin-Name: fe5cc4169c5348324e863d3e339de94ed01749a3b9c86aa9adc5e3244bd9d033
* | | Both json_remove() jsonb_remove() work on pure JSONB as long as the inputdrh2023-11-15
| | | | | | | | | | | | | | | is JSONB. FossilOrigin-Name: 68d551730be0a3ea9579646ed4836c73554c83ca7f2303b69a18843f1750f1a7
* | | The jsonb_remove() routine now appears to be working.drh2023-11-15
| | | | | | | | | FossilOrigin-Name: e76d48137ea823b7810dc8c3b70eb21adabdd6cfbac36050c85d1375e94be1de
* | | Work toward getting jsonb_remove() to work directly on JSONB blobs.drh2023-11-15
| | | | | | | | | FossilOrigin-Name: a79ff8e58fcaf718a6fb78e145117f1d6d40d133f31e9752bb9c6d484850a27b
* | | Merge all the latest enhancements and fixes from trunk into the jsonb branch.drh2023-11-15
|\| | | | | | | | FossilOrigin-Name: ba91408f4c044feda003ef93784ccefb619f99ab64379ced481ee8e9e890fd41
| * | Add NEVER() to a branch made unreachable by [6f9eed826f5b3d1c].drh2023-11-14
| | | | | | | | | FossilOrigin-Name: 26dcaa34e3521783bde687749d590eca54cecb4bb95ef332a4a6473c4141d052
| * | Fix another obscure problem with nested aggregates. dbsqlfuzz 04408efc51.dan2023-11-14
| | | | | | | | | FossilOrigin-Name: 6f9eed826f5b3d1cb08402925b406a7fe9b54259af1ba5eba92d4d37fbad628a
| * | Extra PRAGMA vdbe_addoptrace output showing when OP_Column gets translateddrh2023-11-14
| | | | | | | | | | | | | | | into OP_Copy due to using a coroutine instead of a cursor. FossilOrigin-Name: eba180e77977acd6f3d4a0e3c99a2ebd4ce2839e9ce30c588929e36d69aa762a
| * | Fix another problem with mixed join types and the RIGHT JOIN ↵dan2023-11-10
| | | | | | | | | | | | | | | strength-reduction optimization. [forum:/forumpost/befdab472d | Forum post befdab472d]. FossilOrigin-Name: f1eae192315335d7e385b0a801a17700a9718d245bda6628518c5df9a1e9d3d6
| * | Additional debugging information on the tree-dump of the BETWEEN operator.drh2023-11-10
| | | | | | | | | FossilOrigin-Name: aca31e49d1d25043769544ccf2a07980c5f162a8eb2486e393bf9d9d1a394a60
| * | Remove an incorrect ALWAYS() that was inserted yesterday [1e039b6eb59c0001].drh2023-11-10
| | | | | | | | | FossilOrigin-Name: 12885e298b9d3f977f1de11a194692dfb5fbb7daeabd958674f884a5575ddd24
* | | Merge recent trunk enhancements and fixes into the jsonb branch.drh2023-11-10
|\| | | | | | | | FossilOrigin-Name: 091a5f058dfe2115fb9213655b34f00bcec80aebb299b571975cfe4ecd5ec206
| * | Ensure 8-byte alignment of data structues in sqlite3_database_file_object().drh2023-11-10
| | | | | | | | | | | | | | | | | | This should have appeared on trunk originally and then be cherry-picked onto the branch. Oh well.... FossilOrigin-Name: ac39800bb2685fa287c7d834faed75f0bc61320ef986de314392d6eadb574d30
| * | Remove a NEVER() from whereAddIndexedExpr() that is reachable if theredrh2023-11-10
| | | | | | | | | | | | | | | is an unknown indexed function in the schema. FossilOrigin-Name: a976b7208ff8603d7353ce9a0bdfba8e681cbb2ed3de6cfb5f0e8b07312ab86f
| * | Fix an obscure problem with the join-strength-reduction optimization that ↵dan2023-11-10
| | | | | | | | | | | | | | | could occur when mixing LEFT and RIGHT joins in the same query. [forum:/forumpost/7f74ce0bee|Forum post 7f74ce0bee]. FossilOrigin-Name: 530d10e93a5f63b71aaa94a2b89102d012a2cda815997066beb0f585fe823536
| * | Add the SQLITE_RESULT_SUBTYPE flag for application-defined functions. Adddrh2023-11-09
| |\ \ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | the -DSQLITE_STRICT_SUBTYPE=1 compile-time option that raises an error if any function invokes sqlite3_result_subtype() without the SQLITE_RESULT_SUBTYPE flag. SQLITE_RESULT_SUBTYPE prevents an indexed value of that function from being used to replace an equivalent expression, since the indexed expression does not carry the subtype. Fix for the problem described at [forum:/forumpost/68d284c86b082c3e|forum post 68d284c86b082c3e]. FossilOrigin-Name: ba789a7804ab96d81b15d6ef6fed1f802fa69db47cf91d368933e55289fa1d6e
| | * | Put an ALWAYS on an true branch.drh2023-11-09
| | | | | | | | | | | | FossilOrigin-Name: 1e039b6eb59c0001a9efdd2f9928a34d4e9e01972ee76aa04a1279369dc03840
| | * | Futher documentation refinements.drh2023-11-09
| | | | | | | | | | | | FossilOrigin-Name: 311c2eba93097bbecfa286bbeaff9bd6fc75a238e20cd2b6f834e594032d8c59
| | * | Fixes: (1) In the ->> function, instead of setting a subtype and clearing it,drh2023-11-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | do not set it in the first place, as doing the set would trigger an error under SQLITE_STRICT_SUBTYPE. (2) Allow the SQLITE_STRICT_SUBTYPE through the property filter on sqlite3_create_function(). FossilOrigin-Name: 6195468b14f6f17ea072cf191c9ef1bd0713acd314bc6dc128be7322bfd612cc
| | * | Add the SQLITE_STRICT_SUBTYPE compile-time option. This change reveals thatdrh2023-11-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | the current SQLITE_RESULT_SUBTYPE design does not work unless we tag the ->> operator with SQLITE_RESULT_SUBTYPE. But that will disable an important optimization. FossilOrigin-Name: e98a9a65dd309f72c240e280c7bebabc58af664fae9ee0d30c3fa1c78db5bae9
| | * | Do not replace expressions that return subtypes with values taken from andrh2023-11-09
| | |\ \ | | | | | | | | | | | | | | | | | | | | index. FossilOrigin-Name: a35d13db09e32ee339f3983fe36b073714753ee3d39f577ae8d20596d7adc3eb
| | | * | Do not cover expressions using an indexed expression if the indexed expressiondrh2023-11-08
| | | | | | | | | | | | | | | | | | | | | | | | | is a function that might set a subtype. FossilOrigin-Name: e908b26a990929996b3c16f0429e8313cd8fcefe7c883c77f66ea69f4059d6e2
| | * | | Omit the new SQLITE_VALUE_SUBTYPE name. Stay with legacy SQLTIE_SUBTYPE.drh2023-11-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Add extra documentation to sqlite3_value_subtype() and sqlite3_result_subtype() indicating that the SQLITE_SUBTYPE and SQLITE_RESULT_SUBTYPE properties are required on functions that use those interfaces. FossilOrigin-Name: 563ad3be60d22c45f1c5b9a3e67738593f8b38f137147c56514166fbabf95365
| | * | | Make a distinction between functions that consume subtypes and functionsdrh2023-11-08
| | |/ / | | | | | | | | | | | | | | | | that generate subtypes. FossilOrigin-Name: 48a92e3ad855227188a4c5afe4abbb7171761cf6fc930660084d9abeecfd91d9
| * | | Fix compilation issue seen with MSVC.mistachkin2023-11-09
| | | | | | | | | | | | FossilOrigin-Name: 0dfe790d8118ff1bacc9e7c97d4f8ff9e5789f6cda8ec6fd981ea38b4da3905d
| * | | JSON5 bug fix: Escape double-quotes that occur inside of single-quoted strings.drh2023-11-09
| |/ / | | | | | | | | | | | | [forum:/forumpost/ddcad3e884|Forum post ddcad3e884]. FossilOrigin-Name: 1c98d46d60ef1494bd8b7561c7d0cd5aafc178201a6f1f0da25dea6140b91cd0
* | | Merge recent trunk enhancements into the jsonb branch, and especially thedrh2023-11-08
|\| | | | | | | | | | | | | | finer-grain characterization of JSON function properties. FossilOrigin-Name: 72393b003f9f8675e4a124dddd09607b5b34ddefe56716b283c68c0982fb3d96
| * | More precise characterization of JSON functions. Indicate when functions mightdrh2023-11-08
| | | | | | | | | | | | | | | return JSON (subtype 'J') and when they make use of the function argument cache. FossilOrigin-Name: b2b62546c4a5e9dccb8aa0cb8eda228d662c69159e320b01a377317bc909e89f
| * | Have the shell tool emit a warning if the user attempts to use ".scanstats ↵dan2023-11-08
| | | | | | | | | | | | | | | vm" in a non-SQLITE_ENABLE_BYTECODE_VTAB build. FossilOrigin-Name: 3978c084a509c3c739fbe87e20feec9ddf1325e35170329987af197ca9fd731a
| * | Avoid blocking as part of passive checkpoint operations, even if ↵dan2023-11-08
| | | | | | | | | | | | | | | SQLITE_ENABLE_SETLK_TIMEOUT is defined. FossilOrigin-Name: e5ecc404cae1ce8b639d0263fa07571c066f11bfc62f5ba331ad7ae138e78572
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-19 04:30:39 +0000