database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
32,770 Commits 1,782 Branches 392 Tags
vtab-savepoint
Commit Graph

130 Commits

Author SHA1 Message Date
drh
7697c7d2b9 Fix QRF so that it correctly handles zero-length output appended to 
the sqlite3_qrf_spec.pzOutput result.
[bugs:/info/2026-10-20T13:22:11Z|/info/2026-10-20T13:22:11Z]

FossilOrigin-Name: ee344fc063ec0de8f1cd4c61c88eca33c2587c52d868202db3c514f0bc2fae52
 2026-10-20 14:36:09 +00:00
drh
154360f1cd Fix a regression in the CLI's handling of control characters in CSV output, 
caused by [d0fe92e0ce8662b9].
[bugs:/info/2026-10-18T20:38:57Z|Bug 2026-10-18T20:38:57Z].

FossilOrigin-Name: 2146eab561d153b70eb41c54bb122ea8d2dc0ad983f00639aa2f65fd3a64e603
 2026-10-19 19:15:13 +00:00
drh
853288469d The default floating point format for JSON and INSERT output modes 
should be "%!0.17" to preserve full binary→text→binary round-trips
with no loss of precision.
[bugs:/info/2026-10-18T20:37:23Z|Bug 2026-10-18T20:37:23Z].

FossilOrigin-Name: c31221e954bcca2e6505338446635d0efb809f453008c4927441ebd6f0e1b873
 2026-10-19 14:34:34 +00:00
drh
8e1b59b6dc Enhance QRF to deal with zero-length column names. 
Also make use of the new sqlite3_str_free() interface.
[bugs:/info/2026-10-17T09:26:21Z|Bug 2026-10-17T09:26:21Z]

FossilOrigin-Name: d3e004fe3daeb01085e969890beb56fe71839bcad0e7a19e1690a1b2d14b2775
 2026-10-17 11:13:08 +00:00
drh
e8cbe2c96a In QRF, add the zero-pad flag to the default floating-point format in 
output modes that render JSON or INSERT, so that infinities are shown
as 9e999 or similar instead of as "Inf".
[bugs:/info/2026-10-04T05:35:43Z|Bug 2026-10-04T05:35:43Z]

FossilOrigin-Name: f63139ba68bc7df770bbd3c26bcd760c479889fb45fa921e9e225e38c9e2044c
 2026-10-04 16:23:01 +00:00
drh
9da2d2374a The --escape mode for CSV should default to "off". 
[bugs:/info/2026-09-23T16:25:07Z|Bug 2026-09-23T16:25:07Z]

FossilOrigin-Name: c356641fadf591bcf312ae9657ddc84e483a06aa068eb2d3021467435cbad0c1
 2026-09-23 21:04:57 +00:00
drh
112122c2f9 Avoid a possible NULL pointer dereference in the QRF sublibrary when 
compiled with SQLITE_ENABLE_STMT_SCANSTATUS.

FossilOrigin-Name: 58014b2a2efdf0800946591d2d53d1c001a9b58681156dc201aa542912567570
 2026-08-25 18:26:40 +00:00
drh
3d18207a6f Fix typos. Turn off -fpfmt and -ifmt using "auto" instead of "default". 
FossilOrigin-Name: 530b55da56326f4816d43893d05f57b10541605a9508b0b37c46df21ecd22b76
 2026-08-15 12:22:31 +00:00
drh
c799c15dbe Refactor "realfmt"→"fpfmt" and "intfmt"→"ifmt". 
FossilOrigin-Name: 17277813d101187d85755b7bad3f1c95380335021e13ee368be0add0c8c346b3
 2026-08-15 10:10:17 +00:00
drh
753df3d91a Remove redundant offsetof definition from qrf.c. 
FossilOrigin-Name: 5d230cafc6abf48dd623385df106e61fa5bf15a9cff855eb27680aa0f7533c8b
 2026-08-14 18:49:42 +00:00
drh
6f23a689c1 We don't actually need to increment the version number of QRF as 
version 2 has not yet been released.  Updates to the QRF README.md
file.

