aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Improved version of the previous check-in.drh3 days
| | | FossilOrigin-Name: 036c97e36cb36a2ac765a8e8539433dcb63f69155d4c24857f84faa44eed6eb5
* Fix the optimization of check-in [663f5dd32d9db832] that strives to avoiddrh3 days
| | | | | | | duplicate compuations in the GROUP BY clause so that it works even if the GROUP BY term is a subquery on the RHS of a LEFT JOIN. Problem found by dbsqlfuzz. Test cases in TH3. FossilOrigin-Name: 955a026996b93e530ca5b566689cc646b31d3b9b5a5837897a58452d70f6d942
* Rework the showHelp() function in the CLI implementation so that itsdrh4 days
| | | | | | purpose and operation are well described by the header commit. Omit the use of enums that cause issues for MSVC 2025. FossilOrigin-Name: 336ceeccc6f85bd78f4a26648af7edf9056d569a767b4120f125a02b2090a349
* Back out the "low-quality index" query planner hack of check-indrh5 days
| | | | | | | | [bcac937526d9a6ef]. Subsequent query planner enhancements for dealing with star-queries make that change unnecessary and the change was recently found to cause a performance regression in an unrelated query. Also fix a typo in a debugging message. FossilOrigin-Name: e7dcf25efae364b7cdf9eb8265803c816c8b8557e4a7684da428badc6ffb3875
* First cut at enhancing the fsdir virtual table so that it works withdrh6 days
| | | | | unicode characters on Windows. FossilOrigin-Name: c9e04dadfdf6c860631ce5603693add565ff2033aa25af5736302af7045fc91e
* Omit the unused readdir_r() routine from test_windirent.cdrh6 days
| | | FossilOrigin-Name: f9a216e3ad1b3bc9be350aad5ef3dc8b3534d3ee67d160bfedda81a61295320c
* Provide the SQLITE_BUG_COMPATIBLE_20250510 compile-time option that restoresdrh9 days
| | | | | | the JSON5 bug fixed in the previous check-in, in case some applications need it for legacy compatibility. FossilOrigin-Name: 491cf31904fdbc9567b838d1ba27901e75f8ea3a117043017d08354bb09f9711
* Add enforcement of the obscure JSON5 syntax rule that the \0 escapedrh9 days
| | | | | | sequence must not be followed by a digit. [forum:/forumpost/c061e87faf7d1c55|Forum post c061e87faf]. FossilOrigin-Name: 83c7477f2b9b0d6cb54cf6b14bf3c8ef4807e4bddc7986d275cf6717da8606b7
* Fix PRAGMA trusted_schema=OFF and similar so that it restricts the kindsdrh11 days
| | | | | | | | | of functions in CHECK constraints that the documentation says it does. It was letting through some function that it ought not have. This is a defect in [5720924cb07766cd]. See [forum:/forumpost/3fa9d44c0b381342|forum thread 2025-05-08T08:50Z]. Additional test cases will be added separately. FossilOrigin-Name: 25920beebf71ebc9a1bb9f56932280c9e03390f26fe9da2258f950979b238ce6
* Internal doc typo fix. No code changes.stephan11 days
| | | FossilOrigin-Name: ac2aa39f7e3ae7ac921fac6566186939a1282f80ced5b3e3d5006a77ecf583ff
* Fix a harmless warning about and oversize shift operation on malformed JSONBdrh12 days
| | | | | inputs. [https://issues.oss-fuzz.com/issues/415850463|OSSFuzz 415850463]. FossilOrigin-Name: cf8b55b3b6f0b73158e21731a206d5a8d8d9892989d91171a11c6dbbee34b338
* Fix a bug in the NOT NULL/IS NULL optimization of check-in [cb94350185f555c3]drh13 days
| | | | | | | | | that can cause invalid data to be used for a column if that column has a CHECK constraint that includes the NOT NULL or IS NULL operator. Problem discovered by the [https://issues.chromium.org/issues/415397143|Chromium fuzzer]. Never seen in the wild, as far as anybody knows. FossilOrigin-Name: 2adaee9aa90f280a406007695fbc4a314806584c93d6b62b46c031492b31ec27
* Fix the sqlite3VdbeTypeofColumn() function so that it works correctlydrh13 days
| | | | | even when SQLITE_DEBUG is defined. FossilOrigin-Name: 1d5021533ed688d7a815ce75b338c72f577c14554027f88a21419935a9e68239
* Fix a harmless problem in the CLI in which SQL errors that occur duringdrh2025-04-30
| | | | | | the ".schema" command are properly ignored, yes still appear in the ".log" output. [forum:/forumpost/42fe6520b803be51|Forum post 42fe6520b8] FossilOrigin-Name: 20abf1ec107f942e4527901685d61283c9c2fe7bcefad63dbf5c6cbf050da849
* Fix an issue in Bloom filters on RHS subsqueries to IN operators.drh2025-04-30
| | | | | | | See [forum:/forumpost/792a09cb3df9e69f|forum post 792a09cb3d] for a description of the problem. Also improve comments related to [baa83b460c677c21] which was origin of the problem. FossilOrigin-Name: cdef486e212fe4b26605065d9cff08f608cb80df48ee64e4be63637769bdfacc
* Fix an off-by-one error in an assert(), discovered by oss-fuzz. This is adrh2025-04-25
| | | | | | harmless error in as much as assert()s are disabled in production builds, and because the off-by-one only occurs on nonsensical CREATE INDEX statements. FossilOrigin-Name: 3e627d66ebdef8dfe41bd12a0474d1afca9f50051771774679d25bd1833e69ae
* Remove an extra conditional that was inserted earlier today and whichdrh2025-04-21
| | | | | is unreachable. FossilOrigin-Name: 5ea56af2d27611c5a8ea275316d21a02e70032f93243549ae776e9a89edc6229
* Further improvements to the decision of whether or not a BLOB inputdrh2025-04-21
| | | | | is JSONB. FossilOrigin-Name: 6538813cb89f6109727481e29633e2e98f98e0257c58695e3b53e8ce237d9195
* Do a better job of providing bug compatibility with SQLite 3.44.0. Seedrh2025-04-21
| | | | | [forum:/forumpost/07e206fcd6|forum thread 07e206fcd6] for background. FossilOrigin-Name: 614d061b32c3bdf4825323d6f8e8a98624e4eeeb96dd442d8e365527122ed3bc
* When logging errors using sqlite3_log() and the error text includes thedrh2025-04-17
| | | | | | | text of an SQL statement, but the SQL statement text at the end so that if the error message buffer overflows it is the SQL statement text that gets truncated, not the statement of the problem. FossilOrigin-Name: de0968226effb79f9d25539da7882fa5475e4ff2410870b45a63a6545deb5979
* Increase the size of the output buffer for sqlite3_log().drh2025-04-17
| | | FossilOrigin-Name: a64e8491c9863f890daa9f5d8f678728dc0d00bc1f3c238b50214ec545450fcf
* Attempt to provide EBCDIC translations to the tables in the JSONdrh2025-04-16
| | | | | | | implementation. The SQLite developers do not have access to any computers using EBCDIC and so have no way to test this patch, and cannot vouch for its accuracy. FossilOrigin-Name: 84e698f38429c142caaa66ac086410f2035691b2ad39ad2fc4e0ebc31dd58a5b
* Correctly handle the case of a multi-column UNIQUE constraint that containsdrh2025-04-15
| | | | | | | | the ROWID as one of it columns, and then the columns of that UNIQUE are used in a row-value IN operator as a WHERE clause constraint. Reported by [forum:/forumpost/b9647a113b465950|forum post b9647a113b]. Problem introduced by [723f1be3d4a905a6], part of ticket [da78413751863]. FossilOrigin-Name: d22475b81c4e26ccc50f3b5626d43b32f7a2de34e5a764539554665bdda735d5
* Fix a minor typo in a code comment.drh2025-04-15
| | | FossilOrigin-Name: 158e8c4fd7bdfc1cd4c0135abecd0d00994cd4027cf74ce6e5cf73d76475ae95
* Improved estimate on the number of output rows in a recursive common table ↵drh2025-04-14
| | | | | | | | expression that uses the UNION operator. Follow-up to [f911f1c4977fbcae] and it's output row estimate changes associated with DISTINCT queries. FossilOrigin-Name: 92513f6bce7ecc778e78af3a77bc66ff65585fffa2e3138f8acb9e617121eeb0
* Fix an obscure problem allowing the propagate-constants optimization to ↵dan2025-04-10
| | | | | improperly substitute a column of a sub-query with NONE affinity. FossilOrigin-Name: d82725dcaec7437f37fc15dfb492b51a4f9dbbbcaea04e387d9471b7d291cde2
* Remove unnecessary "www." prefixes on domain names in URLs.drh2025-04-10
| | | FossilOrigin-Name: 20acd630b91609725794ce84f9eda01d5f3c898407f0948264830851d25ccaa6
* Remove an incorrect ALWAYS() macro. ↵drh2025-04-08
| | | | | [forum:/forumpost/23875495059357a2|Forum post 2025-04-08T19:16:42Z]. FossilOrigin-Name: 062cca9c63ef6d7b9a525df69391e9b032284703aeb45a18c728305dd5957c43
* Fix a harmless code typo introduced by [b57e3c3db00a6bc6] and reported bydrh2025-04-06
| | | | | [forum:/forumpost/09957d8b2a|forum post 09957d8b2a]. FossilOrigin-Name: f3a6cdb89b13bc173cfce9526f836600469b0242fe62b8f92f8747896d7d47bb
* The win32lock and win32longpath tests don't work on Cygwinjan.nijtmans2025-04-04
| | | FossilOrigin-Name: 32ef3f26e7fb34dfdb23617a19bb9baa2e4c3dca564a88850b58a0fbe6446cf8
* Fix a typo accidently added to the prior check-in.drh2025-04-01
| | | FossilOrigin-Name: fb2f283038f9329b6f791d92d6f943269f24f1a0efd5859165b63f517ed52ddb
* This is an experimental optimization that attempts to keep a JSONB valuedrh2025-04-01
| | | | | | | | the same size (same number of bytes) after doing a replace of an elements with a slightly smaller element, by denormalizing the size field. This can perhaps avoid unnecessary page updates and memmove() operations when making small changes in the middle of a large JSONB value. FossilOrigin-Name: b5de9584b7f49586c5387d8a74af5e41dba50f1817a54257bf9da00deb695f72
* Fix a harmless typo in a code comment.drh2025-03-31
| | | FossilOrigin-Name: dd251377bd1a8e95a4a0179c50595f290b08ea93659f4906f88f5a9dff534aa1
* Minor shell-internal doc addition. No functional changes.stephan2025-03-29
| | | FossilOrigin-Name: 01b99c8a2819469568f369479c097cc8e3ed1f2478958460755b283dc7d11706
* CLI shell: make (.output off) an alias for (.output /dev/null) or (.output ↵stephan2025-03-28
| | | | | nul), depending on the platform. Discussed in [forum:633979ce307f1cc6|forum post 633979ce307f1cc6]. FossilOrigin-Name: 0f11087b84753576425823e10a7eeff45af02f3c0135dee72dec5019c8127500
*-. Merge cygwin and tclsqlite fixes into trunk.drh2025-03-27
|\ \ | | | | | | FossilOrigin-Name: 121f4d97f9a855131859d342bc2ade5f8c34ba7732029ae156d02cec7cb6dd85
| | * Fix for forum-post [/forum/forumpost/b5fde3596c|b5fde3596c]. Also fix ↵jan.nijtmans2025-03-27
| |/ |/| | | | | | | | | | | encoding issue for non-ASCII characters. Also includes a fix from Stephan Beal, about a missing <stdint.h> include. FossilOrigin-Name: e60198001e12f85a5d6504ce72226dfceb8666fe5ec649237fa23ae20e8aa32d
| * Merge trunk. Some additional test-fixes for Cygwinjan.nijtmans2025-03-27
| |\ | |/ |/| FossilOrigin-Name: b36adadfa202fb8951149561471c3e01085d31e1837c99806f308f234cd24a8e
| * Merge trunk into cygwin-fixes branch. Add .fossil-settings/binary-glob to ↵stephan2025-03-26
| |\ | | | | | | | | | | | | squelch warnings about *.db files on Cygwin. FossilOrigin-Name: a8328b921c5504eceacade417e16e713999eff63978caf3418fd79501590b1cb
| * \ Merge trunk into the cygwin-fixes branch.stephan2025-03-19
| |\ \ | | | | | | | | FossilOrigin-Name: 34eadd374b3c0a8c9e1f5f4a1c60fda8f16b1c56213b8c4047f96390c676b695
| * | | Document that sqlite_update_hook() can unset the current hook by passing a ↵stephan2025-03-12
| | | | | | | | | | | | | | | | | | | | NULL callback, to address [forum:652aef4747|forum post 652aef4747]. FossilOrigin-Name: 2b582c0097e3374beb280dfa6b03e0dacb9911da1bceb0dce0468e6b7291e74f
| * | | Merge trunk into the cygwin-fixes branch.stephan2025-03-10
| |\ \ \ | | | | | | | | | | FossilOrigin-Name: f3d14433f24f89558e72a9085c950bc72440e9933d6b4ff59d6e603d25e39422
| * | | | Patch an unnecessary size_t-to-int conversion which warns on some compilers.stephan2025-03-10
| | | | | | | | | | | | | | | FossilOrigin-Name: 8681dfdb59d3258663ec176daafd7a52446a207db21fbd1a4d151508092dcbc5
| * | | | Reimplement pathname conversion on Cygwin. MSC test passes/failures are on ↵stephan2025-03-10
| | | | | | | | | | | | | | | | | | | | | | | | | par with trunk and 'make test' running on cygwin is down to a single failure. FossilOrigin-Name: 57a4de09149663ac001848773c9dffe53e30f9263e4dacc792a0267401147d25
| * | | | Test app/script patches from Jan Nijtmans for cygwin. Add/replace many more ↵stephan2025-03-08
| | | | | | | | | | | | | | | | | | | | | | | | | sentinel arguments for TCL variadic functions which specifically need a NULL trailing argument. With this, 'make test' on cygwin runs to completion for me, with 134 of 329227 tests failing. MSC build fails the same 13 tests which fail for me in trunk. FossilOrigin-Name: 84d8fcfca19cd183d05a702d0eb1742bfae462d3383a3db72741a48cefac1058
| * | | | os_win.c patches for Cygwin (described in the cygwin-fixes branch wiki ↵stephan2025-03-07
| | | | | | | | | | | | | | | | | | | | | | | | | page). Makefile.msc's test target on trunk fails the same 13 tests as this branch. FossilOrigin-Name: 655c60d1926adb552d37441bf9857263eae92e3806a8524e8443b81fdfd8c258
| * | | | Merge trunk into the cygwin-fixes branch (which was inadvertently branched ↵stephan2025-03-06
| |\ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | too early). FossilOrigin-Name: a7863b2e2fbea0ea11c494016b99921f70aae09607868aa65af988cbd173b31a
| * | | | | Cygwin-centric fixes from Jan Nijtmans.stephan2025-03-06
| | | | | | | | | | | | | | | | | | FossilOrigin-Name: 205979813c7300debb5f1ba270583ef2f08e069d6d01865b5910702889a5c1ed
* | | | | | Fix an off-by-one bug in the ".dbtotxt" command from the shell that resultsdrh2025-03-27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | in incorrect output. FossilOrigin-Name: 2345094e879c5538bfea005785ce0848e6d565a49bcb48b323c258d00ccbe9b8
* | | | | | On winOpen(), redo the read-only test on every retry attempt. Justdrh2025-03-26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | don't retry the winAccess() call. FossilOrigin-Name: ccdd67ad9a508530ccfcec582410768c24bca4eb8b05939577fb99a50dd44b15