aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* | | | | 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
* | | | | | | | | | Further attempted improvements at fast-fail for an inaccessibledrh2025-03-26
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | database file. FossilOrigin-Name: cdeb21a312d4f1a9e3009a0baf0af33857c172f7bc22bca047dcd46a03e9c964
* | | | | | | | | | Attempt to reduce the amount of retry time when trying to opendrh2025-03-26
| |_|_|_|/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | an inaccessible database file on Windows. See [forum:/forumpost/e7991420f54dca50|forum thread e7991420f5] FossilOrigin-Name: 986e45912cde7cb8e6db8ba7a9364aef7187a23032be64ef6cd573163f56676d
* | | | | | | | | Clarify and reduce redundancy in an assert() in walChecksumBytes().drh2025-03-24
| | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 3c53abf5e6df446d569040042363265737aa10fc8aaa20b31c587100c557c5e7
* | | | | | | | | Teach the CLI that VT100-escape codes that do things like change fontdrh2025-03-21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | colors have zero-width for the purpose of laying out the columns of a table. FossilOrigin-Name: 2d0a8a6c38981552748ff5fc2eeba86590e0f116abac260a7fc9318de0a0dbda
* | | | | | | | | Fix a problem in the sqlite_dbpage() table-valued function when it isdrh2025-03-20
| |_|_|/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | trying to truncate a file in locking-mode=EXCLUSIVE and the file was obtained via sqlite3_deserialize(). Problem found by dbsqlfuzz. FossilOrigin-Name: 346cf9794c6ce82ac32f7ccabc67240309306626709951593720abd198b103e3
* | | | | | | | Fix a problem that could occur when the RHS of an IN operator was a compound ↵dan2025-03-18
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SELECT featuring an ORDER BY on a subquery that was flattened into one of the component SELECTs introduced by [baa83b460c677c21]. Forum post [/forumpost/1e17219c88]. FossilOrigin-Name: 7101ccd5331e36fd1a539f540e79ce0ce159be76ec422e1d9436eec6f3908c6e
* | | | | | | | Fix alignment problems on Linux with -m32 and on Mac PPC.drh2025-03-15
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 8a91aeca60548d5cd19add128cf65b9c3815c9103b1ef8ff6bc02711b6d709de
* | | | | | | | Use flexible arrays for RTREE.drh2025-03-14
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 2b41776179c726586e3ff836edcf235938cf02f7c5e33c1d6954b84d4061b8d5
* | | | | | | | KeyInfo is now an indeterminate size, so we cannot declare a variable of thatdrh2025-03-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | type, only a pointer to an instance of that type. FossilOrigin-Name: 37b687dc2d3b9dc82ed09a9c5b2c00e576b1eebe358a20d18a3da190347b644e
* | | | | | | | Make use of the flexible-array feature of C99, when available, to try todrh2025-03-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | pacify -fsanitize=strict-bounds. This check-in fixes the core. There is more yet to do in FTS3, RTREE, and in FTS5. FossilOrigin-Name: 6fd6b32d06bd6a705e5140cd613af823b8183a6f6a9ceeeedfcf5e8b50821d68
* | | | | | | | Fix an internal doc typo reported in [forum:e25e581f917|forum post e25e581f917].stephan2025-03-14
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: fa6f6ccdffc50024624306900efd2538c7415d8bdd0f02835b2e9c05adab3cf1
* | | | | | | | Cherrypick the [2b582c0097e33] doc addition, which was initially committed ↵stephan2025-03-14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | to the wrong branch. FossilOrigin-Name: f786de8d1873cd27b1bf83273a1e100e9d481144674888ccf65974e003a3caad
* | | | | | | | The --echo flag on the CLI also echos dot-commands provided on the command-line.drh2025-03-12
| | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 6ec0c03b954cf705da076d035a1cc2e784233ae28857385379e44a59af6c5ec4
* | | | | | | | Ensure that the TEMP database has been initialized at the beginning ofdrh2025-03-10
| |_|/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | a call to sqlite3_open_blob() for the TEMP database. Fix for the issue reported by [forum:/forumpost/0a556d619b|forum post 0a556d619b]. FossilOrigin-Name: 2cfccdbe08b7b14a6b255f7157ac20d0807327adefcb33fcffeeed14c7603fe1
* | | | | | | Disable the [d1ba200234f40b84|count-of-view optimization] if any subquerydrh2025-03-10
| |/ / / / / |/| | | | | | | | | | | | | | | | | | | | | | | | | | | | | is DISTINCT, as the optimization does not work in that case. Bug reported by [forum/forumpost/a860f5fb2e|forum post a860f5fb2e]. FossilOrigin-Name: d7013b63932b2f5750572ae6bdd259a2b6e6548c20fb9a5559edd22d2f2fc6cb
* | | | | | Various typo fixes reported by Daniel Dumitriu. No functional changes.stephan2025-03-06
|/ / / / / | | | | | | | | | | FossilOrigin-Name: 37e6ec777445d8ef81acecbb66f86ae78f2ae67ef0bfd3fbd089da51fff35cc9
* | | | | Additional 'array index is signed char' warning cleanups for the shell and ↵stephan2025-03-06
| | | | | | | | | | | | | | | | | | | | | | | | | its embedded extensions, analog to [44bd44532d]. FossilOrigin-Name: f31042595b8f8a378db9778c9a8223b07ec02cf2f528581ba43bf72b5b03c964
* | | | | Have the recover module add "PRAGMA foreign_keys = off" to SQL output. Have ↵dan2025-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | the shell tool add ".dbconfig defensive off". FossilOrigin-Name: dcfe3d3292851aa48a085a2c68623b049e2786c8dc7154ccc78508443973b5a1
* | | | | Always ignore comments in the schema of a database, even ifdrh2025-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | SQLITE_DBCONFIG_ENABLE_COMMENTS is turned off. FossilOrigin-Name: 373ae3f4de526c636c35db03d6b5c84526d6f144c1c3bebcbb257e52f563a203
* | | | | Use AtomicRead() and AtomicWrite() to access the pcache1_g.bUnderPressuredrh2025-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | global, to forestall unnecessary angst from thread analyzers. FossilOrigin-Name: 41ec85637a7fac710a3986ee78ed25a96d331a03653069bae4d9f826cc6f944a
* | | | | Improvement output for ".schema --indent" in the CLI when the schema containsdrh2025-03-05
| | | | | | | | | | | | | | | | | | | | | | | | | partial indexes with long and complicated WHERE clauses. FossilOrigin-Name: defd7187ff8c4388f8b5467ed168462ec48215a1f4263bc4128b8e4d89a0bb2a
* | | | | tclsqlite3 patch from Christian Werner: replace FILE handles with TCL ↵stephan2025-03-04
| | | | | | | | | | | | | | | | | | | | | | | | | channels for the db copy command. FossilOrigin-Name: ea1f7f8de4abb80fe41a115c9f601ff27cd728493640c6d47d868913feec28dc
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-19 07:01:02 +0000