FossilOrigin-Name: 3ccc25a06fd247da0ffd273c331ad992334d7e397e32a625dabe155eb37425f3
 2026-08-14 16:58:20 +00:00
drh
a6a26aa3f5 Fix an off-by-one bug in --intfmt. Add some test cases. 
FossilOrigin-Name: 4e86fc1922e347825e1160652a2d5e6c60d04eabe847621b08f03b05b66904ea
 2026-08-14 16:34:00 +00:00
drh
d1e066bf3f Initial code for an enhancement to QRF that allows for app-defined format 
strings used to render integer and floating-point values.

FossilOrigin-Name: 067083e973b195f50fa0d199e24a3b01d1b2780a0812fda63d3747c4c75662bf
 2026-08-14 15:57:32 +00:00
drh
7193cc9c08 Adjust QRF to generate lower-case HTML output with the SQLITE_STYLE_Html 
style setting.

FossilOrigin-Name: 4be8630e053de91fb03c960d792960e837cf6360d5d24fbae4fc97b8fcaef062
 2026-07-14 17:02:47 +00:00
drh
3d0c7ce2aa Change the CLI so that the default "--title" is "always" instead of "on" 
for some display modes.  This check-in also include a fix to "--title always"
for the "markdown" display mode.

FossilOrigin-Name: c3b0fff1b76b8c354b34fef17ff639968698e97234d6ab7af15e0e1a835486e9
 2026-07-07 14:53:53 +00:00
drh
cdbb701776 Fix a problem with --rowcount found by Claude in code review. 
FossilOrigin-Name: bc5fb05aa6e8c819cb2c45ea96538b82b5b9c21058ddf685e84d50b183656578
 2026-07-07 13:16:30 +00:00
drh
9c202c32c1 Improved title separator in QRF when using "-title always" on an empty row. 
Improved comments on the mode matrix in the CLI code.  Additional test
cases.

FossilOrigin-Name: a102d28fca6376da670b274d3d733da2c73da9abe3e7128defd04b4015b03a48
 2026-07-07 12:24:50 +00:00
drh
dc4cb53863 Show --rowcount for "--style insert". New test cases. 
FossilOrigin-Name: 386c40e3a9706111542b7f336e82f7bb6e9f43c6056185f9f3bd9aae1159070a
 2026-07-07 11:00:10 +00:00
drh
0fe9987880 Continuing work on --rowcount and --title always. 
FossilOrigin-Name: adeb4fbb86a8a781d7efb0eecb9c84ce605d0bd45f63992bf2ecd60765a60d2c
 2026-07-07 00:23:38 +00:00
drh
8e409df984 Add new option "bRowCount" to QRF. Add QRF_Always as a possibility for 
bTitles.  Use these feature to enhance ".mode psql" to be a better
approximation of what psql actually does.

FossilOrigin-Name: 600c6b464050078b38cc688668148f684243e7c5f08d0aae4d5f72aa6f985482
 2026-07-06 19:24:15 +00:00
drh
2315f282be Fix QRF so that it works sensibly with "--wrap 1" 
FossilOrigin-Name: 48f950b2a1ef841d915ca733baf324a1af98e644b660f238dd5018015340a6c6
 2026-05-26 13:54:57 +00:00
drh
5554aa27e6 Fix HTML ">" quoting in QRF. 
[bugs:/forumpost/f72dfbdeff|Bug f72dfbdeff].

FossilOrigin-Name: 5cee1097b47d850989ebecdb9d2c814e6968240fe3bacb5598ca85067cb95692
 2026-05-25 23:44:37 +00:00
drh
02dc8d0c5f Harden the QRF extension against integer overflow problems. 
FossilOrigin-Name: 83d3a0d39b0b36a47003206d390935d4c94f7a906ada02f69e0ad1eef2f22d59
 2026-05-14 13:29:59 +00:00
drh
13b63ed930 In QRF, relax the constraint on the screen width so that it can be as 
wide as a 32-bit signed integer can count.
[forum:/forumpost/2570051b60|Forum post 2570051b60].

FossilOrigin-Name: 91439d95dc81adebf8226f2b7c33ca62a4b7163cfc14e03993524aa17b5767f3
 2026-05-14 12:46:41 +00:00
