database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
32,669 Commits 1,785 Branches 392 Tags
static-sql
Commit Graph

32669 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
41b5ded8d0 Refactor: Name change to "query result formatter" or "QRF". Simplify names. 
put all the code into its own subdirectory of ext/

FossilOrigin-Name: 8646a2ee224819cf459989aa03bd1b9e1a77fc1f8bee8fd45dba778c63467d61
 2025-10-22 12:33:59 +00:00
drh
22f8a84fda Simplify the interface to use just a single API. 
FossilOrigin-Name: 82dc13ec4887f90995bd984ede9c2670fb7512962ccceb1848a7e9aab7891c00
 2025-10-22 12:09:50 +00:00
drh
984e446891 Adjust some of the markdown in the LICENSE.md file so that it will hopefully 
work better on GitHub.

FossilOrigin-Name: 773f9d3dcf1ac7a9ce7f0911f46301f3e0e01d699f73a264cab692299a8d615e
 2025-10-22 00:38:28 +00:00
drh
ce3d809d62 Simplify the set of formatting choices. 
FossilOrigin-Name: 1f364ea3c08badd555a9ce70bb96cb8f862d6cc6425e9ff41da228fdd2f29361
 2025-10-21 20:10:44 +00:00
drh
dcd722d204 Add TCL and JSON output formatting. Add the ability to test the xRender. 
FossilOrigin-Name: 1a28eae74ed354d556f5ba45c716b03ff36d26b8a6729a5428d7895d8337af78
 2025-10-21 19:56:13 +00:00
drh
15a064807f Text quoting formats CSV and HTML. 
FossilOrigin-Name: ea69f1f81f867fe058889effdc128e8cc358b61b9121c1932bba8895bd709adb
 2025-10-21 19:03:27 +00:00
stephan
774ce0ba43 Back out [b144f875d6bddce6] and remove the former check for strchrnul() from the configure script. 
FossilOrigin-Name: f4e059b2243c6db37b4dd201b03f0c1916baec5e9e1a660815fcd7eeaf530367
 2025-10-21 16:15:53 +00:00
drh
8e544ca512 Add separate quoting style for BLOB values. 
FossilOrigin-Name: dfe537175e7d15507e8532817a06f76dc375c7eb00f5cdc4b4f8d71ec516137e
 2025-10-21 15:30:38 +00:00
drh
8c8bd1969c Control-character escaping 
FossilOrigin-Name: fbb69764559f4333890860f4f3c010efa9cc994a82743766b948e7635fd079e8
 2025-10-21 13:07:51 +00:00
drh
861cb4c0b4 Recognize the various quoting styles and escape modes in the resfmt-test 
program.

FossilOrigin-Name: 3ee2a8775fcc557a53c36240ddc039024ff52e21d9ad9021d7cf5bf79f8b9ed4
 2025-10-21 11:00:04 +00:00
drh
6e334ef616 More capabilities being added. Incremental check-in. 
FossilOrigin-Name: 9adaf791f88875c5afeba7e7aa72efb59df42c6052898f8d7e2f83aede00a044
 2025-10-20 19:55:26 +00:00
drh
a1f32824e2 Add test program for resfmt.c. Now compiles and runs. 
FossilOrigin-Name: 7aaaeea319c7165284028ff8cf1b3448a818c5029de02e7199614bb45aa304c5
 2025-10-20 17:19:30 +00:00
drh
5b5b35f6d6 Notes on the result-formatter utility. None of the code works. These 
are just ideas I have jotted down as I try to figure out how to do this.

FossilOrigin-Name: c38f1c63247804486a6b368ead4c5122adaedd5c697487fadbed49e1acb155bc
 2025-10-20 14:28:57 +00:00
drh
a0b13abd34 Merge recent trunk enhancements into the resfmt branch. 
FossilOrigin-Name: 20c79a2cc1f9eedea12cbac0a657301614d042e3487ddf37cd4b0316e6f84f21
 2025-10-20 10:55:01 +00:00
