Fossil

History of src/sqlcmd.c of 26ecec6c2c7d955f
Login

History of src/sqlcmd.c of 26ecec6c2c7d955f

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

History of file src/sqlcmd.c at check-in 26ecec6c2c7d955f

2026-01-29
14:47
Two new sub-commands on "fossil system": "unzip" and "zip". ... (file: [d001e76b4b] check-in: [73e3217bc1] user: drh branch: trunk, size: 14482)
2025-12-23
16:06
Assorted fixes of typos and grammar in code comments. No functional changes. ... (file: [f6a5980d4b] check-in: [e2bdc10572] user: danield branch: trunk, size: 14396)
2025-11-18
18:15
Bring in the latest SQLite upstream for beta testing. ... (file: [40fe049442] check-in: [4f7645916a] user: drh branch: trunk, size: 14398)
2025-03-11
10:44
For the console-based timeline, run comment text through wiki_convert() and then through html_to_plaintext() before display, in order to translate markup. ... (file: [42334a1297] check-in: [6ab9994de6] user: drh branch: trunk, size: 14396)
2024-02-02
22:18
Remove trailing whitespace from non-external C files. ... (file: [c04649fb5d] check-in: [7db0a2d910] user: danield branch: fix-overlength-lines, size: 14315)
2023-05-18
21:15
Enhancements to SEE integration. ... (file: [4aecc676c4] check-in: [d72ab72962] user: mistachkin branch: enhSee, size: 14317)
2023-01-09
13:06
Further consistency improvements in docs for various commands. ... (file: [a550875d2f] check-in: [2512d2d472] user: km branch: trunk, size: 14290)
2022-12-30
20:54
Security enhancement: Do not store the passwords for remote URLs directly, but instead store the sha1_shared_secret() encoding of those passwords. It is the SHA1 encoding that gets transmitted to the server anyhow, so we might as well just store that. The SHA1 encoding cannot be used to log in. The password is still protected using obscure() even though it is now a SHA1 hash. ... (file: [226096d677] check-in: [41ba6ea7db] user: drh branch: trunk, size: 14302)
2022-12-21
09:00
Improved consistency for --help option descriptions: begin with uppercase letter; do not use a period at the end of short-ish sentences. ... (file: [9f4a78f03e] check-in: [de684083c6] user: km branch: spelling-fixes, size: 14166)
2022-11-13
16:26
Apply fixes to all web views to pass WCAG 2.1 tests performed by "axe DevTools" browser extension. Most fixes related to screen reader compatibility, like making sure that form elements have labels. Some color changes to improve contrast on Default skin. Made more HTML5 compliant. Minor improvement to select combo boxes for UX. Improved Search form UX. Two minor bug fixes for malformed HTML. Fixed help pages to resolve issues with non-compliant HTML being generated. Mostly documented at https://fossil-scm.org/forum/forumpost/aafb17a981df4166 ... (file: [a8f71f1392] check-in: [1f231db380] user: ericwikman branch: wcag-2.1, size: 14107)
2021-12-29
14:45
Another simplification of SEE memory handling for the 'sql' command. ... (file: [18704c72a2] check-in: [531434900b] user: mistachkin branch: trunk, size: 14167)
14:34
Correction to SEE memory handling used by the 'sql' command. ... (file: [9200e24d5e] check-in: [3b4a45535e] user: mistachkin branch: trunk, size: 14201)
2021-12-26
13:05
Removed miniz.c, per /chat discussion. It is incompatible with both OpenSLL and the SQL shell's sqlar support. ... (file: [0d80b48d36] check-in: [f9c2d23f29] user: stephan branch: trunk, size: 14207)
2021-05-26
01:05
Set a default busy-timeout of 10 seconds in the "fossil sql" command, before calling sqlite3_exec() to ATTACH auxiliary database files. ... (file: [98d38bc82a] check-in: [49df85ac05] user: drh branch: trunk, size: 14310)
2021-03-31
10:57
Sync w/trunk. ... (file: [6e4fd1d842] check-in: [79be1156a9] user: larrybr branch: panic-reduction, size: 14275)
2021-03-26
19:32
Fixed the 'add' Windows-reserved filename check to work with both filename and directory name input. It now always warns for such named s but permits them if --allow-reserved is used. ... (file: [bca45c9eae] check-in: [d0a8582e01] user: stephan branch: trunk, size: 14275)
2021-03-25
01:32
Reduce fossil_panic() calls to those indicating bugs and internal errors. Also clarify effects and purposes of fossil_fatal() vs. fossil_panic(). ... (file: [5b08336420] check-in: [91a4652f22] user: larrybr branch: panic-reduction, size: 14249)
2020-12-09
16:15
Remove a harmless comparison from the decompress() SQL function implementation. ... (file: [bed77f75c0] check-in: [87567ad869] user: drh branch: trunk, size: 14249)
2020-11-29
12:50
Additional defenses to prevent the db_protect() and db_protect_pop() SQL functions from being misused. ... (file: [543517d339] check-in: [6ade35427f] user: drh branch: trunk, size: 14272)
2020-09-16
13:58
Fix problems with the built-in "decompress()" SQL function. ... (file: [a31cf31165] check-in: [449ab5d600] user: drh branch: trunk, size: 13363)
2020-08-21
15:05
Improved documentation of the database write protection logic. Added undocumented SQL command db_protect() and db_protect_pop() to the "sql" command. Panic on a protection stack overflow. ... (file: [ff05cebca1] check-in: [75deba73b5] user: drh branch: sec2020, size: 13295)
2020-08-12
18:06
Add the "builtin" virtual table to the "fossil sql" command. This vtab provides access to all of the built-in support files. ... (file: [4e45fe14bc] check-in: [c6359b4ec1] user: drh branch: trunk, size: 12129)
2020-07-18
21:31
Enhancements to the help page for the "sql" command. ... (file: [c071c8c4d3] check-in: [a370043ffa] user: drh branch: trunk, size: 11700)
2020-06-20
00:15
Add the "helptext" virtual table. This is a stepping-stone to adding help-text search. ... (file: [acd8dcbdd3] check-in: [b2dacfcd73] user: drh branch: trunk, size: 10887)
2020-05-22
20:16
Merge trunk ... (file: [9001769385] check-in: [1e4aaf7b2e] user: jan.nijtmans branch: multi-thread, size: 10961)
16:19
Clean shutdown in the "fossil sql" command. ... (file: [5d9af5c1d9] check-in: [fbb15cc4a8] user: drh branch: trunk, size: 10857)
2020-04-05
23:45
Match the COMMAND and WEBPAGE names with _cmd and _page functions; [https://fossil-scm.org/forum/forumpost/045bffda68|forumpost/045bffda68] ... (file: [e08ded3c82] check-in: [06afb7022f] user: ashepilko branch: api-cleanup, size: 10573)
2020-03-12
00:44
Add the "gather_artifact_stats()" SQL function to the "fossil sql" command. This function invokes the gather_artifact_stats() C-language routine in order to populate the temporary ARTSTAT table. ... (file: [5ffbfbc997] check-in: [6e890f737f] user: drh branch: trunk, size: 10573)
2020-01-28
20:39
Merge trunk ... (file: [81cca0b03f] check-in: [9dbea18c71] user: jan.nijtmans branch: multi-thread, size: 10208)
2019-09-24
10:09
Fix harmless memory leaks. ... (file: [bd30d12c13] check-in: [79988f962e] user: drh branch: trunk, size: 10104)
2019-05-28
18:43
Pedantic cleanup to how to the SQL compress()/decompress() UDFs report an OOM, which can happen via zlib, outside of fossil's fail-fast allocator. ... (file: [72e5b3a619] check-in: [20abe25963] user: stephan branch: trunk, size: 10095)
2019-02-25
15:10
Add extension functions delta_apply(), delta_create(), delta_output_size(), and delta_parse() to the SQL connection for the "fossil sql" command. ... (file: [da3cbdc500] check-in: [effa89302a] user: drh branch: trunk, size: 9903)
2018-07-18
20:22
Merge trunk ... (file: [feab6d4225] check-in: [02bc919bc0] user: jan.nijtmans branch: multi-thread, size: 9233)
2018-07-15
19:56
Clarify the difference between fossil_fatal() and fossil_panic(). The fossil_panic() interface puts a message on the error log when generating webpages. Otherwise the two routines are identical. Convert some fossil_fatal() calls into fossil_panic() where appropriate. The goal here is to limit messages on the error log to things that require attention from the system administrator, or represent bugs. ... (file: [ba21c96081] check-in: [3f5ab71744] user: drh branch: trunk, size: 9129)
2018-06-20
13:40
Rig the "fossil sql" command so that it always comes up in --quote mode. This mode is more useful for Fossil repos dues to the many binary blobs. ... (file: [05dad54b31] check-in: [953aa7b4f5] user: drh branch: trunk, size: 9129)
2018-04-25
13:34
Update the built-in SQLite to the latest 3.24.0 alpha version. ... (file: [5e6c8fa715] check-in: [de76c92a63] user: drh branch: trunk, size: 9109)
2017-12-23
01:50
merge trunk ... (file: [b5866f6ecc] check-in: [b8e4dcc991] user: jan.nijtmans branch: multi-thread, size: 9059)
2017-12-07
12:01
Make "fossil sql" an alias for "fossil sqlite3" so that typing "fossil sql" does not generate an ambiguity with the new "fossil sqlar" command. ... (file: [031b91c0ee] check-in: [e02f4bf1b2] user: drh branch: trunk, size: 8955)
2017-08-31
02:00
Merge trunk ... (file: [819a129abc] check-in: [d15c1ba0f9] user: jan.nijtmans branch: multi-thread, size: 9042)
2017-05-30
01:26
Further enhancements to SEE integration. ... (file: [b150ead413] check-in: [53048387fb] user: mistachkin branch: see, size: 8938)
2017-05-29
23:14
Merge updates from trunk. ... (file: [70dbb895b0] check-in: [3b3099bdc0] user: mistachkin branch: see, size: 8846)
02:37
Enable the 'sqlite' command to work with SEE. ... (file: [c4c1b650a8] check-in: [564edc69aa] user: mistachkin branch: see, size: 8829)
2017-05-28
20:36
Some coding style cleanup in order to make fossil_close() static. ... (file: [2847ddef1a] check-in: [1c6a6fa1a9] user: mistachkin branch: trunk, size: 7959)
20:33
Make sure config database state is consistent when returning from 'sqlite' command. ... (file: [ee8149ac7b] check-in: [97ff702f3d] user: mistachkin branch: trunk, size: 7952)
2017-03-07
21:43
Fix the previous fix so that it works even if TH1 hooks are disabled at compile-time. ... (file: [fba609f0f5] check-in: [691a649234] user: drh branch: trunk, size: 7733)
20:38
Do not run TH1 hooks on the "fossil sql" command. ... (file: [f7e463dfe1] check-in: [d493544369] user: drh branch: trunk, size: 7695)
2017-03-01
15:35
Change references to "SHA1 hash" in comments and UI labels to be "artifact hash" or similar. ... (file: [c9d03589cc] check-in: [b9a1a3b9d8] user: drh branch: fossil-2.0, size: 7676)
2016-12-24
21:58
Fix a harmless compiler warning. ... (file: [9f904c862a] check-in: [1eb509a807] user: drh branch: trunk, size: 7671)
21:55
Improved documentation of the "fossil sql" command. Add a note to the change log discussing recent enhancements to the "fossil sql" command. ... (file: [81f1ec55dd] check-in: [a52f196740] user: drh branch: trunk, size: 7665)
18:07
Improve the "fossil sql" command so that it opens all database - repository, localdb, and configdb. Use the latest command-line shell code from the SQLite project so that the ".tables" command correctly shows all tables. ... (file: [b983079f6d] check-in: [070815585a] user: drh branch: trunk, size: 7627)
2016-11-16
19:29
Enable linenoise multiline editing so long commands and queries may be seen all at once therefore highlighted and copied from xterms ... (file: [fa59f2944d] check-in: [03b6869856] user: andygoth branch: trunk, size: 7123)
2016-08-24
14:56
Unbreak compilation on Cygwin. Allow notepad to be used as unversioned content editor (notepad cannot handle UNIX line-endings) ... (file: [a7dce974ba] check-in: [6728970b76] user: jan.nijtmans branch: trunk, size: 7025)
2016-08-19
00:13
Use the new SQLITE_DBCONFIG_MAINDBNAME feature of SQLite to eliminate the need for the db_name() hack. ... (file: [85c93b5f9c] check-in: [d858f3da52] user: drh branch: omit-db_name, size: 7075)
2016-06-05
17:02
Fix typo in sqlite3 command documentation ... (file: [67a6b4ac89] check-in: [fba7d9e452] user: andygoth branch: trunk, size: 7078)
2016-05-30
11:23
Enhance the files_of_checkin virtual table so that it can work as a table valued function, allowing queries such as: "SELECT * FROM files_of_checkin('version-1.34');" ... (file: [4be5f7cc5c] check-in: [24cfcee7cc] user: drh branch: trunk, size: 7080)
2016-04-02
00:00
Add a plain-text equivalent of the /test-all-help page to the CLI. Complete a first pass for spelling and minor grammar over all command and page help text. ... (file: [1f488b95eb] check-in: [f070ec99ae] user: rberteig branch: ross-spellcheck, size: 7169)
2016-04-01
13:37
Fix typos in comments. No changes to code. ... (file: [f2020c98ef] check-in: [b6b50b1244] user: mistachkin branch: trunk, size: 7167)
2016-03-12
22:02
Remove support for miniz because the upstream project appears to be unmaintained. UPDATE: The miniz project is still being maintained and this branch is a dead-end. ... (file: [e496f8ae02] check-in: [b9f31fe1e7] user: mistachkin branch: removeMiniz, size: 7068)
2016-02-07
23:22
Further enhance the 'sqlite3' command and make use of it in the json test. ... (file: [de27ee9014] check-in: [f9c14d7d6d] user: mistachkin branch: trunk, size: 7170)
2016-01-14
20:40
Fix typo that prevented the --no-repository option from working. Correction: It actually worked before and the issue was due to an incorrect assumption by the 'merge5' test, namely that the Fossil executable was present in the PATH. ... (file: [1015e3ea6c] check-in: [0a2eaa5ac2] user: mistachkin branch: trunk, size: 6827)
2016-01-13
06:19
Simplify the previous check-in. ... (file: [ed83de0ffb] check-in: [384482a87c] user: mistachkin branch: sqlCmdNoRepo, size: 6828)
01:31
Add the '--no-repository' option to the 'fossil sqlite3' command and make use of it for the merge5 test. ... (file: [2c67fcfb70] check-in: [56f74a120d] user: mistachkin branch: sqlCmdNoRepo, size: 6879)
2015-04-13
13:35
plug possible memory leak in compress/decompress SQL functions. ... (file: [9038553d94] check-in: [abef6cf768] user: jan.nijtmans branch: trunk, size: 6657)
2015-01-28
15:11
Add an experimental /search page for embedded documentation. Need to enhance with (1) wiki search, (2) ticket search, (3) configuration options, and (4) CSS, and maybe other things as well. But it is a start. ... (file: [1a2d0e1f6d] check-in: [046d7430bf] user: drh branch: trunk, size: 6487)
2015-01-26
09:04
Update custom MinGW makefile, add one "const" and remove some unnecessary eol-spaces ... (file: [c2be7f628d] check-in: [9e318f6b48] user: jan.nijtmans branch: trunk, size: 6463)
2015-01-23
14:03
Make the now() SQL function available in the "fossil sql" command. ... (file: [0a2dddbf1c] check-in: [0134654db6] user: drh branch: trunk, size: 6464)
2015-01-17
14:53
Make the symbolic_name_to_rid() and checkin_mtime() SQL functions available in the "fossil sql" command. Improve the documentation for the files_in_checkin virtual table. ... (file: [1138c93fe8] check-in: [ba1429cef8] user: drh branch: trunk, size: 6388)
2014-12-17
18:28
Add the ability to index files. ... (file: [2f2fc251ae] check-in: [83c6781670] user: drh branch: search-using-fts4, size: 5332)
16:19
Begin adding infrastructure to support full-text search using FTS4. ... (file: [1168655258] check-in: [9f9dfe3a98] user: drh branch: search-using-fts4, size: 5211)
2014-12-06
15:57
merge trunk ... (file: [0e4b8f2990] check-in: [e5a1100bcc] user: jan.nijtmans branch: multi-thread, size: 5286)
2014-12-01
21:29
More compiler warning fixes. ... (file: [33672640d4] check-in: [155c8b64ac] user: drh branch: DBP-workflow, size: 5182)
17:26
Merge the latest trunk enhancements into DBP-workflow branch. ... (file: [c26c4c65cd] check-in: [ab188badcd] user: drh branch: DBP-workflow, size: 5162)
2014-11-28
17:33
merge trunk ... (file: [f11995aa2b] check-in: [59cde7bb12] user: jan.nijtmans branch: multi-thread, size: 5308)
17:23
Add the "files_of_checkin" virtual table. ... (file: [5076b91de7] check-in: [7a588fe662] user: drh branch: trunk, size: 5204)
15:31
merge trunk ... (file: [5ad79caaa3] check-in: [6f95bf643a] user: jan.nijtmans branch: multi-thread, size: 5287)
14:07
Enhance the "fossil sql" command so that one or more SQL statements and/or dot-commands can be entered on the command-line. Also automatically ATTACH the local database and the config database, if they are available. ... (file: [444eff2fa6] check-in: [f922f4e3cc] user: drh branch: trunk, size: 5183)
2014-11-25
01:33
The "purge" and "purge list" commands appear to be working. ... (file: [327b4f5ba6] check-in: [92de66d219] user: drh branch: DBP-workflow, size: 5109)
2014-10-17
23:51
Use more aggressive cleanup when coming back from the 'sqlite' command, to permit TH1 hooks to exit cleanly. ... (file: [221f08cdc7] check-in: [b8b037610f] user: mistachkin branch: trunk, size: 4929)
2014-09-12
21:43
Rename new setting to 'max-wthreads'. Make sure all new code relies upon USE_SYSTEM_SQLITE. Style cleanup. ... (file: [8bf0ab6d5c] check-in: [c40085c558] user: mistachkin branch: multi-thread, size: 4904)
2014-09-04
09:22
Merge trunk. Implement new "max-worker-threads" setting, which controls the maximum number of auxilary worker threads that a single prepared statement may start. ... (file: [486ecd1413] check-in: [3a9f3a73c2] user: jan.nijtmans branch: multi-thread, size: 4871)
2014-08-23
06:08
Add miniz as a compile-time feature, leaving zlib as the default compression library. All makefiles should build. The DMC and PellesCGMake makefiles are not yet supported with miniz. Also, when using miniz, OpenSSL support for zlib is disabled in the MinGW makefile. ... (file: [c81155ddf8] check-in: [c693a3365c] user: mistachkin branch: optionalMiniz, size: 4800)
2014-08-19
16:52
"the zip file patch" from Baruch. ... (file: [ae9270f40d] check-in: [26ecec6c2c] user: stephan branch: miniz, size: 4699)
2014-08-18
17:13
Replaced zlib usage with local copy of miniz. Seems to work. ... (file: [6dc6ccb14e] check-in: [579ae389ce] user: stephan branch: miniz, size: 4698)
2014-04-22
06:56
Use SQLITE_UTF8 in stead of SQLITE_ANY everywhere, because SQLITE_ANY is deprecated in later SQLite and fossil uses UTF-8 everywhere anyway. ... (file: [2226df2d08] check-in: [2c95802cfc] user: jan.nijtmans branch: trunk, size: 4698)
2014-01-28
09:25
Rename sqlite3_cmd() to cmd_sqlite3() and sqlite3_exec_readonly() to db_exec_readonly(): sqlite3_* symbols are reserved for SQLite, in order to prevent possible future symbol conflicts. Eliminate use of deprecated "sqlite3_callback" typedef (which allows elimination of some type casts). Missing "static" in content.c ... (file: [6b4958b925] check-in: [0ed6e68d55] user: jan.nijtmans branch: trunk, size: 4695)
08:20
More removals of unnecessary end-of-line spaces. No change in code. ... (file: [b34ccfa098] check-in: [45f35169f2] user: jan.nijtmans branch: trunk, size: 4695)
2014-01-02
22:53
If fossil is configured with --disable-internal-sqlite, disable the "sqlite3" command: It doesn't work anyway, and there is no reason to support it; Any system which has an sqlite dll/so should have the sqlite3 utility as well, which can do almost the same as "fossil sqlite3" ... (file: [0837ef2953] check-in: [77d37d910b] user: jan.nijtmans branch: trunk, size: 4783)
2013-12-19
22:07
Merge from trunk. src/main.mk is now generated automatically. ... (file: [995483ef15] check-in: [927264ab5a] user: dg branch: dg-codenames, size: 4194)
2013-12-11
23:20
Remove usage of the 'win32-longpath' VFS as it is unlikely to work correctly with the various MSVCRT functions currently required by Fossil. ... (file: [3c57fc34d6] check-in: [19de4b5bcd] user: mistachkin branch: trunk, size: 4696)
2013-12-10
21:15
Avoid attempting to preserve the default VFS if it has not been set. ... (file: [b537eeac49] check-in: [fffcf60cbc] user: mistachkin branch: trunk, size: 4886)
14:22
Make the default vfs survive after a sqlite3_shutdown (for "fossil sqlite" command). ... (file: [85d84b92c8] check-in: [aa22b1b462] user: jan.nijtmans branch: trunk, size: 4868)
2013-09-04
20:42
Add initial basic mnemonic encoding support. ... (file: [569e12a4e8] check-in: [570783f795] user: dg branch: dg-codenames, size: 4195)
2013-01-01
20:56
Add the regular expression matching library and the "test-grep" command for testing it. ... (file: [a59638aa4c] check-in: [e2552de8c6] user: drh branch: trunk, size: 4697)
2012-11-04
12:59
Fix typos. ... (file: [63c66569a1] check-in: [45065c5c28] user: dmitry branch: spelling, size: 4674)
2012-10-08
13:50
Fix references to uninitialized memory when existing the SQL shell. ... (file: [ddee867532] check-in: [1955e6a69d] user: drh branch: trunk, size: 4675)
2012-09-05
19:07
Make the 'localtime' modifier for SQLite date/time functions work inside the "fossil sql" command. ... (file: [0c96c363b6] check-in: [16ab9f25ff] user: drh branch: trunk, size: 4663)
2012-08-29
13:57
Allow UTF-8 characters in sources. translate.exe will translate it to ASCII ... (file: [41337575cc] check-in: [9f6abc5968] user: jan.nijtmans branch: msvc-broken, size: 4625)
2012-06-29
15:59
Update to the latest SQLite4 that requires converting preprocessor macro prefixes from "SQLITE_" to "SQLITE4_". ... (file: [6bbc910307] check-in: [0328d68181] user: drh branch: sqlite4, size: 4644)
2012-06-27
12:30
Begin a branch that is modified to use sqlite4 instead of sqlite3 as the storage engine. This check-in compiles (on unix) but does not work. ... (file: [a0de858682] check-in: [6823912746] user: drh branch: sqlite4, size: 4637)
2012-03-29
14:54
Add vim modline everywhere ... (file: [e853f386a0] check-in: [a496d8e88d] user: mgagnon branch: mgagnon_fix, size: 4668)
2012-03-02
13:36
fixed a minor documentation typo. ... (file: [431c30c840] check-in: [648e74d857] user: stephan branch: trunk, size: 4626)
2011-05-18
14:28
Add built-in compress() and decompress() functions to the SQLite shell command. ... (file: [41357470cd] check-in: [91d648426a] user: drh branch: trunk, size: 4625)
2011-01-07
17:08
Do not complain about unfinalized SQL statements when exiting on a fatal error. Fix comments and indentation on the vfile_verify_not_phantom() function. ... (file: [f553c2e220] check-in: [c2f5dbe655] user: drh branch: trunk, size: 2956)
2010-12-03
23:49
Fix a bug in the new content() function added to the "sql" command. Ticket [195e50e93489c4997d]. ... (file: [f5e8a3673f] check-in: [63e6cb4e58] user: drh branch: trunk, size: 2955)
2010-11-26
18:43
Fix and out-of-order variable definition in the "sqlite3" command. ... (file: [2e68abae2f] check-in: [f105bc17a0] user: drh branch: trunk, size: 2886)
18:37
Report an error if the repository schema version does not match what the fossil executable expects. ... (file: [b9400215a3] check-in: [c0c3d92340] user: drh branch: trunk, size: 2877)
2010-11-24
12:03
Factor the sql-command shell out into a separate source file. Add the new content(X) SQL function for accessing uncompressed and undeltaed artifact content. ... (file: [409243ec24] check-in: [b4687be448] user: drh branch: trunk, size: 2818)