aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| * Avoid creating a co-routine incrementally for a VALUES clause that has ↵dan2024-03-13
| | | | | | | | | | affinities other than NONE. FossilOrigin-Name: 4229b12b327b05561dcf49b8585a66467d17d4e998b14eff65eb886f2434b53c
| * Correctly initialize the SrcItem.iCursor field to -1 when creating a ↵dan2024-03-12
| | | | | | | | | | co-routine from a multi-values VALUES clause. FossilOrigin-Name: c32953ff6d72910815eaff29ab1b790c412e1a741d02c03c5911dda0c08e5130
| * Attempt to reduce the memory used by VALUES clauses in as many statements as ↵dan2024-03-11
| | | | | | | | | | possible, not just INSERT. This branch still has problems. FossilOrigin-Name: 17d1f7cfabc7593d0725051b0c7c9619a23a482265f30f15ab9493fef5caeeb0
| * Fix the ".import" command in the CLI so that it works correctly with tablesdrh2024-03-11
| | | | | | | | | | | | that contain computed columns. [forum:/forumpost/ca014d7358|forum post ca014d7358]. FossilOrigin-Name: 95a9c88b258f18ac671a4c712603931167cc8bd0b86e41481b200c08043338b5
| * Fix the .expert command in the shell so that it does not leak memory if notdrh2024-03-09
| | | | | | | | | | followed by SQL and so that it works with reverse_unordered_selects. FossilOrigin-Name: 7ead022edaf7a0cd6a8976a1261246084975c9a5be5c893f6c751bb5f963ac0f
| * The NOT NULL strength reduction optimization from [de9c86c9e4cdb34f] shoulddrh2024-03-08
| | | | | | | | | | | | | | | | be applied to the WHERE clause only. Otherwise, the operand of the IS NULL or IS NOT NULL operator might be a reference to a bare column of an aggregate table, and we can't tell if it is NULL or not based only on its NOT NULL attribute. [forum:/forumpost/440f2a2f17|Forum post 440f2a2f17]. FossilOrigin-Name: 51704feae224eff601db5607f8651da11b3c2ed8a58ffe5b6ee8260cab50695b
| * One of the assert()s added by the previous check-in was not quite correct.drh2024-03-08
| | | | | | | | | | This commit fixes it. FossilOrigin-Name: d401358329f5a70f9a0b9b033609a4db2af89b83c6b40242be0c76f3d6474def
| * Add new assert() statements, which if they had existed three years ago,drh2024-03-08
| | | | | | | | | | would have detected the code generator problem fixed by the previous check-in. FossilOrigin-Name: 166d1e5d26ef88e995f44182144891f60bd51c1aa585b4a148f01a920b2a8eea
| * Silently ignore redundant ON CONFLICT clauses in an UPSERT. Only the firstdrh2024-03-08
| | | | | | | | | | | | | | ON CONFLICT for each index is active. Do not issue an error, since that might break legacy queries. But ignore the redundant ON CONFLICT clauses to prevent problems such as described in [forum:/forumpost/919c6579c8|forum post 919c6579c8]. FossilOrigin-Name: d0ea6b6ba64dba9d68c2b391ccf1171ea96fcdd7409dafdb2b697accb00246b8
| * Do not allow the query planner to be tricked into thinking that an index on adrh2024-03-07
| | | | | | | | | | | | | | constant expression might be useful for something. Problem reported on [forum:/forumpost/ecdfc02339|forum post ecdfc02339]. This is a follow-up to the fixes at [44200596aa943963] and [2d2b91cc0f6fed8c]. FossilOrigin-Name: 720ce06d93a9e4cc25c34c873c82165d8801f208c22701e51538f3210de84f65
| * Add the json_pretty() SQL function.drh2024-03-06
| |\ | | | | | | FossilOrigin-Name: ceb51c1cc36dfb78db8f2be042a0d74ab9a877d14a53dadf876d09e1a0616d6a
| | * Add the json_pretty(J) function for pretty-printing of JSON. An optionaldrh2024-03-06
| | | | | | | | | | | | | | | | | | 2nd argument is text used for indentation, with a default value being four spaces. FossilOrigin-Name: 39552bd36c06fe9ee346cb71e0659baceccde031b67c0974f2dd14eb11ebc055
| * | Work around obscure floating point issue seen with older versions of MSVC.mistachkin2024-03-06
| |/ | | | | FossilOrigin-Name: 42d39f9140cc315df04b048f3811311fa50b51e1831d6cdf982fbce029778e43
| * Remove code that added a P4 parameter to the OP_Variable opcode. This is no ↵dan2024-03-05
| | | | | | | | | | longer required. FossilOrigin-Name: dd5977c9a8a418be3fbd646d74933996381099a9263a02eb4a990f0084463dc1
| * Reformulate [34439fe3aeea7cbb] slightly to resolve a false-positive OOM ↵stephan2024-03-05
| | | | | | | | | | reported in [forum:2eadfe94e3|forum post 2eadfe94e3]. FossilOrigin-Name: 8290646792bc5411112b0c01dc5ac0837743056a7679725ee2edefef2e10d146
| * The value returned by the json_each.json field needs to survive longer thandrh2024-03-05
| | | | | | | | | | | | the json_each virtual table itself, in the event that the value is used in an aggregate expression. dbsqlfuzz 5120bd0b3bb0b73eebbcb79ac37c6b0663fccad6 FossilOrigin-Name: 952ed71b9b61e79fe807ac3134bdfa7c94a415e02f13f94440a34d6d548d171e
| * /fiddle: before resetting a db, roll back any transactions (resolves problem ↵stephan2024-03-05
| | | | | | | | | | reported in [forum:0b41a25d65|forum post 0b41a25d65]) and remove an obsolete/broken reference to a long-gone API which could cause initialization to fail prematurely. FossilOrigin-Name: ee164ca73cf4151b1a1bf351729afa9b0ec95bd5004a5d5bfce3ed46268bfbf3
| * Fix a compiler warning in date.c. Update makefiles to include all necessarydrh2024-03-04
| | | | | | | | | | dependencies for building shell.c. FossilOrigin-Name: 178b7d46f9c8e1694ed6f506d2785a9f5c49e2b428e04c8096d557cc1b5c9680
| * Adjust date/time functions so that they do a better job of keeping trackdrh2024-03-04
| | | | | | | | | | | | | | | | | | | | of whether the current time is UTC or localtime, and no-op the 'utc' and 'localtime' modifiers accordingly. See [forum:/info/e7a939e074|forum post e7a939e074]. Also add the datedebug() function, available only under -DSQLITE_DEBUG, for improved visibility of the DateTime object during debugging and testing. FossilOrigin-Name: dc569683748354a6db83438904422e802d3ea780775c48da85b474fff03ca8a1
| * Fix assert() statements in date/time computations: The month and day numbersdrh2024-03-04
| | | | | | | | | | can be zero if an error has been seen. FossilOrigin-Name: fc773f6c76ec114be8b6e25b13885acb5adcc9d052dca0d8d0ff94e2a0743d64
| * Back out the previous change. Replace it with new date modifiers "ceiling"drh2024-03-03
| | | | | | | | | | and "floor". FossilOrigin-Name: f0831cced2c919e409214d936c81473ae321a98c5bd78b5b729c1269bf71bc45
| * Change the magic time-interval names that do truncate-to-same-month to bedrh2024-03-02
| | | | | | | | | | "mnth" and "yr" - "month" and "year" without the vowels. FossilOrigin-Name: 296b46c529d79385d7f4db2c789254a992c01ff66fe8ba6d3a3ce4aaac0203fb
| * Proof-of-concept for new time-interval operator "pg-month" and "pg-year" thatdrh2024-03-02
| | | | | | | | | | | | use the truncate-to-month algorithm for month overflow instead of the wrap-to-next-month algorithm that is used by SQLite by default. FossilOrigin-Name: b606c0965788f56547435c9318b60e32990877e14a9640d887f33f39d1bdc7c3
| * Add in a VdbeCoverage() macro needed by STAT4 that should have been part ofdrh2024-02-28
| | | | | | | | | | check-in [63ef234e88857a65]. FossilOrigin-Name: d51c699ae413215d534f954c129691ef5d95d540dc5d4304cbba576c976d931c
| * Always convert 32-bit integer literals into EP_IntValue notation, even ifdrh2024-02-28
| | | | | | | | | | they contain "_" separators. FossilOrigin-Name: 2dfc427f676255cbe189a26bfec2405d41d31ccc4512c55b31e6e633261d7a23
| * Fix an eputf() macro without its argument in the CLI.drh2024-02-27
| | | | | | FossilOrigin-Name: c2f5e257d2cfb91341f5261ed3924dc4ec2a6f854f3692fb416043f5c654a963
| * Add an assert() to help scan-build recognize that a variable is initialized.drh2024-02-27
| | | | | | FossilOrigin-Name: 10d26f1ee8e7624cbb957332b4397d2f1fcdaf916acec93077f2ddd33e01f1d8
| * Adjust a VdbeCoverage() macro in PRAGMA integrity_check to account for thedrh2024-02-27
| | | | | | | | | | fact that arguments to the OP_Eq opcode used are never NULL. FossilOrigin-Name: 759ccea3f6e21493c0153f884b601988efd59e409b113b28f8cf23f59a74e418
| * Remove unreachable branches from the PRAGMA integrity_check enhancement ofdrh2024-02-27
| | | | | | | | | | [b736519d3d2e93c7]. FossilOrigin-Name: 6d02fb233fb86f9907cc374d06a7ed71a638091d6e75abc199001c42eab51e5c
| * Ensure memory cells are properly freed before they are overwritten by ↵dan2024-02-27
| | | | | | | | | | OP_IntegrityCk. FossilOrigin-Name: e50acaf934f44f8833bc588e0ae1abd59df907b9a42d4cafd5518427a8c7b627
| * Have "PRAGMA quick_check" compare the number of entries in tables and indexes.dan2024-02-27
| |\ | | | | | | FossilOrigin-Name: b736519d3d2e93c76fa36253143f2664b9dd12e26acba555f0bf9c4d44705499
| | * Have "PRAGMA quick_check" compare the number of entries in tables and indexes.dan2024-02-02
| | | | | | | | | FossilOrigin-Name: cc294c041b4c7a044ff344989f872415ced5263a0b654112371b2da7c852a688
| * | Allow "_" characters to appear between any two digits in an integer, real or ↵dan2024-02-27
| |\ \ | | | | | | | | | | | | | | | | hexadecimal SQL literal. FossilOrigin-Name: 0e6700f43f133510c8049b2c5a2610cb3be29da7ed4d39b1fa65dc22c4cf529b
| | * | Add extra checks for the validity of a numeric literal to ↵dan2024-01-23
| | | | | | | | | | | | | | | | | | | | sqlite3DequoteNumber(). FossilOrigin-Name: d57407ef59baf699b72c8c4859abfaa7977dd41f6f16eb8fe1d53a68806eb966
| | * | Fix a problem in the previous commit with hex literals that start with "0X" ↵dan2024-01-22
| | | | | | | | | | | | | | | | | | | | instead of "0x". FossilOrigin-Name: c063c89b11487e6e712b97de604db316fa97bcf91ed810bb2dcbbcb54c68dbf4
| | * | Allow underscores to occur in hex literals.dan2024-01-22
| | | | | | | | | | | | FossilOrigin-Name: 81a56229460cc5b6acfd3c3729fcf89ea3cccb546ca2b4f4035b140c60911e18
| | * | Add extra tests for the code on this branch.dan2024-01-22
| | | | | | | | | | | | FossilOrigin-Name: b15bbb201a7727806b9fd6c02f2579b01e0e38155a8f9e24c5d6f487fe3e8b6c
| | * | Do not allow digit separators that are not surrounded on both sides by digits.drh2024-01-22
| | | | | | | | | | | | FossilOrigin-Name: 5bbc378a3022e2013048c8e296d95de21d15a8d7c1b62e8ffb64782f952cfe12
| | * | Merge trunk changes into this branch.dan2024-01-20
| | |\ \ | | | | | | | | | | FossilOrigin-Name: 03ade4a810516ff84bc5c1a716b0e454cc8a89374100415ff21a82449112811b
| | * | | Add test cases for the new code on this branch.dan2024-01-20
| | | | | | | | | | | | | | | FossilOrigin-Name: 49f29a7b4f44f691ecf7a57b26477971e6ffaf2a0b1690b4926ffbb43fa3929b
| | * | | Allow "_" characters to appear following any digit in an integer or real SQL ↵dan2024-01-20
| | | | | | | | | | | | | | | | | | | | | | | | | literal. FossilOrigin-Name: 401650aaccbc99246bd4e1ff37a28b78f528178aee2f294d87b9f7fecd7432bb
| * | | | The quote() SQL function should convert +Inf into 9.0e+999 and -Inf intodrh2024-02-26
| | | | | | | | | | | | | | | | | | | | | | | | | -9.0e+999. See [forum:/forumpost/6675b25108|forum post 6675b25108]. FossilOrigin-Name: 85dd79a6edecfc8c6307c6d215998f76dab086aa14528ddc64eb9955501becfd
| * | | | When inserting a 3-byte cell into a btree, ensure that the extra padding bytedrh2024-02-26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | is 0x00. This is not necessary for security, as far as I can tell, but it seems like a reasonable precaution. FossilOrigin-Name: 5766f1279dab91e030d4dcf5133659e5cedf914a1628ccf00d67d8e50a9957fd
| * | | | Add the intck extension. For performing incremental integrity-check on a ↵dan2024-02-26
| |\ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | database. FossilOrigin-Name: 141d8bb059f8987d05d18327b97c4d36e98258f657b41a3d4d8877fe8b4e72e3
| | * \ \ \ Merge latest trunk changes into this branch.dan2024-02-26
| | |\ \ \ \ | | | | | | | | | | | | | | FossilOrigin-Name: b6371ff9f5c3d4e87a5b1127a82970202f74c790b828dda20df88dd727bcc9b4
| | * | | | | Add the ".intck ?STEPS_PER_UNLOCK?" command to the shell tool.dan2024-02-23
| | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: cfd051836b72f7d4e38cc9614f6ae5c003de4ce377359fd391adf06fe1ddf6b9
| | * | | | | Merge trunk changes into this branch.dan2024-02-21
| | |\ \ \ \ \ | | | | | | | | | | | | | | | | FossilOrigin-Name: 63e8846ac1dc1cf1f7071c4634ccbfec3c13560db6afec376cd91515b62430d3
| | * | | | | | Consider using "=" and IS operators with even low-quality indexes in cases ↵dan2024-02-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | where they are selected explicitly using an INDEXED BY clause. FossilOrigin-Name: 43cbbea82132db2d0ddb4f34cc2b6910b3a1243ae6d4e837b1b27bfe91b84834
| | * | | | | | Add start of extension for incremental integrity-checks to ext/intck/.dan2024-02-17
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 444e3c9210026da7eae1ed98850722e002433aa2cc77dbc6b6f80327a6b7a390
| * | | | | | | Remove a local variable from sqlite3IntFloatCompare() that was being optimizeddrh2024-02-26
| | |_|/ / / / | |/| | | | | | | | | | | | | | | | | | | | | | | | | | out anyhow, in order to get back to 100% MC/DC. FossilOrigin-Name: 52b13d6acbb738b9281f7dd44edd6c3c9585d22d98b1951b7059534fbd16fac0
generated by cgit v1.2.3 (git 2.25.1) at 2025-05-26 02:49:01 +0000