drh
d41f5ef7e6 Reduce the maximum size of LIKE and GLOB patterns in the ossfuzz.c test 
module to avoid false-positive infinite loop reports from OSS-Fuzz based
on long and complex fuzzer-generated LIKE/GLOB patterns that are not actually
infinite loops, but which do take a long time to resolve.

FossilOrigin-Name: 53edea286b0a38f4f9c7017276f3a826037919144d517f8c89ef0f35b65af5f1
 2025-10-19 17:30:07 +00:00
drh
efe8ae567c Use 64-bit memory allocations everywhere in the expert extension. 
FossilOrigin-Name: 6caf793b8f406f5089e3811591bc69384646df16ee18d63bd63760eaaa95d122
 2025-10-18 11:19:02 +00:00
drh
21c57abc53 Increase the range of integer indexes in the the merge() family of 
SQL functions.

FossilOrigin-Name: 8d3943890ef3b533df35c4784c2a42c52503a4d9c3dbe67241510d8b70669b48
 2025-10-18 11:04:03 +00:00
drh
31c86ca0a8 Fix a minor memory leak in the CLI that can occur following an error 
in the ".output" dot-command.

FossilOrigin-Name: d1044bc0616fd20c63ca3b627ad0a116256870a082a72da26f98fb0f59ca44fd
 2025-10-17 10:06:44 +00:00
stephan
9f36870a77 Resolve the MacOS-specific build issue reported in [forum:95edc7a8d7d1de59|forum post 95edc7a8d7d1de59], with help from Bo Lindbergh. 
FossilOrigin-Name: b144f875d6bddce62e8f2ad42bfe5dfa6c2434f2ef3edb86847fb4c23aa46814
 2025-10-16 23:42:39 +00:00
dan
9c3fcd932d Improve performance of the shell tool ".ar" command when it is given a large number of arguments. 
FossilOrigin-Name: 8fed9de84bce01e88e0e8237e245c0ff9fe9f46394c603887e360658f5ef1ac1
 2025-10-16 14:17:30 +00:00
drh
0a585a64d2 In dbpage.c, disable truncation on any update error, including errors 
in sqlite3PagerWrite().

FossilOrigin-Name: eee5ba5d8a9d01000345185731c531eb84d3cb8e81bf429506c449d962aad843
 2025-10-16 12:43:36 +00:00
stephan
6eaeea0a3b Fix an off-by-one in c-pp-lite.c which could cause @token@-processed output to get one duplicated byte. 
FossilOrigin-Name: aa2f4c51604f4d4286c8a1ec7eaa6251892471e32087af695712513ee620ea46
 2025-10-16 01:44:03 +00:00
stephan
e826aa8e00 Minor JS doc updates. No code changes. 
FossilOrigin-Name: fc2a026901b1a12526b92fff36d7acc226e554c9f351e6261c7ffd4887bcc337
 2025-10-15 23:28:31 +00:00
stephan
ff5d4c348c Resolve a valgrind-reported error in ext/wasm/c-pp-lite.c caused by successful exit colliding with the atexit() handler. Add -e SCRIPT support to c-pp-lite to facilitate testing. 
FossilOrigin-Name: 7801c7225a18ccb2216b01663b30e3eb90a961e3d165af73f964c515b74fe745
 2025-10-15 23:13:50 +00:00
dan
f66a0600d8 Improve performance of the shell tool ".ar" command when it is given a large number of arguments. 
FossilOrigin-Name: 0398897067ca5cdedfef0ce7a034ba6d5a2ce6104605ef4ed1c7549499435b44
 2025-10-15 15:54:38 +00:00
drh
34c1e04cbf Fix memory allocation in the ".table" command of the .cli when the number 
of tables in the database file approaches 2 billion.

