database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
29,798 Commits 1,570 Branches 183 Tags
tclsqlite-db-copy-fix
Commit Graph

19141 Commits

Author SHA1 Message Date
drh
92e71573ce Remove all use of the "long double" data type from SQLite, as hardware support 
for long double is increasingly rare and the use of long double creates
challenges for some compilers.

FossilOrigin-Name: 761d8fd18b0ee8681b12998f01a2eca1b796807a5174a1270cfb9bdc841424ac
 2024-10-02 13:26:17 +00:00
dan
512ad53f3a Merge latest trunk changes into this branch. 
FossilOrigin-Name: 2b3945e6a597e6853cac567052e92926c8cb6d7a029ac64c2d45c321bbe2e94d
 2024-10-02 11:11:29 +00:00
dan
f9d1141a3b Update docs for sqlite3_snapshot_get(). 
FossilOrigin-Name: 78c3892ab777a39406da8a9df84d0634397514e25512b0363a13bff3b8bc8925
 2024-10-02 11:11:00 +00:00
drh
e8b2c92240 Remove all code that makes use of the C-language "long double" datatype. 
FossilOrigin-Name: f622b52024c8bec1d241b1dc480fbbd839fc1af50b6220f012812503de2c656e
 2024-10-01 20:29:43 +00:00
drh
7151010919 New #ifdefs to omit code that is unused when SQLITE_USE_LONG DOUBLE is defined. 
FossilOrigin-Name: 98066e2d226e7d2eceec1931a1432baea956f49bf3c708d8a6d511fa4e864ca3
 2024-10-01 19:10:47 +00:00
drh
dac22f6566 Add compile-time option -DSQLITE_USE_LONG_DOUBLE=0 to omit all attempts to use 
"long double".  Or =1 to omit attempts to use the Dekker algorithms to achieve
high-resolution floating point.

FossilOrigin-Name: ca5964ef70efad3332e0bf9c158eb5fd5006d3022051d1ac506c097c427735a1
 2024-10-01 16:55:30 +00:00
drh
cacef23082 Fix the character width tables for the CLI such that all unicode code-points 
less than 0x300 have a width of 1.  This is in fact the case for Mac, Ubuntu,
and Windows.

FossilOrigin-Name: f0c5a86fefecded07e098e1326dd54c72504b0bb480f710e395d4041a322dfcb
 2024-09-30 18:19:38 +00:00
drh
54fd01c4ab Fix the CLI so that the --bom option only outputs a single BOM, not two. 
FossilOrigin-Name: 76b6331e6a705a420a64820a18214f07cf4c1d5151e7158d6fff09964e63f352
 2024-09-28 19:52:38 +00:00
drh
c94e4a7b2f Fix a harmless compiler warning in the CLI. 
FossilOrigin-Name: 27ef1909bb0c4d9470c6074b40500632c68341127a079a3eb3b6a19dbfb2aeac
 2024-09-26 22:25:13 +00:00
drh
74194f14ec Add the ext/misc/sqlite3_stdio.c portability interface and incorporate it 
into the CLI, sqldiff, and sqlite3_analyzer.  Enhance the CLI with the new
".www" dot-command and related options on .once and .output.

FossilOrigin-Name: f97f9944b829a49da12786f934da0a5ad51591afd6d8a19a4a0835f51bbdbff2
 2024-09-26 19:38:34 +00:00
drh
2b041fb97a Provide SQLITE_U8TEXT_ONLY and SQLITE_U8TEXT_STDIO compile-time options 
to the sqlite3_stdio.c module.

FossilOrigin-Name: f31588520e3f45b50dcaa9eecab17f52ebb56bb53d0f9bdb88cc596d1a156353
 2024-09-26 19:16:20 +00:00
stephan
2c77d51dfe Resolve a harmless compiler warning in QNX builds. 
FossilOrigin-Name: 2916460179c6089375188c6e4e3cff1fca5bbbbb7280a10c919e09e75d1f11f8
 2024-09-26 18:13:10 +00:00