drh
5c6404aa77 Fix a integer type bug in the previous check-in. 
FossilOrigin-Name: 5e1b5ff1c170e94956bf77bd38afcad6369cb9f9333864711212af045281ad0e
 2026-04-22 13:41:20 +00:00
drh
429369f4aa QRF and the CLI preserve zero bytes when outputing unformatted BLOB values. 
FossilOrigin-Name: dbc1d6f0a3452607e4e92155df0fdb1c5ea4ea5ad1654664f86383faf6c105ef
 2026-04-22 12:22:32 +00:00
drh
9529894a29 Fix harmless compiler warning in QRF. 
FossilOrigin-Name: dcfb505ac7762f7a3102e1c3853a83dca1d1ef436cc8981949b63c7d7992cc5b
 2026-04-21 22:19:38 +00:00
drh
92c435cda7 Improve defenses in QRF against trying to run the same prepared statement 
twice, concurrently.

FossilOrigin-Name: 6ab6f622be3e1ad93166d139b5fccf9628c86d1c14c6dfb4464cb8cf52c94785
 2026-04-10 18:14:33 +00:00
stephan
0d979c217f Fix a few doc typos and inconsistencies. No code changes. 
FossilOrigin-Name: 025abd4cf409fb9938e116289f23dc5bcd6d14feb46066221e691b146ee9b354
 2026-04-07 15:54:35 +00:00
drh
606c64a543 Fix redundant typedef in qrf.c when that file is amalgamated into 
tclsqlite3.c.

FossilOrigin-Name: b8f0c71b48953cb6d5a8b3d33d004a31b63c59d59d455f285bf8fa91c3b07129
 2026-04-07 11:31:41 +00:00
stephan
eefe3aa9ad Replace a doc reference to a renamed file, as reported by [forum:5d9d70c618|forum post 5d9d70c618]. No code changes. 
FossilOrigin-Name: c8121593fa455cd43b3878f8b65ebac47c07dab4b8ce081aa34b14fc9440afbc
 2026-04-07 09:15:21 +00:00
drh
3c1f727603 Because version 3.52.0 was withdrawn, that means QRF has never been 
officially released.  Hence the new nMultiInsert field of the spec
can be moved out of the extensions area and into the main part of the
spec, and the version number can drop back from 2 to 1.

FossilOrigin-Name: cf19982241afb17e3db4148b8257f6737141935a291c340ab085c42ed946af1a
 2026-03-21 19:49:38 +00:00
drh
c739d13217 Fix harmless compiler warnings. 
FossilOrigin-Name: d7b4a4a3d3d6296a012cc14fc2d95fe810b5bdb625209a2d28bf2c7a026749bf
 2026-03-10 22:43:39 +00:00
drh
abc82c49c2 Revamp the QRF insert-mode optimization of [659ff6ab55802507]. The 
control value is now nMultiInsert.  Multiple rows are added to each INSERT
statement until the number of bytes in that statement exceeds the
nMultiInsert value.  The CLI uses a default value of 3000, which provides
a good balance between speed and prepare-statement size.  The output
from ".dump" now loads nearly 2x faster in some cases.

FossilOrigin-Name: 55b0ce9f93d68b17a18423f0f751b778573127743a2bac67abfea074ac32d41a
 2026-03-10 18:13:13 +00:00
drh
efa8633fd8 Enhance QRF with the mxTuple field, which if greater than 1 causes the 
QRF_STYLE_Insert style to group as many as mxTuple adjacent rows into
a single INSERT statement.  The field is accessible using the -mxtuple
option in the TCL interface, and the --mxtuple option in ".mode".  The
output of the ".dump" and ".fullschema" commands responds to the current
--mxtuple setting.

FossilOrigin-Name: 659ff6ab5580250707908af003ecd093bd5313f03f21f0efd000a7aff6638b3c
 2026-03-10 14:02:03 +00:00
drh
e795890d7e In QRF, fix line-wrap indentation for "line" mode when using a 
non-standard column separator.

FossilOrigin-Name: 00c96cca3de709e40207feb9c10a94e38e7857c9bc01938849c6c5daee7148c7
 2026-03-09 13:53:58 +00:00