FossilOrigin-Name: 5cbccab499bc3983aac1f57355552db607dee6c7ef4eb00d794dbee89c18db70
 2025-10-15 10:52:45 +00:00
drh
f83df5b150 Reestablish APIARMOR for the sqlite3_db_status() interface. 
FossilOrigin-Name: 1738f0bdf5941a70684c82d2040561e53a272595026a837a9f9bab8508a46480
 2025-10-14 19:21:46 +00:00
stephan
d6cb2ccee6 JS/WASM: Expose sqlite3_db_status64(), sqlite3changeset_apply_v3(), sqlite3changeset_apply_v3_strm(), and SQLITE_DBSTATUS_TEMPBUF_SPILL. 
FossilOrigin-Name: b13eafc9b6820517b450041a7e2be573a896b5b9e88b2b28df9f15e3cb91e23d
 2025-10-14 18:23:32 +00:00
drh
e7cf3fe4c8 Add the test/testloadext.c loadable extension to test the ability to use 
the latest APIs using the loadable extension mechanism.

FossilOrigin-Name: a9bd7ed6f77c5e53f9130eac7eb999c662e9158fb229a462d29f18653284d6d0
 2025-10-14 17:50:55 +00:00
drh
efde2f6059 Add the sqlite3_db_status64() interface and the 
SQLITE_DBSTATUS_TEMPSTORE_SPILL option for use in that interface.

FossilOrigin-Name: 9f8739ddea6ec6d8890d0e8f6a0143773a008e4f96bd02a48d4bfebb3f9b72fe
 2025-10-14 17:09:06 +00:00
drh
53a6b7d138 Make the new sqlite3_db_status64() API accessible to extensions. 
FossilOrigin-Name: 2ebd7330312f3ee4674c343b7a19b703f1f89611a6846a0e2be39867f9895522
 2025-10-14 16:57:50 +00:00
stephan
4472c967a6 Fix two links in ext/wasm/README.md. 
FossilOrigin-Name: 0f96eaeaa8c51c20f8d389bfd6d0d6371e8bb29ff7e8eaf3a0bcb35cb2b73338
 2025-10-14 14:07:58 +00:00
drh
abe709be8d Extra defenses against integer overflow in the decimal extension. 
FossilOrigin-Name: 1a7414d9b5be7ce18b23c357fd98cd0e96d78ac626abfa6e4e0dee494b6a1efc
 2025-10-14 14:03:09 +00:00
stephan
5dbbe50758 Add a section to ext/wasm/README.md about the dependency on wabt/wasm-strip for release builds. 
FossilOrigin-Name: 0dbb13863b3ff1da1be664967ac05c79cf34f7a78def05fe4f6407c06cb4322a
 2025-10-14 13:47:40 +00:00
stephan
9f136fc5ed Fix a makefile typo which caused a build directory to not get mkdir'd for the fiddle build. 
FossilOrigin-Name: d98d5abf6d27c5359ff8c797ad57394b96074e47010bc4c24120ba69a967dc3c
 2025-10-14 13:25:02 +00:00
drh
898ac77f55 Merge all the latest trunk enhancements into the dbstatus-spill branch. 
FossilOrigin-Name: 55f2613c1bacddb05902d4d5dac3d2b49b91053e6249dd926bb953c763eafeb0
 2025-10-14 11:18:45 +00:00
dan
264bcad69a Avoid integer overflows (a) when dealing with zeroblob(N) calls when 2*N is larger than 2^31, and (b) in fts5 when a corrupt record is close to 2^31 bytes in size. Both of these require special builds with SQLITE_MAX_LENGTH set to a non-default value. 
FossilOrigin-Name: 27927519696dcb78ff72e245158ea6d33a1b2c3d4da314d4d0283c47d847c3da
 2025-10-13 16:07:28 +00:00
drh
a8bb50ce95 Fix a bug in concat_ws() in which an initial empty string was treated as if 
it was a NULL value.