dan
d0720eee5e When possible, avoid taking wal file read-lock 0 in sqlite3_snapshot_get(). 
FossilOrigin-Name: 34b6ac3d76dbc6819778ec2a0f81cbcdcc0cd1a6303381d97f1c479e4ecdd132
 2024-09-26 18:02:17 +00:00
drh
2fb055366d Clarification of the meaning of the nByte parameter to sqlite3_prepare(). 
Comment and documentation change only - no changes to the code.

FossilOrigin-Name: 92d71eee4f3a5edb3877c108d14972d80654982b0de3e635d9d008e9d3b6591f
 2024-09-26 13:12:19 +00:00
drh
66b3ed318b Always show HTML table headers in ".www" output mode. 
FossilOrigin-Name: 660ca5ce6600d897cc2b00b9d39e5d993c1c0e71ec0d5dc706246c053a163281
 2024-09-25 16:11:27 +00:00
drh
878db7b099 Add the --plain option to the ".www" dot-command. 
FossilOrigin-Name: a9209519f612e66cfe11c89e70efd8285a0185ac0d3e5795846aafbd05d7a21f
 2024-09-25 15:55:52 +00:00
drh
95f35b64da Redirect timer output just like any other text. 
FossilOrigin-Name: 3b5ae21074958788b23ccf449e52fbbad1f81779e07a6ca62ad8395f88a37286
 2024-09-25 14:09:47 +00:00
drh
62d96919f6 Improvements to ".www" and ".output -w" so that text that is not part of 
query output is shown using <pre>.

FossilOrigin-Name: f8ef65c52305b2180ec56760f5762ac5638584cd504c79d57e86f61736901aa4
 2024-09-25 13:56:05 +00:00
drh
2a9254cf2c Add the "www" output mode that include <table> in the HTML output. 
Add the ".www" command and the "-w" option to ".once".

FossilOrigin-Name: b06fd9e6bcce09f12c994dc34f329a8d267ea0601bb07c9b00903c5017d55d42
 2024-09-25 13:29:03 +00:00
drh
9e59c06fb1 Always include a UTF-8 BOM at the beginning of the output CSV when using 
the ".excel" command on Windows, as the actual Excel program requires the
BOM in order to work correctly.

FossilOrigin-Name: 04727fc00207325a76a5d5f20549c00232810ac727dedb70bc9e8112e60b3f56
 2024-09-25 12:56:44 +00:00
drh
853520ddbf Fix stray fputs() calls in the CLI. 
FossilOrigin-Name: 1ee3fa0f0e87a61b5700abd56547c4acefe999317b0d53d66d890d9e09d8b7d9
 2024-09-25 11:38:00 +00:00
drh
38b4158aba Use sqlite3_fgets() instead of fgetc() to end the startup debugging pause 
in the CLI.

FossilOrigin-Name: 869b3c05e852a797b5801a81d30a1f7955c31afad0274327f7af2284b555f23a
 2024-09-25 11:27:59 +00:00
drh
8f1f9ef09f Merge trunk enhancements, and especially the zero- and double-width character 
processing for columnar outputs into the cli-stdlib branch.

FossilOrigin-Name: d6262a4bcd7b0334b23ae4d194ca2bce7c6554ee6c678666b24c830e4c14a467
 2024-09-25 09:43:05 +00:00
drh
8cd30e3f5b In the CLI, for columnar output formats, try to account for the presence of 
zero-width and double-width characters in the output and adjust column widths
accordingly.

FossilOrigin-Name: 9592b9ba3ad7a842cdd4c4010da278485a6fdec7e811bda01ebe640162a8c3b6
 2024-09-25 09:39:11 +00:00
drh
f4382b2415 Improvements to comments on data structures and subroutines. 
FossilOrigin-Name: b217e3004b58af0e777726bdd652b999ad41815261299ef4ce8f8d2f6b0afe8d
 2024-09-25 09:33:14 +00:00