drh
7fa89ea907 Change some sqlite3_realloc() calls into sqlite3_realloc64(). 
FossilOrigin-Name: a391f5646926787fd9a004225ea406b61d20f282c852c0282fd26cada644b601
 2026-03-02 15:06:59 +00:00
drh
7d9fbe6476 Fix an off-by-one error in the indentation of multi-line outputs in 
QRF_STYLE_Line mode.

FossilOrigin-Name: d47499b21c893cc8749a1cafe1cf712dacfeaa6cfe2cdb75d1fc450f3cb6879f
 2026-02-27 13:25:42 +00:00
drh
d0c4a5853b Display scanstatus results in neat columns. 
FossilOrigin-Name: c476d956d0bd3065cf894de6f9d393b999ff7d2268a35f01a6d88804789ab58f
 2026-02-04 20:51:27 +00:00
drh
c9ccd27045 Improved display of scan-status estimates. 
FossilOrigin-Name: 70ef095740c62081090147bb1900c843cb31864e93a8af518ff48855f1175717
 2026-02-04 17:52:50 +00:00
drh
5e842d0ece Render scan-status values with 3 or 4 significant digits only, for 
improved readability.

FossilOrigin-Name: d9102ff0c43a496e782b0a3ec86ba7cd45f8118a07f15a4f3d58b399466d6cf2
 2026-02-04 13:35:32 +00:00
drh
3fab5d2a40 Fix scanstatus output in QRF so that it shows the total number of cycles 
on the "QUERY PLAN" line.

FossilOrigin-Name: 611cef0ec281ae06eac97df8048d617fd445c348c2fc1673202b9cc081a365db
 2026-02-04 11:51:20 +00:00
drh
03c0ac435e Enhance QRF so that it terminates more quickly if it encounters an OOM 
or oversize string error, and fix it so that it reports such errors.

FossilOrigin-Name: ebedeb6169cc3bc3708130d4061065af600a8851e896fc3eeaf33c8c83fe3b95
 2026-01-07 16:19:18 +00:00
drh
22546e1d7e Clarify the affect of nCharLimit, nLineLimit, and nTitleLimit on the 
xRender output from QRF.

FossilOrigin-Name: 881534858de8bccffca53e7256a725378a98a354e792374d972b120880c2ae78
 2025-12-15 13:58:41 +00:00
drh
63f1fb40be Fix an inaccuracy in the qrfRelaxable() routine in QRF when the input is 
an empty string.

FossilOrigin-Name: eb8a519571f7d35b81cbdbe668da45b33e5505d9a038305129df7ba2c16fd3b0
 2025-12-12 10:21:52 +00:00
drh
85fb541ac0 Various improvements to the .mode command of the CLI, and especially to how 
it handles the --limits option.

FossilOrigin-Name: f883b854976d2aa679c87edce3b577f38b5fa518f707706320d1ddb38365e2dd
 2025-12-10 19:04:49 +00:00
drh
1debc25ef8 Test cases and documentation tweaks. 
FossilOrigin-Name: cc9e47a205883aedf24b5e85e8e0499567f514780e3e6ec58069a39ea6270133
 2025-12-10 15:50:23 +00:00
drh
9bf37cc3eb Add the nTitleLimit option to QRF. Also change "line" style so that it 
uses zColumnSep as the divider between the title and the value.

FossilOrigin-Name: d67a299c86ff80ed67857d2546b0edaf852cb23dbfbc15e24793d1c4860a2e50
 2025-12-10 15:24:46 +00:00
drh
1241fe1450 Minor tweaks to the QRF documentation. No changes to code. 
FossilOrigin-Name: b2517d01e65b34ea4ca52c9149d7b255a36a45a50b332cb8ccfdacf22e629be2
 2025-12-07 18:19:22 +00:00
drh
4ccd61107f Fix typos and harmless compiler warnings. Omit the use of ctypes.h in QRF. 
FossilOrigin-Name: 4f7edadbdeeb4baee2e4a4703def6e258ce00f54684343b73380e7c69165892e
 2025-12-06 11:50:36 +00:00