FossilOrigin-Name: eb2e4e46171c12f59aa5d571eeb310534360b110c3e7bda6eaf68f0e25546264
 2025-10-13 12:36:54 +00:00
drh
c93270ebc7 Enable CLI documentation for .imposter 
FossilOrigin-Name: c639c7be029f86defe6cb8cef094e1126ec8ab3968e12d4d2bf6e6ab23c39821
 2025-10-13 10:35:59 +00:00
drh
94356039d0 Fix broken hyperlinks in the documentation. 
FossilOrigin-Name: 62e6b120c43cd855349bf1b40ad2fb992e31a6e2567e5b145cf1849445849da7
 2025-10-12 19:17:31 +00:00
drh
ee4676b3f7 Fix order of operations in the OP_Concat operator of the byte-code engine 
to avoid any possibility of an integer overflow.

FossilOrigin-Name: 765e6569824ccc34292d6df16a6cd682e6503f20adebe0a43cd2118d69072a63
 2025-10-12 10:31:34 +00:00
drh
e4eaf174a5 Remove an unused variable from the generate_series implementation. 
FossilOrigin-Name: a523e4adbf8e60ea8c3351f33aff793c6e425c594038e8578d12564bf47aac03
 2025-10-11 18:44:54 +00:00
dan
59e1ab5576 Fix an assert() that could fail when reading a blob or text value larger than 1GiB from the database (requires a non-default build configuration). This is an assert() fix only, production builds were functioning correctly. 
FossilOrigin-Name: 3e5ec5731f0c8c5f7da357c63d315aae5a2aca5c1b3567bc8c9386ccc2a798cf
 2025-10-11 16:23:22 +00:00
drh
11878165f6 Improvements to the (rarely used) home-grown varients of seriesCeil() 
and seriesFloor() based on ideas from
[forum:/forumpost/2025-10-11T12:36:56z|forum post 2025-10-11T12:36:56z].

FossilOrigin-Name: e6b9bfdb6f8f86d4d2891d65fee4274dcbc61c9e998d81f90232153c05788cab
 2025-10-11 15:45:47 +00:00
drh
5013fd1f81 Provide alternative implementations of ceil() and floor() to the 
generate_series() function so that it will build even when SQLite is
compiled using --disable-math.
[forum:/forumpost/91690fa646|Forum post 91690fa646].

FossilOrigin-Name: 97d6fd2c99578adb6a1e9b879ba5ae5ad798a8ef8f0646bf0102747d52148bff
 2025-10-10 19:43:03 +00:00
dan
eeb2e03b7b Back out [8bf26c956e]. It is not required following [8e7da8cf50]. 
FossilOrigin-Name: ea29180797aa4bb25180432e75a372277a6f6e2262906a9e765a3bddf8ca79d7
 2025-10-10 16:04:19 +00:00
drh
80f0fcd31d Fix harmless compiler warnings. 
FossilOrigin-Name: 4966d7a1ce42af8b1c50fdd40e651e80d0eeb8cb62dd882950cab275f98aba88
 2025-10-10 14:31:46 +00:00
drh
8c1670642d Makefile updates to suppose carray() and percentile(). Add Carray to 
the CLI and fuzzcheck to support debugging.

FossilOrigin-Name: fe9cf68b513d1e8cfcde90f1982a7f4123f54e3ebb004d961a99bdf6bec03a32
 2025-10-10 14:22:05 +00:00
stephan
e33786f09a Regenerate autoconf/Makefile.msc to squelch a 'make test' warning. 
FossilOrigin-Name: f7f55dce184c433b7774ab569caaeae5994c63421de01e9ea36aa1dbecb2d579
 2025-10-10 14:00:27 +00:00
drh
f9d511319b Fix the carrayfault.test script so that it works in configurations that 
do not support virtual tables.

FossilOrigin-Name: 767a667b91caff2e789179231f13a0d260c9837020c0ce1553b86e88cf9aa352
 2025-10-10 13:43:53 +00:00