drh
18e2ace468 Fix over-length lines in the shell source code. 
FossilOrigin-Name: f3fdf76a0d3abeb5202f2b6f26318815396da7df680073955bde60b13f84e797
 2024-09-24 19:47:12 +00:00
drh
697c3fb25b Fix error messages in the shell. 
FossilOrigin-Name: aeef82e974c24071e3211588001a92c7f122fbaf02d9dcf7fa5aaf30d2729f64
 2024-09-24 19:19:53 +00:00
drh
63558eae54 Get fiddle working again on this branch. 
FossilOrigin-Name: 0f228317c6ea1388d82df46f44c166b2aa9be63361ff9b81569ebee63c930f2e
 2024-09-24 18:01:50 +00:00
drh
0be2dd9a1b Get output redirection working again in the CLI. 
FossilOrigin-Name: 086034c3508d95e4f620c5e0580fae770e85410b0c8bd94f600fc0fd25088947
 2024-09-24 16:09:50 +00:00
drh
57b32ef924 Add the sqlite3_stdio.h library for Windows console I/O. 
FossilOrigin-Name: fcd0ecffc9889f8c855ea340f075ec42cdca482df82d6e67dc9c32613e8d5846
 2024-09-24 13:46:32 +00:00
drh
4e34558f1b Use _wfopen() instead of fopen() on Windows in the CLI. 
FossilOrigin-Name: 21a8cac5e9a0d5ead29ca1114be7520d182348f7e2e2e2416852b827d7e09f21
 2024-09-24 10:30:07 +00:00
drh
118ac6a7ad Always use fputws() for output to a Windows command-line prompt. 
FossilOrigin-Name: 33950a8c3f3e48e5107fe56647da05147aa84f9c3eccbe7c8671f5b502ebb70b
 2024-09-24 09:51:53 +00:00
drh
7d24e6b080 Remove an ALWAYS() that can sometimes be false, with wildly incorrect SQL 
inputs.  dbsqlfuzz 707afcf73930de2624cdeca0ad1f0deea982dfea

FossilOrigin-Name: 766cf5535b9f51decd88c1736b988def929a90f68eb6a52bcaa21bb321586a08
 2024-09-24 00:53:27 +00:00
drh
415acd09d7 In the CLI, when displaying results in a columnar format, take into account 
zero-width and double-width Unicode characters.

FossilOrigin-Name: 47cfad71eddc6fc4414ff853ee172da72527620eee743721806072c6e0a80caa
 2024-09-24 00:01:47 +00:00
drh
1d9db01065 CLI uses only lib-c for I/O on Windows. No calls to Win32. Works on Win11, 
at least.  Reads and writes unicode to/from the console and UTF-8 to/from files.
Prototype code only - must testing and additional work required.

FossilOrigin-Name: 5c54530d5a0a4125a1ba44f22537c4f63d5e5708f347c43cbac3e1832c4335da
 2024-09-23 20:23:43 +00:00
drh
38f2c5f81c If the database filename pointer passed to sqlite3_open(), change it 
into ":memory:".

FossilOrigin-Name: 62e11a3a78edf9853b74d6495ccd8ae9ac1966c7d78eb3682cf2d5885e3740ec
 2024-09-21 15:57:06 +00:00
drh
7f0e0c7dbf New assert()s to help verify union access. No logic changes. Testing and 
validation code only.

FossilOrigin-Name: b7b64c53f5d7f6b405ee3f1f1be1d84230aa79db5a502c8ad78d3e524f4384fb
 2024-09-20 12:58:15 +00:00
drh
f8305e4616 Improved rebustness to malformed UTF-16 inputs to sqlite3_prepare16_v2(). 
FossilOrigin-Name: 7b3a517b3e16ea487ca77a2c88a0c11d737de366524fc911aa1bdd6bfb7ad148
 2024-09-19 13:39:06 +00:00
drh
0e8cbd5e78 Improvements to the scope of valueFromFunction(). 
FossilOrigin-Name: a0f39419cb5bdfa42ab2978cf3819e3d7821212996571f8251d2efbeaa26c603
 2024-09-18 16:33:07 +00:00
dan
38b31a93b3 Fix the preupdate hook so that it works when the "old.*" row has a column with a non-NULL default value that was added by ALTER TABLE ADD COLUMN after the current record was created. 
FossilOrigin-Name: 00a398cf900179aa5a8aab09fe4a671d99e7a31583282848ef39390f2ef246eb
 2024-09-18 15:02:27 +00:00
drh
87dce45f96 Add assert() statements to some of the sqlite3_bind() APIs that help human 
readers and static analyzers, both, reason about the code and verify that it
is memory safe.

FossilOrigin-Name: 97528788145b83a1486dbaf09326ebedbc07bd0b47a57cdff773885b0b984604
 2024-09-17 21:42:04 +00:00
drh
dbff02abc5 Enhancements to sqlite_dbpage() so that it accepts INSERT statements that can 
extend or truncate the database.  Add the sqlite3-rsync utility program that
make a copy of a live database over SSH.

FossilOrigin-Name: b7a8ce4c8c5fc6a3b4744d412d96f99d2452eb4086ad84472511da3b4d6afec6
 2024-09-14 16:39:02 +00:00
drh
33f0a3ed13 Merge sqlite_dbpage fixes into the sqlite3-rsync branch. 
FossilOrigin-Name: dff76b7a3436031ea5a61b8a44ddfa1d40ea20c983f3d34a8501cd7074db68b8
 2024-09-13 23:41:16 +00:00
drh
762946b236 Bug fix in the enhanced sqlite_dbpage for when truncating two or more 
ATTACH-ed databases within the same transaction.

FossilOrigin-Name: 6aa9c8e79b440c6419e65990d9ceba8f00a6f975455138cf2aa82b113daec825
 2024-09-13 21:47:57 +00:00
drh
165daef043 Add sha1() functions to the CLI. Fix sha1b() such that it actually returns 
a BLOB.

FossilOrigin-Name: fe65821a3b912f061026e6fd7174be26897010e6b474e2780350cac60faebaad
 2024-09-12 14:43:05 +00:00
drh
2a4a4ec408 Disable the debug-use-only functions sqlite3_mutex_held() and 
sqlite3_mutex_notheld() when compiling with TSAN in as much as those
routines cause TSAN to complain.  Response to
[https://issues.chromium.org/issues/41427446].

FossilOrigin-Name: db702dd78500a0839b0b2810a580d3634df49275470787b170973a86b73826d3
 2024-09-11 12:17:26 +00:00
drh
38b26d82e6 Add the ability for sqlite_dbpage to truncate the database file by writing 
a NULL page.  Experimental.

FossilOrigin-Name: eb3c89ee2e4c5425be75deaf46a06a9cd8b210c695b918dd63a78f930c6e6b63
 2024-09-10 12:09:03 +00:00
drh
882aba4090 Generalize the sqlite3_dbpage virtual table so that it is able to write 
new pages onto the end of the database file using INSERT.

FossilOrigin-Name: fe0d67e72d4228661c021f227bfc0d5ddb1b726db0f36c7221ead8dd8bd1dc73
 2024-09-09 18:45:58 +00:00
drh
5600adf1b1 Move the vfstrace extension out of src/ over into ext/misc/ where it belongs. 
Make it part of the standard build for the CLI.  Bring some of the vfstrace
output up-to-date.

FossilOrigin-Name: 055b97de8d2397987d72dbab1cde78ece2d1c066e95042b4ed6b7b36b2cf9006
 2024-09-09 14:50:23 +00:00
drh
deb6a60a84 Fix harmless compiler warnings. 
FossilOrigin-Name: 60fb8ee153ec293b6b3a4170dafa305e4c16af575aced72daef46116d8dc2bb6
 2024-09-06 11:21:53 +00:00