/ All files named "src/shell.c.in"
Login

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

History for src/shell.c.in

2020-12-04
01:17
[ff0d0cd5] part of check-in [d36d6f29] Alternative implementation of ".selecttrace" and ".wheretrace" that uses a test-control rather than global variables. (check-in: [d36d6f29] user: drh branch: traceflags-test-control, size: 362307)
2020-12-02
18:27
[771311fe] part of check-in [d330bf0c] Fix the ".open" command in the CLI so that it accepts command-line options both before and after the filename. (check-in: [d330bf0c] user: drh branch: trunk, size: 362767)
2020-11-25
20:29
[97e9ec67] part of check-in [f4b7c100] Merge trunk changes into this branch. (check-in: [f4b7c100] user: dan branch: reuse-schema, size: 371127)
16:28
[55113760] part of check-in [25d067c2] Fix harmless compiler warnings about unused function parameters. (check-in: [25d067c2] user: drh branch: trunk, size: 362650)
13:59
[b27aea18] part of check-in [a29f54bd] Change the -init option to the command-line shell to honor the -bail option. Also change it to report an error if the filename mentioned cannot be opened. (check-in: [a29f54bd] user: drh branch: trunk, size: 362624)
2020-11-18
21:15
[bbc88b59] part of check-in [6004de52] Merge trunk changes into this branch. (check-in: [6004de52] user: dan branch: reuse-schema, size: 370838)
2020-11-17
21:09
[2871f579] part of check-in [272793e5] Fix trivial memory leaks in the shell and sqldiff programs. (check-in: [272793e5] user: dan branch: trunk, size: 362361)
2020-10-31
18:58
[c0b4aea1] part of check-in [7d01e84d] Add the -tabs command-line option to the CLI. (check-in: [7d01e84d] user: drh branch: trunk, size: 362247)
2020-10-18
18:35
[b317d851] part of check-in [7f8802bb] Fix harmless compiler warnings. (check-in: [7f8802bb] user: mistachkin branch: trunk, size: 362012)
2020-10-12
17:57
[a04bec16] part of check-in [ce97b56d] Improved quoting of the table name argument for the ".import" command of the CLI. See forum post 34591fefbe. (check-in: [ce97b56d] user: drh branch: trunk, size: 361991)
16:54
[76abb40d] part of check-in [57123b14] Add options --data-only and --nosys to the ".dump" command in the CLI. (check-in: [57123b14] user: drh branch: trunk, size: 361979)
14:56
[ff8b8a59] part of check-in [b72ee694] Add the --nosys option to the .schema command in the CLI. (check-in: [b72ee694] user: drh branch: trunk, size: 361057)
2020-09-28
13:34
[4e6ea7bf] part of check-in [d3d13df3] Avoid the possibility of integer overflow on the --pagecache option to the CLI. See forum post 10a2892377 (check-in: [d3d13df3] user: drh branch: trunk, size: 360629)
2020-09-16
16:55
[21c61b18] part of check-in [2e269dcd] Merge bugfixes made since version 3.33.0 into this branch. (check-in: [2e269dcd] user: dan branch: reuse-schema-3.33, size: 367593)
16:48
[651e844e] part of check-in [1f0055d0] Do not invoke usleep() for more than 999999 microseconds. (check-in: [1f0055d0] user: dan branch: branch-3.33, size: 359116)
2020-09-15
12:29
[0fd9eca4] part of check-in [1f5ed852] Do not invoke usleep() for more than 999999 microseconds. (check-in: [1f5ed852] user: drh branch: trunk, size: 360538)
2020-09-07
11:23
[d5a07faa] part of check-in [ae1a778d] Merge latest trunk changes into this branch. (check-in: [ae1a778d] user: dan branch: reuse-schema, size: 368616)
2020-09-06
17:40
[a53743f2] part of check-in [783fa887] Remove an artifical limitation on the length of columns in the "box" output mode of the command-line shell. (check-in: [783fa887] user: drh branch: trunk, size: 360139)
2020-09-04
17:40
[871745c2] part of check-in [ca8deb44] Update this branch with latest changes from trunk. (check-in: [ca8deb44] user: dan branch: reuse-schema, size: 368692)
2020-08-31
18:49
[9bae0c83] part of check-in [dca5b919] New test-control that returns the number of calls to sqlite3BtreeMovetoUnpacked() on the main database and then resets the counter. This only works for SQLITE_DEBUG builds. (check-in: [dca5b919] user: drh branch: trunk, size: 360215)
2020-08-28
18:47
[14385d8c] part of check-in [fc0856dc] Add the miscellaneous 'series' extension to the shell. (check-in: [fc0856dc] user: mistachkin branch: trunk, size: 359960)
2020-08-27
20:55
[ee402091] part of check-in [3f7bbb84] Remove a (harmless) redundant variable from the CLI implementation. (check-in: [3f7bbb84] user: drh branch: trunk, size: 359893)
2020-08-26
19:07
[d9aae37f] part of check-in [0ffd16d2] Enhance the ".databases" command in the CLI so that it shows the result of sqlite3_db_readonly() and sqlite3_txn_state() for each database file. (check-in: [0ffd16d2] user: drh branch: trunk, size: 359905)
10:50
[13b9ba4d] part of check-in [6c716f4b] If the argument to the ".read" command in the CLI begins with "|" then run the remainder of the argument as a command and read input from the output of that command. (check-in: [6c716f4b] user: drh branch: trunk, size: 359123)
2020-08-17
09:11
[b6d5d6eb] part of check-in [c778f829] Fix the -quote option on the CLI to set the correct column separator. (check-in: [c778f829] user: drh branch: trunk, size: 358877)
2020-08-11
14:55
[0598d0e6] part of check-in [b1a77b7e] Merge all changes since the 3.32.0 release into the reuse-schema branch. (check-in: [b1a77b7e] user: drh branch: reuse-schema, size: 367194)
2020-08-10
14:34
[b9b819fe] part of check-in [33cd5341] Fix a shell tool build error caused by some combinations of options. (check-in: [33cd5341] user: dan branch: trunk, size: 358717)
2020-08-08
17:02
[6c1b07ee] part of check-in [5ecd03a2] Change the name of sqlite3SelectTrace to sqlite3_unsupported_selecttrace. (check-in: [5ecd03a2] user: dan branch: trunk, size: 358708)
2020-08-06
16:45
[889c7235] part of check-in [d573aa9b] Fix the columnar output modes in the CLI so that they work with parameters. See https://sqlite.org/forum/forumpost/17ba6aac24 for details of the problem fixed. (check-in: [d573aa9b] user: drh branch: trunk, size: 358643)
2020-07-29
16:18
[217e4186] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 358139)
2020-07-20
23:33
[352a0a63] part of check-in [6d258c3c] Fix the ".read" command so that it gives an error when its argument is a directory. See forum message 4c53c434ca. (check-in: [6d258c3c] user: drh branch: trunk, size: 358141)
2020-07-03
21:24
[81fa23ac] part of check-in [e0a8b11d] Fix the line-number of error messages coming out of the ".import" command when the --skip option is used. (check-in: [e0a8b11d] user: drh branch: trunk, size: 357817)
2020-06-24
15:06
[d6631524] part of check-in [db2f0836] Add the ieee754_mantissa() and ieee754_exponent() functions to the iee754 extension. Build the ieee754 extension into the CLI. (check-in: [db2f0836] user: drh branch: trunk, size: 357837)
12:29
[a46df149] part of check-in [5391687b] Add the decimal extension. It is built into the shell, but is an optional add-on for the library. It is not included in the amalgamation. (check-in: [5391687b] user: drh branch: trunk, size: 357771)
11:45
[bfb9ec7f] part of check-in [d45c27a3] Fix the ".selecttrace" command in the CLI (only available when compiled with the non-standard -DSQLITE_ENABLE_SELECTTRACE option) so that it does not segfault if invoked without any arguments. (check-in: [d45c27a3] user: drh branch: trunk, size: 357702)
2020-06-22
19:12
[7fe12fb6] part of check-in [4c3b8560] An extension for doing decimal arithmetic on strings. (check-in: [4c3b8560] user: drh branch: decimal, size: 357752)
2020-06-19
15:24
[ab356da1] part of check-in [7a876209] Extend the refactoring into extensions. Clean up stray newlines. (check-in: [7a876209] user: drh branch: trunk, size: 357683)
2020-06-16
17:34
[ffd3de9c] part of check-in [f3bd6893] In the CLI, only interrupt tabular outputs at the end of a line. And print "Interrupt" on a line after stopping the output. (check-in: [f3bd6893] user: drh branch: trunk, size: 357683)
2020-06-15
20:27
[c27ee0cd] part of check-in [61782a7a] Provide "sqlite_schema" as an alternative name to the table that holds the database schema. (check-in: [61782a7a] user: drh branch: trunk, size: 357614)
20:05
[0e439519] part of check-in [9472f1fe] Fix the CLI so that interrupts work in columnar output mode. (check-in: [9472f1fe] user: drh branch: trunk, size: 357496)
2020-06-05
00:54
[c6e26593] part of check-in [2827c0a1] Always use ?...? to indicate optional arguments in the output of ".help" in the CLI. Change ".mode column" so that it automatically activates ".headers on" if headers have not been previously turned on or off. (check-in: [2827c0a1] user: drh branch: trunk, size: 357428)
2020-06-04
18:05
[6f7ea57d] part of check-in [6da784c9] Add support for "box" mode in the CLI: Like "table" except that it uses unicode box-drawing characters instead of ascii-art. (check-in: [6da784c9] user: drh branch: trunk, size: 357237)
16:54
[b8fd54e8] part of check-in [7efabd68] Improved display of ".mode table" output for empty result sets. (check-in: [7efabd68] user: drh branch: trunk, size: 353819)
2020-05-30
15:34
[9c0e8865] part of check-in [c6b7833a] Draw the dashes below the headers in "explain" mode in the CLI. (check-in: [c6b7833a] user: drh branch: trunk, size: 353740)
2020-05-29
20:16
[1c47af12] part of check-in [5865d2f2] Remove a stray "&" character in the CLI, detected by a clang warning. (check-in: [5865d2f2] user: drh branch: trunk, size: 353578)
19:39
[5074277a] part of check-in [50d4ddf1] Fix the ".import" command of the CLI to clean up better after errors. Add the new "shelltest" makefile target on unix platforms. (check-in: [50d4ddf1] user: drh branch: trunk, size: 353579)
19:17
[ca45965c] part of check-in [6a01e4c4] Improvements to help text for the CLI. (check-in: [6a01e4c4] user: drh branch: trunk, size: 353421)
19:03
[568398ec] part of check-in [71bfbbcc] Fix a memory leak in the CLI when an unknown or unrecognized argument is given to the ".dump" command. (check-in: [71bfbbcc] user: drh branch: trunk, size: 353284)
16:15
[9675df5f] part of check-in [4e1db8e9] Improvements to columnar output in the CLI. Columns automatically expand to contain the largest row. (check-in: [4e1db8e9] user: drh branch: trunk, size: 353222)
14:38
[77530a90] part of check-in [445ed5da] Space to hold the ".width" of columns in the CLI is now obtained from malloc() and hence is not limited in the number of columns supported. (check-in: [445ed5da] user: drh branch: trunk, size: 353538)
12:31
[17fff683] part of check-in [af28bff9] Incremental improvements to tabular output modes in the CLI. The "markdown" and "table" modes no have headers turned on by default. (check-in: [af28bff9] user: drh branch: trunk, size: 353305)
00:21
[f545fcc6] part of check-in [0278147a] In the json output mode of the CLI, do correct quoting of escape characters. Also, show BLOBs as JSON strings, possibly with embedded \u0000 bytes. (check-in: [0278147a] user: drh branch: trunk, size: 352957)
2020-05-28
23:49
[d135e500] part of check-in [14f55faf] Progress toward adding new output modes to the CLI: json, table, and markdown. (check-in: [14f55faf] user: drh branch: trunk, size: 352255)
20:37
[2bca5f14] part of check-in [b5e33ed5] Enhance the ".quote" mode in the shell so that it honors .separator. (check-in: [b5e33ed5] user: drh branch: trunk, size: 348002)
2020-05-16
19:00
[a1be0ab4] part of check-in [5af4abe9] Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: [5af4abe9] user: drh branch: reuse-schema, size: 356299)
2020-05-02
00:01
[cf2d24f5] part of check-in [baa720e4] Corner-case changes to the bytecode virtual table for testability and correctness. (check-in: [baa720e4] user: drh branch: bytecode-function, size: 347822)
2020-04-28
23:09
[86cd0f04] part of check-in [0dcf0024] Fix incorrect error message when something goes wrong with the sqlite3_dbpage() table-valued function in the .dbinfo command of the CLI. (check-in: [0dcf0024] user: drh branch: trunk, size: 347777)
2020-04-23
20:45
[1fc834b8] part of check-in [65c6c26b] Fix an uninitialized variable in the newly enhanced ".output" command of the CLI. See forum post 5978955ac1 (check-in: [65c6c26b] user: drh branch: trunk, size: 348004)
2020-04-20
16:21
[5402d3a7] part of check-in [698d40db] Enhance the ".filectrl" command in the CLI to support the --schema option. (check-in: [698d40db] user: drh branch: trunk, size: 347961)
15:18
[c21ce88a] part of check-in [abc1aad7] The SQLITE_TESTCTRL_RESERVE operator is removed. In its place is the more general SQLITE_FCNTL_RESERVE_BYTES which is an API and which can operator on more than just the main schema. (check-in: [abc1aad7] user: drh branch: trunk, size: 347198)
2020-04-18
14:12
[d48577e0] part of check-in [d5b0def9] Add the --bom option to the ".excel", ".once", and ".output" commands of the CLI. Also fix the "--all" option on ".help" so that it works with two dashes in addition to just one. (check-in: [d5b0def9] user: drh branch: trunk, size: 347317)
2020-04-17
23:46
[d615184e] part of check-in [07752164] Fix the ".excel" command and the ".open -x" and ".open -e" command so that they work better when running from an in-memory database and on Windows and when running from a script. (check-in: [07752164] user: drh branch: trunk, size: 346087)
2020-04-14
15:53
[792b901a] part of check-in [2b8c6b03] Build the UINT collating sequence extension into the CLI. (check-in: [2b8c6b03] user: drh branch: trunk, size: 345553)
2020-04-09
15:31
[cf7d6140] part of check-in [85d3dc8c] When compiling the shell for WinRT, avoid using Win32 APIs that are unavailable. (check-in: [85d3dc8c] user: mistachkin branch: trunk, size: 345490)
2020-04-02
13:21
[759bb4a2] part of check-in [c9c735e2] Fix an obsolete comment in the parameter binding logic of the CLI. No changes to code. (check-in: [c9c735e2] user: drh branch: trunk, size: 345031)
2020-03-25
20:31
[7bb9005b] part of check-in [029ceea6] For the LIKE pattern in the .dump command of the CLI, accept backslash as an escape character. (check-in: [029ceea6] user: drh branch: trunk, size: 345027)
12:50
[10093b8f] part of check-in [45fba3d7] Enhance the ".dump" command in the CLI so that it accepts multiple LIKE pattern arguments and shows the union of all matching tables. (check-in: [45fba3d7] user: drh branch: trunk, size: 344987)
2020-03-20
20:54
[4631ab1a] part of check-in [75c85ca3] Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: [75c85ca3] user: dan branch: main-alias-fix, size: 345560)
2020-03-09
15:39
[f7659093] part of check-in [cab1834c] Enhancements to the ".import" command of the CLI. (check-in: [cab1834c] user: drh branch: trunk, size: 345558)
2020-03-05
16:30
[42c8c25b] part of check-in [9d068e1e] Merge trunk enhancements into the reuse-schema branch. (Actual check-in date is 2020-05-18) (check-in: [9d068e1e] user: drh branch: reuse-schema, size: 350488)
2020-02-29
15:53
[3897f3f7] part of check-in [9c3136a7] In the CLI, add the ".oom" command for debugging builds. (check-in: [9c3136a7] user: drh branch: trunk, size: 342011)
2020-01-20
15:32
[8a06de3e] part of check-in [9c920bba] Merge recent fixes from trunk. (check-in: [9c920bba] user: drh branch: reuse-schema, size: 348200)
2020-01-19
20:37
[c2e20c43] part of check-in [4d462550] Enhancement to the CLI to allow the ".parameter init" command to work even if defensive mode is turned on. (check-in: [4d462550] user: drh branch: trunk, size: 339723)
2020-01-15
14:26
[6d2c6d34] part of check-in [f7839178] Merge all recent enhancements and fixes from trunk. (check-in: [f7839178] user: drh branch: reuse-schema, size: 347966)
2020-01-14
13:13
[1b2a636b] part of check-in [db4fb350] Fix a minor typo on a comment in the CLI implementation. (check-in: [db4fb350] user: drh branch: trunk, size: 339489)
2020-01-10
00:20
[a68cd2a9] part of check-in [3d23a275] Begin making changes to turn off trusted schema in command-line tools that open SQLite databases. There are a lot of these, and a lot of places to change, which makes me wonder if trusted schema should be off by default. (check-in: [3d23a275] user: drh branch: default-untrusted-schema, size: 339829)
2020-01-07
16:09
[43d3cfbe] part of check-in [f5fcf1fb] Invert the UNTRUSTED_SCHEMA setting to be TRUSTED_SCHEMA. (check-in: [f5fcf1fb] user: drh branch: new-security-options, size: 339487)
2020-01-06
15:25
[6893d5b8] part of check-in [411e8ec2] Refactor names of flags for improved legibility. (check-in: [411e8ec2] user: drh branch: new-security-options, size: 339487)
2020-01-04
20:58
[0fcf24b5] part of check-in [65d7d39a] Refactor the names of the new controls for restricting what actions the schema can take behind the application's back. (check-in: [65d7d39a] user: drh branch: new-security-options, size: 339487)
2020-01-02
23:50
[69462c95] part of check-in [091403a6] Merge enhancements from trunk. (check-in: [091403a6] user: drh branch: new-security-options, size: 339560)
2020-01-01
23:02
[90b002bf] part of check-in [8ee2ce92] Provide the -DSQLITE_ENABLE_INTERNAL_FUNCTIONS=1 compile-time option. Fix the ".testctrl internal_function" command in the CLI so that it does not signal an error on a valid input. (check-in: [8ee2ce92] user: drh branch: trunk, size: 339414)
15:43
[36fb3732] part of check-in [473892a8] New test-only SQL functions: implies_nonnull_row(), expr_compare(), and expr_implies_expr(). The SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test-control is modified to toggle internal function access on and off for a single database connection. (check-in: [473892a8] user: drh branch: trunk, size: 339394)
2019-12-31
22:52
[709c85e7] part of check-in [96a2db26] Experimental branch with new sqlite3_db_config() options that could possible enhance security for applications reading potentially compromised database files. (check-in: [96a2db26] user: drh branch: new-security-options, size: 339431)
2019-11-25
23:55
[6ecf8033] part of check-in [12b8fa23] Experimental file-controls for controlling the use of the -shm file. (check-in: [12b8fa23] user: drh branch: reuse-shm, size: 339763)
2019-11-18
17:46
[4a3a9e1c] part of check-in [cb79c828] Add support for SQLITE_OPEN_NOFOLLOW. (check-in: [cb79c828] user: drh branch: trunk, size: 339285)
2019-11-07
19:59
[5e402d7f] part of check-in [4ab9dbb9] Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. (check-in: [4ab9dbb9] user: drh branch: limit_heap_k, size: 338744)
2019-11-02
00:00
[c06961f2] part of check-in [28b8f103] Restore the on-line ".help" for the ".explain" command in the CLI. (check-in: [28b8f103] user: drh branch: trunk, size: 338669)
2019-10-29
16:18
[a17d143f] part of check-in [4d424f30] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f30] user: drh branch: trunk, size: 338808)
2019-10-26
16:02
[01d14c1e] part of check-in [070b4982] Fix a problem in the legacy ".explain on" formatting when it is used on a query with more than 8 output columns. (check-in: [070b4982] user: drh branch: trunk, size: 338735)
2019-10-18
15:58
[3093bdf5] part of check-in [9dc0d345] Enhance the ".imposter" command in the CLI so that the first argument can be an existing WITHOUT ROWID table instead of an index. The resulting imposter is the same table, but with columns in storage order and with all constraints removed. (check-in: [9dc0d345] user: drh branch: trunk, size: 338648)
2019-10-04
15:31
[2c49eff3] part of check-in [6e09afec] Bring the reuse-schema branch up-to-date with version 3.30.0. (check-in: [6e09afec] user: drh branch: reuse-schema, size: 346284)
2019-10-02
00:25
[d70bcf63] part of check-in [9f4035f9] Disable sqlite3_drop_module() tests when virtual tables are omitted from the build. (check-in: [9f4035f9] user: drh branch: trunk, size: 337778)
2019-09-30
16:57
[a2d3a981] part of check-in [06796124] Merge in the 3.30.0 beta 1 changes. (check-in: [06796124] user: drh branch: reuse-schema, size: 346240)
2019-09-26
20:05
[026d8a5b] part of check-in [e768179b] Allow DROP TABLE to work on tables name "sqlite_parameters" just as it does with tables named "sqlite_stat%". Fix for the ".parameter clear" command in the shell. (check-in: [e768179b] user: drh branch: trunk, size: 337734)
2019-09-16
12:35
[f3f258a9] part of check-in [27eb2236] Merge all recent trunk enhancements into the reuse-schema branch. (check-in: [27eb2236] user: drh branch: reuse-schema, size: 346493)
2019-09-14
16:44
[68698630] part of check-in [01d71b94] Add the --no-rowids option to the ".recover" command. (check-in: [01d71b94] user: dan branch: trunk, size: 337987)
2019-08-26
14:57
[e5fb9150] part of check-in [279ac7fd] Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. (check-in: [279ac7fd] user: dan branch: trunk, size: 337513)
12:50
[596e4160] part of check-in [9690013a] Enforce 80-character line discipline in the CLI. Minor improvements to the CLI built-in help. (check-in: [9690013a] user: drh branch: trunk, size: 337505)
2019-08-23
23:05
[9a0706cd] part of check-in [e3249012] Fix the built-in edit() SQL function in the CLI so that it works with zero-length blobs. (check-in: [e3249012] user: drh branch: trunk, size: 337676)
2019-08-19
20:35
[e0f0758b] part of check-in [e5ba47c2] Omit the "_except" term from the name of the new interface. (check-in: [e5ba47c2] user: drh branch: sqlite3_drop_modules_except, size: 337684)
2019-08-17
19:45
[e0754f1d] part of check-in [0851db4d] The experimental sqlite3_drop_modules_except() interface. (check-in: [0851db4d] user: drh branch: sqlite3_drop_modules_except, size: 337622)
15:27
[48f7a9ee] part of check-in [9c4bca64] Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. (check-in: [9c4bca64] user: drh branch: trunk, size: 337239)
2019-08-16
22:58
[d2465e77] part of check-in [31e34fa3] Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. (check-in: [31e34fa3] user: drh branch: trunk, size: 337233)
2019-08-15
21:27
[b748cfb4] part of check-in [61b4bccd] Add the SQLITE_DBCONFIG_ENABLE_VIEW option, together with a "db config" command in the TCL interface that can access that option as well as all the other sqlite3_db_config() boolean options. (check-in: [61b4bccd] user: drh branch: trunk, size: 336807)
2019-08-13
15:22
[42051fc4] part of check-in [5b4689d8] Merge latest trunk changes with this branch. (check-in: [5b4689d8] user: dan branch: reuse-schema, size: 345240)
2019-08-12
16:25
[66cd8289] part of check-in [636ca447] For the ".testctrl prng_seed" command in the CLI, if the argument is "random" then select a random integer seed and print the seed value on stdout. (check-in: [636ca447] user: drh branch: trunk, size: 336734)
15:19
[4dac87db] part of check-in [a48a7b78] Make the sha3 extension part of the amalgamation, enabled using SQLITE_ENABLE_SHA3. (check-in: [a48a7b78] user: drh branch: sha3, size: 336538)
14:17
[1b9efc93] part of check-in [48d9b48a] Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. (check-in: [48d9b48a] user: drh branch: trunk, size: 336563)
2019-08-08
19:40
[920360b4] part of check-in [1eef4dde] Fix harmless compiler warnings. (check-in: [1eef4dde] user: drh branch: trunk, size: 336478)
15:24
[3f2c64bf] part of check-in [1e17ea2f] Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. (check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 336450)
2019-08-06
20:26
[97714cd5] part of check-in [846d2d2d] Enhance the ".recover" output in the shell to use double-quotes around table and column identifiers. (check-in: [846d2d2d] user: drh branch: trunk, size: 336603)
18:40
[486dbf00] part of check-in [bfc29e62] Add "PRAGMA foreign_keys=OFF;" to the start of the script output by ".recover", just as is done for ".dump". (check-in: [bfc29e62] user: dan branch: trunk, size: 335875)
2019-08-03
01:39
[e5351f14] part of check-in [49aa3448] Give the SQLITE_TESTCTRL_PRNG_SEED two arguments. The second argument if not NULL is a pointer to a database connection which seeds the connection from its schema cookie. In this way, fuzzers can control the PRNG seed. (check-in: [49aa3448] user: drh branch: prng-seed-test-control, size: 335580)
2019-08-02
20:45
[5ab94c68] part of check-in [3ac57231] Add the SQLITE_TESTCTRL_PRNG_SEED test control. (check-in: [3ac57231] user: drh branch: prng-seed-test-control, size: 335066)
2019-07-26
20:54
[8b51039f] part of check-in [7f1e4e4b] Merge latest changes from trunk into this branch. (check-in: [7f1e4e4b] user: dan branch: reuse-schema, size: 343532)
2019-07-24
20:10
[9c203a8c] part of check-in [9c458acb] Improve the ".recover" command so that it handles intkey pages linked into non-intkey b-trees, and vice-versa, better. (check-in: [9c458acb] user: dan branch: trunk, size: 335026)
19:20
[8bc78eac] part of check-in [becaaa4d] Improve the ".recover" command's handling of corrupt database schemas. (check-in: [becaaa4d] user: dan branch: trunk, size: 334636)
08:15
[68ef28e3] part of check-in [87d76047] Improve the ".recover" command in the shell tool so that it is not confused by auto-vacuum databases. And so that it can recover tables for which one or more of the column names are SQL keywords. (check-in: [87d76047] user: dan branch: trunk, size: 334601)
2019-07-17
15:05
[a571d51d] part of check-in [9ec92939] Improvement to the hexdb interpreter built into the CLI and into the TCL test harness: Round the "size" up to the next multiple of the "pagesize". (check-in: [9ec92939] user: drh branch: trunk, size: 334012)
07:23
[360607dc] part of check-in [fe014288] Add casts to shell.c.in to avoid warnings on systems where size_t is 32 bits. (check-in: [fe014288] user: dan branch: trunk, size: 333862)
2019-07-13
17:21
[5c0171b6] part of check-in [fcd937d9] Fix a double-quoted string literal used in the ".schema" command of the CLI. (check-in: [fcd937d9] user: drh branch: trunk, size: 333838)
2019-07-08
21:32
[46729dfe] part of check-in [fae92fee] Merge recent trunk enhancements into the reuse-schema branch. (check-in: [fae92fee] user: drh branch: reuse-schema, size: 342332)
2019-06-21
14:05
[82f8a473] part of check-in [1c58522e] Fix a typo in an option name for the .dbconfig command in shell.c.in: s/wriable_schema/writable_schema/ (check-in: [1c58522e] user: dan branch: trunk, size: 333826)
2019-06-17
13:56
[6edadde4] part of check-in [923cfd53] Improved interface to double-quoted string literal enabling/disabling. (check-in: [923cfd53] user: drh branch: new-dbconfig-options, size: 333826)
2019-06-14
21:25
[21e30c2c] part of check-in [1fad2092] Add SQLITE_DBCONFIG options LEGACY_ALTER_TABLE, NO_DQS_SCHEMA, and NO_DQS. (check-in: [1fad2092] user: drh branch: new-dbconfig-options, size: 333826)
2019-06-13
14:07
[ad3405c9] part of check-in [f8696b60] Do not use the %lld printf conversion in the platform printf() as some legacy platforms do not support it. (check-in: [f8696b60] user: drh branch: trunk, size: 333525)
13:52
[fec94208] part of check-in [eaa34626] Fix a minor error in a test script, and harmless compiler warnings in the CLI code. (check-in: [eaa34626] user: drh branch: trunk, size: 333447)
2019-06-05
14:29
[9648bc20] part of check-in [7b3a99fc] CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". (check-in: [7b3a99fc] user: drh branch: trunk, size: 333437)
2019-06-04
18:21
[6a58aac0] part of check-in [4979f138] In the CLI, add a small delay (0.1 seconds) after launching the output command for ".once" before deleting the temporary file. (check-in: [4979f138] user: drh branch: trunk, size: 329021)
2019-06-03
13:46
[a0011aba] part of check-in [3ba6f790] In the CLI, add ".help" text for the .shared-schema command. (check-in: [3ba6f790] user: drh branch: reuse-schema, size: 337501)
2019-05-24
13:15
[ce8c9243] part of check-in [0913ff4d] The ".shared-schema" command in the CLI requires the sqlite_dbpage table, so disable it if the build does not include that extension. (check-in: [0913ff4d] user: drh branch: reuse-schema, size: 337205)
2019-05-14
22:25
[9353bb93] part of check-in [018f3199] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [018f3199] user: drh branch: reuse-schema, size: 337121)
2019-05-10
17:50
[6c992809] part of check-in [2846bc04] Fix harmless compiler warnings in the CLI. (check-in: [2846bc04] user: drh branch: trunk, size: 328995)
2019-05-09
18:33
[1f3e8c70] part of check-in [8d2a062e] Fix a problem in the ".recover" command allowing a circular loop of b-tree pages in a database file to cause an infinite loop. (check-in: [8d2a062e] user: dan branch: trunk, size: 328112)
18:13
[332af861] part of check-in [f22c7e22] Make the ".schema" command in the CLI resistant to corrupt database files. (check-in: [f22c7e22] user: drh branch: trunk, size: 328115)
16:57
[6aa1d26e] part of check-in [20f06bf2] Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. (check-in: [20f06bf2] user: dan branch: trunk, size: 328069)
14:15
[f5d3a1f3] part of check-in [e736da9c] Have ".recover" handle cases where the sqlite_master table contains malformed SQL statements. (check-in: [e736da9c] user: dan branch: trunk, size: 328057)
11:45
[517b3e2a] part of check-in [47fa6534] Fix a problem with running the ".recover" command on a database that is zero pages in size. (check-in: [47fa6534] user: dan branch: trunk, size: 328015)
11:18
[5d0e2b03] part of check-in [4fa831d5] Improved error handling for the ".open --hexdb" command of the CLI. (check-in: [4fa831d5] user: drh branch: trunk, size: 327996)
2019-05-03
02:41
[5470f088] part of check-in [9b5d9434] Fix the ".open --hexdb" command in the CLI so that it works even with terminal input. (check-in: [9b5d9434] user: drh branch: trunk, size: 328046)
2019-04-29
11:41
[567236da] part of check-in [92facbc7] Fix a buffer overwrite in shell.c.in (part of the new .recover code). (check-in: [92facbc7] user: dan branch: trunk, size: 328018)
2019-04-27
20:15
[104bbae9] part of check-in [425d708c] Fix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPAGE_VTAB. (check-in: [425d708c] user: dan branch: dbdata, size: 328018)
19:36
[2316b9ee] part of check-in [b91d819b] Add comments and fix formatting issues in new code in shell.c.in. (check-in: [b91d819b] user: dan branch: dbdata, size: 327368)
18:47
[51f027f6] part of check-in [67bb88e2] Add the "--lost-and-found" option to the ".recover" command. For setting the name of the orphaned rows table. (check-in: [67bb88e2] user: dan branch: dbdata, size: 326074)
15:35
[3701177f] part of check-in [91df4b8e] Fix a problem in the .recover command with recovering WITHOUT ROWID tables where the PK columns are not the leftmost in the CREATE TABLE statement. (check-in: [91df4b8e] user: dan branch: dbdata, size: 323450)
2019-04-26
21:11
[146dbc27] part of check-in [7221f6e3] Have .recover store all orphaned rows in a single table, with extra columns to indicate the orphaned page and sub-tree they were discovered within. (check-in: [7221f6e3] user: dan branch: dbdata, size: 323011)
17:20
[7544d689] part of check-in [1b25fa10] An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. (check-in: [1b25fa10] user: drh branch: cost-est, size: 302279)
15:40
[44dce9f5] part of check-in [bee2652a] Fix another problem with database freelist handling in the ".recover" command. (check-in: [bee2652a] user: dan branch: dbdata, size: 321983)
15:14
[63b10758] part of check-in [afdae104] Fix a locking-page related problem with the ".recover" command. (check-in: [afdae104] user: dan branch: dbdata, size: 321918)
2019-04-25
20:06
[78004b10] part of check-in [1da302d8] Merge latest trunk changes into this branch. (check-in: [1da302d8] user: dan branch: dbdata, size: 321103)
19:23
[a3b1bb23] part of check-in [8d2f52bb] Unless the "--freelist-corrupt" option is specified, do not have the .recover command attempt to recover data from pages that are on the database free-list. (check-in: [8d2f52bb] user: dan branch: dbdata, size: 321119)
16:20
[2e9b6b05] part of check-in [959bbd11] Fix a bug preventing .recover from working on databases where the final page of the db is corrupt. (check-in: [959bbd11] user: dan branch: dbdata, size: 318831)
2019-04-24
20:48
[569ee1f7] part of check-in [a5076831] Improve the performance of the .recover command. (check-in: [a5076831] user: dan branch: dbdata, size: 318774)
2019-04-23
20:48
[6e56c606] part of check-in [f95f0f02] Have ".recover" handle "\r" and "\n" in the same way as ".dump". (check-in: [f95f0f02] user: dan branch: dbdata, size: 318346)
18:03
[6c02cbd1] part of check-in [8dcc1d89] Fixes for the ".recover" shell command. (check-in: [8dcc1d89] user: dan branch: dbdata, size: 316049)
15:30
[bcfa17eb] part of check-in [4258e42d] Changes to the --hexdb decoder option in the shell (and also in the TCL test code) so that it works on systems where sscanf() does not recognize "%hhx" as wanting to delivery results into a character-size variable. (check-in: [4258e42d] user: drh branch: trunk, size: 302024)
2019-04-22
20:52
[7dd0babc] part of check-in [f193ca58] Enhance the ".recover" command. Fix a problem with overflow pages in dbdata.c. (check-in: [f193ca58] user: dan branch: dbdata, size: 314766)
2019-04-20
20:57
[3646e448] part of check-in [7461d2e1] Add the ".recovery" command to the shell tool. For recovering the maximum amount data from corrupt databases. Still needs work. (check-in: [7461d2e1] user: dan branch: dbdata, size: 309929)
2019-04-17
23:32
[903dafb0] part of check-in [f6ebe1c2] Work around lack of a C99 feature in MSVC. (check-in: [f6ebe1c2] user: mistachkin branch: msvc, size: 302272)
13:58
[0d1a1abd] part of check-in [57638248] Fix a typo in the CLI help output for the ".dump" command. (check-in: [57638248] user: drh branch: trunk, size: 302042)
2019-04-04
20:21
[bf49f877] part of check-in [b40a4edc] Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. (check-in: [b40a4edc] user: drh branch: disable-vtab, size: 302514)
2019-03-26
11:57
[30eac60e] part of check-in [db4e2cc3] Merge recent trunk enhancements. (check-in: [db4e2cc3] user: drh branch: reuse-schema, size: 310513)
2019-03-25
22:05
[c1986496] part of check-in [fade103c] Fix an obsolete comment in the CLI. No code changes. (check-in: [fade103c] user: drh branch: trunk, size: 302040)
21:56
[3e95f0e2] part of check-in [e775ef00] In the CLI, code the "sqlite_parameters" name directly rather than using a macro, for clarity of presentation for users who are reading the code for the purpose of seeing how the CLI implements parameter binding. (check-in: [e775ef00] user: drh branch: trunk, size: 302036)
21:35
[35d0257c] part of check-in [24ef3844] Change the name of the parameter table in the CLI to "sqlite_parameters". Doing so involves adding SQLITE_DBCONFIG_WRITABLE_SCHEMA and allowing the creation of tables whose names begin with "sqlite_" and that are indexed while writable_schema is on. (check-in: [24ef3844] user: drh branch: trunk, size: 302162)
15:09
[9c166e41] part of check-in [919fec91] Improvements to the help text in the CLI. (check-in: [919fec91] user: drh branch: trunk, size: 301687)
14:24
[652ba411] part of check-in [191a023a] For the ".archive --update" command in the CLI, only update files if their mtime or mode has changed. To force an update, use the new --insert instead. (check-in: [191a023a] user: drh branch: trunk, size: 301685)
2019-03-21
17:22
[2030093c] part of check-in [3196f5f4] Merge latest trunk changes with this branch. (check-in: [3196f5f4] user: dan branch: reuse-schema, size: 308972)
17:13
[c82e5dce] part of check-in [b8e53608] Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. (check-in: [b8e53608] user: dan branch: reuse-schema, size: 308608)
2019-03-20
18:22
[576ba793] part of check-in [3649a77b] In the CLI, give better error messages if something goes wrong with the ".dbinfo" command. (check-in: [3649a77b] user: drh branch: trunk, size: 300499)
16:03
[84f22bfb] part of check-in [4cd20ca6] Merge latest trunk changes into this branch. (check-in: [4cd20ca6] user: dan branch: reuse-schema, size: 308609)
2019-03-06
14:53
[01c0cc01] part of check-in [ee642d3e] Add the sqlite3_stmt_isexplain() interface. (check-in: [ee642d3e] user: drh branch: trunk, size: 300135)
2019-03-04
07:25
[0ba39416] part of check-in [97a9604d] Merge latest trunk changes into this branch. (check-in: [97a9604d] user: dan branch: reuse-schema, size: 308749)
2019-02-28
20:10
[249c0bf3] part of check-in [1f9fa585] Add the ".parameter" command to the CLI. (check-in: [1f9fa585] user: drh branch: trunk, size: 300275)
2019-02-26
15:43
[89848d1e] part of check-in [7d8e8a95] Add the ".shared-schema check|fix DB1 DB2..." command to the shell tool. For checking if a database is eligible to share an in-memory with the main database, and for fixing small problems that prevent it from being so. (check-in: [7d8e8a95] user: dan branch: reuse-schema, size: 302872)
2019-02-25
18:43
[a238f3f8] part of check-in [7c941ce5] Enhance the command-line shell to accept bound parameters, using the TEMP table named "$Parameters" to look up the values for bound parameters. (check-in: [7c941ce5] user: drh branch: trunk, size: 295995)
2019-02-14
18:38
[d7d63fd1] part of check-in [7257fcc8] Change the name of the SQLITE_OPEN_REUSE_SCHEMA flag to SQLITE_OPEN_SHARED_SCHEMA. (check-in: [7257fcc8] user: dan branch: reuse-schema, size: 294959)
2019-02-11
20:13
[e32838e3] part of check-in [dbedd81b] Merge latest trunk changes into this branch. (check-in: [dbedd81b] user: dan branch: reuse-schema, size: 294960)
2019-02-05
20:51
[f2c1adbe] part of check-in [4d0a949f] Omit the ".progress" command from the shell if it is compiled with the SQLITE_OMIT_PROGRESS_CALLBACK option. (check-in: [4d0a949f] user: drh branch: trunk, size: 294398)
19:51
[d3c5b1c0] part of check-in [c089cc4f] Merge latest trunk into this branch. (check-in: [c089cc4f] user: dan branch: reuse-schema, size: 294723)
19:48
[b5149a7d] part of check-in [4978ee8b] Fix compiler warnings on Windows. (check-in: [4978ee8b] user: drh branch: trunk, size: 294191)
2019-02-04
19:52
[72a09544] part of check-in [ada91aef] Mention the new -memtrace command-line option in the -help output of the CLI. (check-in: [ada91aef] user: drh branch: trunk, size: 294161)
14:53
[d9898bed] part of check-in [ad84ca24] Add the ".progress" command to the CLI. (check-in: [ad84ca24] user: drh branch: trunk, size: 294084)
2019-01-27
19:50
[705a00be] part of check-in [42687d45] Improvements to the ".eqp trace" command in the CLI so that it ensures that the schema has been read prior to activing the tracing feature, to avoid cluttering the output with a trace of the schema parse. (check-in: [42687d45] user: drh branch: trunk, size: 291271)
2019-01-26
15:40
[324bc8df] part of check-in [626502fa] Add the ".eqp trace" command to the CLI when using SQLITE_DEBUG, as a convenient shorthand for "PRAGMA vdbe_debug=ON" but with automatic indentation feature for program listings provided by the CLI. (check-in: [626502fa] user: drh branch: trunk, size: 291264)
2019-01-22
16:44
[58f69c91] part of check-in [a7126a4f] Use _strdup() instead of strdup() on Windows builds of the CLI, to avoid a compiler warning reported on the mailing list. (check-in: [a7126a4f] user: drh branch: trunk, size: 290484)
16:06
[7649cd10] part of check-in [30f08d58] Enhancements to deserialize: (1) Add the SQLITE_FCNTL_SIZE_LIMIT file control to set a maximum size for an in-memory database, defaulting to SQLITE_MEMDB_DEFAULT_MAXSIZE or 1GiB. (2) Honor the SQLITE_DESERIALIZE_READONLY flag. (3) Enhance the TCL interface to support -maxsize N and -readonly BOOLEAN. (4) Add the --maxsize option to the ".open" command and on the command-line for the CLI. (check-in: [30f08d58] user: drh branch: trunk, size: 290435)
2019-01-21
14:55
[58b94d24] part of check-in [a1e12fa2] Add the --memtrace option to the CLI. (check-in: [a1e12fa2] user: drh branch: trunk, size: 289620)
2019-01-11
17:19
[b3cd745b] part of check-in [2a47387b] Omit errors about missing SAVEPOINTs when aborting the .archive command in the CLI. (check-in: [2a47387b] user: drh branch: trunk, size: 289454)
2019-01-04
14:29
[0722a9e3] part of check-in [d7f55c62] If the ".open" command fails in the CLI, reopen to :memory: so that at least some database is available for subsequent commands. (check-in: [d7f55c62] user: drh branch: trunk, size: 289438)
2018-12-17
22:19
[207da303] part of check-in [d64f248d] Move variable declaration to address compilation issue (C89). (check-in: [d64f248d] user: mistachkin branch: trunk, size: 289379)
2018-12-13
22:58
[e1790e0d] part of check-in [18740bd4] Fix the dbtotxt decoder in the CLI so that it ignores excess bytes. (check-in: [18740bd4] user: drh branch: trunk, size: 289369)
18:59
[a9b26ab3] part of check-in [7ffa9858] Fix the CLI to keep proper track of input line numbers for use in error messages, even after processing in-line hex database inputs using ".open --hexdb". (check-in: [7ffa9858] user: drh branch: trunk, size: 289457)
18:30
[b998c6d7] part of check-in [67a87399] Fix the CLI so that the ".open --hexdb" command works even if it is contained in a subscript that is read using ".read". (check-in: [67a87399] user: drh branch: trunk, size: 289174)
15:06
[6c06ff40] part of check-in [e3bf1d3e] Add the "dbtotxt" utility program and the ability to read "dbtotxt" output as a deserialized input database in the CLI, using the --hexdb option to the ".open" command. (check-in: [e3bf1d3e] user: drh branch: trunk, size: 289014)
2018-12-08
01:09
[5f38bd0e] part of check-in [7b6a605b] Add the --async option to the ".backup" command in the CLI. (check-in: [7b6a605b] user: drh branch: vacuum-into, size: 286173)
2018-12-05
13:39
[1f0819e6] part of check-in [7da617e9] Enhance the sqlite3_normalize_sql() interface so that it works even if the prepared statement was not initially compiled using SQLITE_PREPARE_NORMALIZED. Enhance the ".trace" command in the CLI so that it is able to access the full scope of functionality provided by sqlite3_trace_v2() and in particular so that it is able to show normalized SQL output using the newly enhanced sqlite3_normalize_sql() interface. (check-in: [7da617e9] user: drh branch: trunk, size: 285865)
2018-11-26
18:09
[482e23a3] part of check-in [6e133054] Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. (check-in: [6e133054] user: drh branch: trunk, size: 282805)
2018-11-17
18:45
[91ccfc85] part of check-in [9fdd1868] Merge latest trunk changes into this branch. (check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 283233)
2018-11-16
14:36
[6a9d8a56] part of check-in [d584a0cb] In order to avoid exporting a symbol, use a macro instead of a function to replace sqlite3_complete() in the shell code when SQLITE_OMIT_COMPLETE is defined. (check-in: [d584a0cb] user: dan branch: trunk, size: 282671)
2018-11-15
21:20
[9f517c22] part of check-in [31b6aee7] Fix some problems with the feature on this branch. Many problems remain. (check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 283255)
2018-11-09
18:44
[37a6b4c3] part of check-in [ae88f8e1] Merge latest trunk changes with this branch. (check-in: [ae88f8e1] user: dan branch: reuse-schema, size: 283253)
2018-11-03
16:09
[060ccc32] part of check-in [af3f29d4] Add the SQLITE_DBCONFIG_DEFENSIVE flag. (check-in: [af3f29d4] user: drh branch: dbconfig-defensive, size: 282693)
2018-10-30
15:31
[f5a89e43] part of check-in [90b2a684] Modify the CLI so that the --deserialize option is only available if it is compiled with SQLITE_ENABLE_DESERIALIZE. DESERIALIZE is now off by default for the main.mk makefile, but on for Makefile.in and Makefile.msc. (check-in: [90b2a684] user: drh branch: trunk, size: 282621)
14:36
[a1fa7476] part of check-in [7989bbda] In the CLI, when opening a file that begins with the normal SQLite prefix, open the file as a normal database even if it has a ZIP for AppendVFS record at the end. (check-in: [7989bbda] user: drh branch: trunk, size: 282416)
13:19
[ac4a731d] part of check-in [5e0129ee] Enable sqlite3_deserialize() in the CLI. The --deserialize option associated with opening a new database cause the database file to be read into memory and accessed using the sqlite3_deserialize() API. This simplifies running tests on a database without risk of modifying the file on disk. (check-in: [5e0129ee] user: drh branch: trunk, size: 282282)
2018-10-11
16:53
[248af8c0] part of check-in [1916d291] Fix harmless compiler warnings in the CLI. (check-in: [1916d291] user: drh branch: trunk, size: 281318)
10:37
[fa815984] part of check-in [ec36d15a] In the CLI, fix a file descriptor leak following OOM and a missing va_end() call. (check-in: [ec36d15a] user: drh branch: trunk, size: 281308)
2018-10-10
18:56
[d574c3be] part of check-in [696e82f7] In the CLI, allow the SQLITE_HISTORY environment variable, if it exists, to specify an alternative file in which to store the shell edit history. (check-in: [696e82f7] user: drh branch: trunk, size: 281277)
2018-10-08
23:29
[f6c19d23] part of check-in [3869b210] Add the ability to open a database connection in -reuseschema mode in the CLI. Adjust memory allocation accounting so that a shared schema is allocated across each database sharing it. (check-in: [3869b210] user: drh branch: reuse-schema, size: 281712)
2018-10-06
14:38
[09342e09] part of check-in [aac8f1df] Fix the ".help -all" option in the command-line shell. (check-in: [aac8f1df] user: drh branch: trunk, size: 281181)
2018-10-03
11:13
[6046da2a] part of check-in [bf0a6634] Change a type in shell.c.in from "int" to "sqlite3_int64" in order to avoid a compiler warning and possible integer overflow. (check-in: [bf0a6634] user: dan branch: trunk, size: 281060)
2018-09-26
18:02
[2162b1dc] part of check-in [edc3d18e] Further improvements to the ".help" command in the CLI. (check-in: [edc3d18e] user: drh branch: trunk, size: 281050)
16:53
[03d87b06] part of check-in [209afb8d] Begin revamping the ".help" command in the command-line shell so that it can accept an argument and will do a search for commands that match that argument. (check-in: [209afb8d] user: drh branch: trunk, size: 280262)
2018-08-06
02:08
[6e0aad85] part of check-in [20c995d3] Enhance the edit() function so that it converts text from \r\n back into \n only if the original unedited copy contained no \r\n values. (check-in: [20c995d3] user: drh branch: trunk, size: 278499)
2018-07-29
18:56
[5e4c1397] part of check-in [e390023c] In the command-line shell, always exit if realloc() fails. (check-in: [e390023c] user: drh branch: trunk, size: 277889)
2018-07-22
06:25
[f6ebd05c] part of check-in [21510a66] In the Win32 VFS, when truncating a file, unmap it first. (check-in: [21510a66] user: mistachkin branch: trunk, size: 277850)
2018-07-18
19:09
[239aee55] part of check-in [a5087c5c] Add the SQLITE_FCNTL_DATA_VERSION file control (check-in: [a5087c5c] user: drh branch: trunk, size: 277405)
2018-07-05
17:35
[f1c79c53] part of check-in [11763cac] Fix the .dump command in the command-line shell so that it does not show extraneous SELECT statements when ".echo on" is enabled. (check-in: [11763cac] user: drh branch: trunk, size: 277235)
2018-06-19
21:15
[5473740b] part of check-in [7fa8f16e] Make the ieee754() a built-in function. Add the --ieee754 option to the ".dump" command in the shell to cause it to output floating-point values as ieee754() calls, so that the floating point number will be reproduced exactly. Not sure yet that we want to go this way, but it is one option. (check-in: [7fa8f16e] user: drh branch: ieee754, size: 278242)
2018-06-13
17:19
[8578421c] part of check-in [ee431d55] Output infinity as 1e999 in the ".dump" command of the command-line shell. (check-in: [ee431d55] user: drh branch: trunk, size: 277148)
2018-06-07
17:32
[4d0ddf10] part of check-in [439c8162] Remove the NextIfOpen and PrevIfOpen opcodes which are no longer needed when the IN-early-out optimization is working. (check-in: [439c8162] user: drh branch: multikey-opt-idea, size: 276877)
15:23
[3151c40b] part of check-in [bb87c054] Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. (check-in: [bb87c054] user: drh branch: trunk, size: 276932)
2018-06-06
01:18
[099edada] part of check-in [27291f2d] Fix the ".archive" command in the CLI (and the corresponding -A command-line option) so that it silently ignores filenames that contain "../" in their names. This prevents the "Zip Slip" attack. (check-in: [27291f2d] user: drh branch: trunk, size: 276890)
2018-05-30
07:24
[c29cb307] part of check-in [80883980] Fix a typo in an error message in the CLI. (check-in: [80883980] user: drh branch: trunk, size: 276853)
2018-05-18
17:11
[51c10020] part of check-in [e3b2e0a0] In the CLI, detect and report errors on sqlite3_close(). Clear global variables prior to exit to so that valgrind can better detect resource leaks. (check-in: [e3b2e0a0] user: drh branch: trunk, size: 276857)
2018-05-17
20:04
[e0f00698] part of check-in [33dc8fad] In the CLI with the -A command, if the file does not previously exist and its name looks like a ZIP archive name, then create it as a ZIP archive. (check-in: [33dc8fad] user: drh branch: trunk, size: 276466)
14:09
[d9154a6b] part of check-in [02541ac6] Improved error and help messages for the ".archive" command and "-A" option to the CLI. If a memory leak in --list processing. (check-in: [02541ac6] user: drh branch: trunk, size: 275815)
13:29
[e4086ed1] part of check-in [4474d69b] Fix memory errors associated with argv in the CLI when it is compiled on Windows. (check-in: [4474d69b] user: drh branch: trunk, size: 275414)
2018-05-14
12:23
[53affa90] part of check-in [389dc0a9] Fix typo in the shell.c source file. (check-in: [389dc0a9] user: mistachkin branch: trunk, size: 275230)
00:41
[bd7ea498] part of check-in [d0f35739] Export the deduceDatabaseType() function the shell.c source file. (check-in: [d0f35739] user: drh branch: trunk, size: 275232)
00:23
[05d9da22] part of check-in [0dfdbdee] Add the --append option to the ".backup" command in the CLI. (check-in: [0dfdbdee] user: drh branch: trunk, size: 275239)
2018-05-12
23:56
[df40a09c] part of check-in [4ee136d6] In the CLI, allow comment lines that begin with '#', but only in a context where a dot-command is allowed. In other words, '#' at the beginning of a line in the middle of an SQL statement is just part of the SQL. (check-in: [4ee136d6] user: drh branch: trunk, size: 275031)
2018-05-11
19:11
[4caa8c44] part of check-in [13e7300a] In the CLI, return non-zero if there are errors on the command-line. (check-in: [13e7300a] user: drh branch: trunk, size: 274949)
14:02
[c625e817] part of check-in [e76f676c] Fix a typo in the help message from the ".sha3sum" command in the CLI. (check-in: [e76f676c] user: drh branch: geojson, size: 274908)
14:00
[c696c384] part of check-in [2b8fd3b4] Make sure the open_db() routine in the CLI does not invoke access() with a NULL filename. (check-in: [2b8fd3b4] user: drh branch: geojson, size: 274908)
2018-05-08
23:17
[df233d55] part of check-in [0c3f128f] Correctly format the STAT1 and STAT4 content in the output from the ".fullschema" command in the CLI. Fix for ticket [e63a34a0045832dc850367552]. (check-in: [0c3f128f] user: drh branch: trunk, size: 274786)
2018-05-07
11:37
[e41979d8] part of check-in [374d8e26] Fix harmless compiler warnings associated with the new EXPLAIN QUERY PLAN logic. (check-in: [374d8e26] user: drh branch: trunk, size: 274774)
2018-05-02
00:33
[29309f2a] part of check-in [70b48a79] Begin reengineering the EXPLAIN QUERY PLAN function to provide more intuitive output. (check-in: [70b48a79] user: drh branch: rework-EQP, size: 274769)
2018-04-28
12:43
[54b902ab] part of check-in [ff836cb8] Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for the reset_database pragma. Resetting the database should be hard enough to do that it cannot be done by accident. (check-in: [ff836cb8] user: drh branch: reset-database, size: 274862)
2018-04-27
20:49
[d751c9e8] part of check-in [7b2a65a6] Better comments on the bindvtab.c implementation. All the two-argument version of the .set command. All bindings from .set and -D are still string. (check-in: [7b2a65a6] user: drh branch: shell-bindings, size: 274547)
17:39
[3bac9ab3] part of check-in [1f2944d1] Add the ability to use bind parameters in the CLI. The new ".set KEY=VALUE" dot-command works to set bindings. Or use the "-Dkey=value" command-line option. Or use the built-in shell_bindings(k,v) virtual table to set, delete, or changing bindings. (check-in: [1f2944d1] user: drh branch: shell-bindings, size: 274241)
2018-04-25
19:02
[d63f06c8] part of check-in [7dd34e37] Add new interfaces for accessing the list of SQL keywords: sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check(). (check-in: [7dd34e37] user: drh branch: trunk, size: 273403)
17:10
[be819b84] part of check-in [77a98a07] Add the new DO and NOTHING keywords to the keyword lists maintained by various extensions and auxiliary programs. (check-in: [77a98a07] user: drh branch: trunk, size: 275440)
13:27
[38aa5740] part of check-in [3bcdbccf] Add the new SQLITE_SHELL_INIT_PROC compile-time entry point to the CLI. This is needed to work around the tighter sqlite3_config() constraints now in the CLI. (check-in: [3bcdbccf] user: drh branch: trunk, size: 275419)
2018-04-24
13:07
[fc3f9e47] part of check-in [f53716ee] Enhance the CLI to render EXPLAIN QUERY PLAN using an ASCII-art graph. This works with ".eqp" modes and when the query begins with exactly "EXPLAIN QUERY PLAN". To see the original output format, add extra space characters in between words of the initial "EXPLAIN QUERY PLAN". (check-in: [f53716ee] user: drh branch: trunk, size: 274990)
2018-04-23
18:38
[4115df36] part of check-in [d3dad06f] Add the ".imposter off" variant of the ".imposter" dot-command in the CLI. (check-in: [d3dad06f] user: drh branch: trunk, size: 271465)
2018-04-18
19:56
[8ab4687d] part of check-in [ef74090a] Add the "sorter-reference" optimization, allowing SQLite to be configured so that some required values may be loaded from the database after external sorting occurs for SELECT statements with ORDER BY clauses that are not satisfied by database indexes. (check-in: [ef74090a] user: dan branch: trunk, size: 271230)
15:21
[6c9e2c11] part of check-in [902a4089] Add the --sorterref N option to the CLI. (check-in: [902a4089] user: drh branch: sorter-reference, size: 270604)
10:44
[bcde676b] part of check-in [40b11734] Add checks to the CLI that issue a warning if SQLite gets initialized prior to the last sqlite3_config() call. (check-in: [40b11734] user: drh branch: trunk, size: 270795)
09:16
[7fbdc5c5] part of check-in [89209000] Fix a problem in the shell preventing it from working with SQLITE_OMIT_AUTOINIT builds. (check-in: [89209000] user: dan branch: trunk, size: 270391)
2018-04-10
10:37
[cc960721] part of check-in [80b75a34] Remove an unnecessary SQLITE_UNTESTABLE compile-time conditional from the command-line shell. (check-in: [80b75a34] user: drh branch: trunk, size: 270169)
2018-03-23
16:08
[d6a07811] part of check-in [0477fb3f] Fix the -readonly option on the CLI so that it actually works. (check-in: [0477fb3f] user: drh branch: trunk, size: 270208)
14:24
[8e7fb346] part of check-in [98e3f524] Enhance .schema in shell to enable matching patterns with literal underscores. (check-in: [98e3f524] user: mistachkin branch: trunk, size: 270123)
13:18
[be2afd4b] part of check-in [71d5f6e6] Fix an error in the CLI in the previous ([0249d9aecf69948]) check-in. Only the pattern to sqlite3_strlike() need to be escaped. (check-in: [71d5f6e6] user: drh branch: trunk, size: 269926)
12:59
[f5687352] part of check-in [0249d9ae] Fix the ANALYZE command so that it will process tables whose names begin with "sqlite" as long as they do not being with "sqlite_". (check-in: [0249d9ae] user: drh branch: trunk, size: 269938)
00:31
[211a99f5] part of check-in [2f2be1b1] Fix harmless compiler warnings seen with MSVC. (check-in: [2f2be1b1] user: mistachkin branch: trunk, size: 269921)
2018-03-20
12:04
[911b9e3b] part of check-in [427bbf31] In the CLI, avoid extra .selecttrace and .wheretrace output when in ".eqp full" mode. (check-in: [427bbf31] user: drh branch: push-down-disable, size: 269869)
2018-03-17
16:26
[52b1b3f5] part of check-in [442e816b] Do not use sqlite3_column_decltype() in the CLI if it is compiled with SQLITE_OMIT_DECLTYPE. (check-in: [442e816b] user: drh branch: trunk, size: 269651)
2018-03-14
14:53
[9b7e7ac1] part of check-in [3faeb851] Add the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() (check-in: [3faeb851] user: drh branch: dbstatus-cache-spill, size: 269621)
2018-03-09
22:18
[b0aad885] part of check-in [3c2e3c2d] Fix the .archive command in the CLI so that it actually compresses content. (check-in: [3c2e3c2d] user: drh branch: trunk, size: 269444)
21:54
[b499275d] part of check-in [9404765e] Enhance the ".ar" command in the CLI so that it is able to update and create ZIP Archives. (check-in: [9404765e] user: drh branch: trunk, size: 269459)
16:37
[75490510] part of check-in [7fea00fd] Setting ".stats 2" in the CLI causes column metadata for each prepared statement to be displayed. (check-in: [7fea00fd] user: drh branch: trunk, size: 267987)
15:24
[23eb7501] part of check-in [72e8f529] Simplification to the shell_exec() mechanism in the CLI. (check-in: [72e8f529] user: drh branch: trunk, size: 266589)
2018-03-08
18:14
[edbc1b73] part of check-in [f010c86e] Add the --append and --zip options of the CLI to the --help message. (check-in: [f010c86e] user: drh branch: trunk, size: 267385)
2018-03-05
20:21
[8c6ea9b4] part of check-in [d937ac18] Improved command-line help for the -A option on the CLI. (check-in: [d937ac18] user: drh branch: trunk, size: 267217)
20:20
[4b2b00d2] part of check-in [9d8081fa] A new way of doing archive commands on the command-line for the CLI. The -A option means that everything that follows is a ".archive" command, including any suffix on the -A option. (check-in: [9d8081fa] user: drh branch: trunk, size: 267223)
19:34
[2115621c] part of check-in [a5c4d30a] In the CLI, add a new command-line option "--archive" (also "--ar") that passes all subsequent arguments to the ".archive" command. (check-in: [a5c4d30a] user: drh branch: trunk, size: 267131)
2018-02-26
16:49
[47dac081] part of check-in [7b3a7551] Fix heap issue in the shell on Win32 caused by allocator mismatch. (check-in: [7b3a7551] user: mistachkin branch: trunk, size: 266335)
2018-02-15
01:03
[c1b14bc0] part of check-in [00707f2f] Fix the --heap, --pagecache, --lookaside and other options to the command-line shell that invoke sqlite3_config() so that they work again. (check-in: [00707f2f] user: drh branch: trunk, size: 266351)
2018-02-14
23:27
[6fdccd0a] part of check-in [06870bb1] Add the --readonly option to the ".open" command in the CLI. (check-in: [06870bb1] user: drh branch: trunk, size: 265777)
2018-02-04
20:33
[0b2c8d55] part of check-in [a3591fb5] In the CLI, make sure sqlite3_initialize() is called correctly even for non-UTF8 hosts. (check-in: [a3591fb5] user: drh branch: trunk, size: 265266)
2018-01-31
01:38
[ada6d184] part of check-in [32ed9c10] Changes to the autoconf tarball so that it does not try to use system() when building on iOS. (check-in: [32ed9c10] user: drh branch: trunk, size: 265266)
2018-01-24
01:58
[7cea439c] part of check-in [c3e816cc] Make the shell functional even if compiled with SQLITE_OMIT_COMPLETE. Omit the sqlite3_complete() call from the fuzzing interface if it is compiled with SQLITE_OMIT_COMPLETE. (check-in: [c3e816cc] user: drh branch: trunk, size: 264887)
2018-01-23
00:05
[06ffe417] part of check-in [76a11a80] Fix harmless compiler warnings seen with MSVC. (check-in: [76a11a80] user: mistachkin branch: trunk, size: 264537)
2018-01-17
13:15
[4e1bcf8c] part of check-in [bfbeffab] Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. (check-in: [bfbeffab] user: drh branch: trunk, size: 264478)
2018-01-16
20:05
[568aacb5] part of check-in [231679d6] Move the ZLIB version announcement in the CLI out of the default banner and put it in the ".version" command. (check-in: [231679d6] user: drh branch: trunk, size: 264412)
19:03
[594f9427] part of check-in [a8906b52] Show version of zlib in use when running the shell tool in interactive mode. (check-in: [a8906b52] user: mistachkin branch: trunk, size: 263906)
2018-01-11
00:38
[b87abffd] part of check-in [b8d92d8d] Update the .help screen in the CLI. Make sure the temporary files for ".open" are not deleted too soon. (check-in: [b8d92d8d] user: drh branch: trunk, size: 263821)
00:04
[52aef9f2] part of check-in [ef823c47] Add the built-in edit(VALUE) and edit(VALUE,EDITOR) function to the CLI. (check-in: [ef823c47] user: drh branch: trunk, size: 263624)
2018-01-10
22:27
[0baa3d01] part of check-in [f697c164] Save and restore the output mode when doing ".once -x" or ".excel". (check-in: [f697c164] user: drh branch: excel-shell-cmd, size: 260228)
22:15
[8ac56c0e] part of check-in [9b97f9d2] An attempt to get ".once -e" working reliably on Windows. (check-in: [9b97f9d2] user: drh branch: excel-shell-cmd, size: 259613)
21:50
[362e3af7] part of check-in [9b95ff1a] Fix a potential SQLITE_MISUSE in the .excel command when no database is open. (check-in: [9b95ff1a] user: drh branch: excel-shell-cmd, size: 259450)
21:41
[d1dbc151] part of check-in [23fa7c57] Add support for the ".excel" command (and ".once -e" and ".once -x") in the CLI. (check-in: [23fa7c57] user: drh branch: excel-shell-cmd, size: 259429)
18:09
[2e72b9dc] part of check-in [58e3b07c] Modify the new "--append" option to the .archive so that it takes a filename argument, the same as "--file". (check-in: [58e3b07c] user: drh branch: trunk, size: 256958)
17:39
[4cb216da] part of check-in [612b30c9] Fix minor problems with the new ".archive" command changes. (check-in: [612b30c9] user: drh branch: archive-improvements, size: 256930)
17:19
[926858c0] part of check-in [52d12ba9] In the fileio.c extension, change the filetype(MODE) function into lsmode(MODE). Use the new lsmode(MODE) function in shell.c. (check-in: [52d12ba9] user: drh branch: archive-improvements, size: 256791)
16:50
[f8ae3a79] part of check-in [28ab9304] Implement the ".ar --create" command using a single "REPLACE INTO sqlar SELECT ... FROM fsdir();" statement. Add the shell_putsnl() SQL function for providing --verbose output. (check-in: [28ab9304] user: drh branch: archive-improvements, size: 257405)
15:17
[7d49ed78] part of check-in [430d1a7d] The ".ar" command deduces whether or not the target file is a ZIP or SQLAR and does the appropropriate thing. The "-z" option is omitted. The "--append" option is added to open auxiliary databases using apndvfs. (check-in: [430d1a7d] user: drh branch: archive-improvements, size: 258215)
13:44
[aae06c14] part of check-in [55116dc3] Checked into the wrong branch. (check-in: [55116dc3] user: drh branch: mistake, size: 257638)
13:11
[f86200b0] part of check-in [a2baada4] Work on the ".archive" command. (1) Add the --dryrun option. (2) Do not require --file when open on a ZIP archive. (3) Miscellaneous code simplifications. This is an incremental check-in of work in progress. (check-in: [a2baada4] user: drh branch: archive-improvements, size: 257380)
00:53
[1e50d66d] part of check-in [fd7f51a1] Rearrange some routines in shell.c to avoid the need to forward reference a static function. (check-in: [fd7f51a1] user: drh branch: trunk, size: 256677)
2018-01-09
15:57
[4121ecd9] part of check-in [6ee7b54c] Fix another -fsanitize issue in new shell code. (check-in: [6ee7b54c] user: dan branch: trunk, size: 256729)
15:25
[2a752aed] part of check-in [931421a2] Fix the shell so that it can be built with SQLITE_OMIT_VIRTUALTABLE. (check-in: [931421a2] user: dan branch: trunk, size: 256675)
00:28
[fb615970] part of check-in [4a723614] Improve portability of compile-time MinGW detection for the command line shell. (check-in: [4a723614] user: mistachkin branch: trunk, size: 256478)
2018-01-08
19:59
[2aa65d15] part of check-in [7e7e472f] Update the zipfile module so that it matches the documentation. (check-in: [7e7e472f] user: dan branch: trunk, size: 256474)
17:05
[be04d679] part of check-in [fe053b2e] Fix a malloc/sqlite3_free mismatch in the shell tool code. (check-in: [fe053b2e] user: dan branch: trunk, size: 256508)
2018-01-07
21:58
[0e20ac49] part of check-in [0a50c9e3] Remove the dependency on test_windirent.h from the generated shell.c file. (check-in: [0a50c9e3] user: drh branch: trunk, size: 256468)
20:38
[ffcef0e1] part of check-in [67c4a8c6] Modify the sqltclsh startup script to look for a properly formatted SQLAR at the end of the executable. Fix the CLI so that it automatically links against appendvfs and so that the --append command-line option works. (check-in: [67c4a8c6] user: drh branch: trunk, size: 256443)
2018-01-06
21:46
[c2231d96] part of check-in [05c99eb8] The shell detects and opens ZIP archives using the zipfile extension. (check-in: [05c99eb8] user: drh branch: trunk, size: 256185)
19:19
[9f2ab2d0] part of check-in [366469f5] In the shell, include the ".archive" command only if compiling with SQLITE_HAVE_ZLIB. Add ".archive" to the ".help" output. (check-in: [366469f5] user: drh branch: trunk, size: 253918)
15:49
[1f1d02e8] part of check-in [252ee55a] Better whitespace in the "CREATE TABLE sqlar()" statement for the ".ar" command. (check-in: [252ee55a] user: drh branch: trunk, size: 253324)
15:46
[8874828e] part of check-in [87da7eff] Improved output from ".schema --indent" when a column definition is followed by a comment. (check-in: [87da7eff] user: drh branch: trunk, size: 253308)
2018-01-05
21:01
[4cfa9394] part of check-in [656fb5aa] Make sure i64 and u64 typedefs are available throughout shell.c. (check-in: [656fb5aa] user: drh branch: trunk, size: 252819)
20:26
[df0e5728] part of check-in [73023feb] MinGW does not define the S_ISLNK macro; therefore, define it in the shell when needed. (check-in: [73023feb] user: mistachkin branch: trunk, size: 252764)
20:08
[54b689b5] part of check-in [dfe510b5] Fix shell compilation with MinGW by including the 'dirent.h' header. (check-in: [dfe510b5] user: mistachkin branch: trunk, size: 252708)
14:55
[17fc2866] part of check-in [364ac333] Fix compiler warnings. (check-in: [364ac333] user: drh branch: sqlar-shell-support, size: 252583)
00:53
[f57fa72e] part of check-in [a0e18aea] Add missing #ifdef. (check-in: [a0e18aea] user: mistachkin branch: sqlar-shell-support, size: 252707)
2018-01-04
22:50
[84af7b92] part of check-in [57dac995] Remove 'timespec' related code from the shell that has no effect and a (now) superfluous 'timespec' typedef from the Win32 dirent header file. (check-in: [57dac995] user: mistachkin branch: sqlar-shell-support, size: 252676)
22:46
[e17f15b3] part of check-in [335387f9] Get the shell enhancements compiling with MSVC. (check-in: [335387f9] user: mistachkin branch: sqlar-shell-support, size: 252769)
19:54
[3e2db269] part of check-in [406f7918] Merge in all recent trunk enhancements. (check-in: [406f7918] user: drh branch: sqlar-shell-support, size: 252625)
2018-01-03
23:54
[23b0207a] part of check-in [512b8e40] Fix compiler warnings on Windows. (check-in: [512b8e40] user: drh branch: memdb, size: 231374)
2018-01-02
12:50
[a418ddce] part of check-in [39ca5fcd] Do not attempt to use pragma_module_list in the command-line shell unless it has been compiled with -DSQLITE_INTROSPECTION_PRAGMAS. (check-in: [39ca5fcd] user: drh branch: trunk, size: 231372)
00:04
[6b1ec35f] part of check-in [f80f6651] The ".schema" command in the command-line shell now shows the structure of table-valued functions and eponymous virtual tables if they are named on the ".schema" command line. Example: ".schema sql%" shows the structure of the "sqlite_dbstat" and "sqlite_stmt" virtual tables. (check-in: [f80f6651] user: drh branch: trunk, size: 231329)
2018-01-01
21:49
[e0d3ef67] part of check-in [d64b14e3] Improved name quoting and escaping in the auxiliary column info section of the ".schema" output for views and virtual tables. (check-in: [d64b14e3] user: drh branch: trunk, size: 230411)
21:28
[f151a118] part of check-in [2234a87f] In the output of ".schema", show the column names of virtual tables and views in a separate comment. (check-in: [2234a87f] user: drh branch: trunk, size: 230031)
20:11
[a3f30523] part of check-in [add45c47] Minor simplification to the ".schema" logic in the command-line shell. (check-in: [add45c47] user: drh branch: trunk, size: 228677)
2017-12-27
21:13
[9177b6cc] part of check-in [b64681a6] Improve the shell tool ".ar --list --verbose" command. (check-in: [b64681a6] user: dan branch: sqlar-shell-support, size: 250054)
18:54
[d1be3030] part of check-in [a532a0f6] Have the shell tool ".ar --list" and ".ar --extract" commands support zip files. Currently the "-zip" switch is required. (check-in: [a532a0f6] user: dan branch: sqlar-shell-support, size: 248943)
2017-12-26
20:39
[1c927f94] part of check-in [8e366b99] Add new file ext/misc/zipfile.c, containing a virtual table for read-only access to simple zip archives. (check-in: [8e366b99] user: dan branch: sqlar-shell-support, size: 247569)
18:04
[f3ec8f90] part of check-in [1253a872] Add support for measuring and reporting coverage of the parser state machine using the SQLITE_TESTCTRL_PARSER_COVERAGE test-control. (check-in: [1253a872] user: drh branch: lemon-improvements, size: 229094)
2017-12-23
18:34
[e739db28] part of check-in [150f07fe] Merge enhancements from trunk. (check-in: [150f07fe] user: drh branch: sqlar-shell-support, size: 247500)
2017-12-21
21:02
[339169a3] part of check-in [2c51644a] Add the ".eqp trigger" option to the ".eqp" command in the command-line shell. Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control. (check-in: [2c51644a] user: drh branch: trunk, size: 228801)
18:55
[ef343d70] part of check-in [fc6193af] Add the ".expert" command to the shell tool's ".help" output. (check-in: [fc6193af] user: dan branch: trunk, size: 228204)
2017-12-19
17:42
[87a048fa] part of check-in [51068dba] Experimentally add the SQLite expert functionality to the shell tool. (check-in: [51068dba] user: dan branch: expert-in-shell, size: 228123)
2017-12-16
19:11
[ad8c13b9] part of check-in [7652b3c2] Do not use the compress() and uncompress() functions in ext/misc/compress.c - they are not quite compatible with the spec. Instead use new functions in ext/misc/sqlar.c. (check-in: [7652b3c2] user: dan branch: sqlar-shell-support, size: 242256)
2017-12-14
19:15
[074b2129] part of check-in [7b51269c] Have the writefile() function optionally set the modification-time of the files it writes or creates. And many small fixes to the new code on this branch. (check-in: [7b51269c] user: dan branch: sqlar-shell-support, size: 243234)
15:40
[4bdd2efe] part of check-in [b9d2d5d9] Improve error and usage messages output by the shell ".ar" command. (check-in: [b9d2d5d9] user: dan branch: sqlar-shell-support, size: 243209)
2017-12-13
20:17
[12313c05] part of check-in [825e3c03] Add the shell tool ".ar --update" command. (check-in: [825e3c03] user: dan branch: sqlar-shell-support, size: 241382)
20:04
[b53eddcb] part of check-in [32c4fa25] Add support for the "--list" command. And for arguments to the "--extract" command. (check-in: [32c4fa25] user: dan branch: sqlar-shell-support, size: 240689)
2017-12-12
20:28
[a09773c8] part of check-in [1a986797] Add tests and fixes for the shell ".ar" command -f option. (check-in: [1a986797] user: dan branch: sqlar-shell-support, size: 237416)
20:04
[0ab6e3c1] part of check-in [38dbeb1e] Add support for parsing options in non-traditional tar form to the ".ar" command. Have writefile() attempt to create any missing path components. And not to throw an exception if it is called to create a directory that already exists. (check-in: [38dbeb1e] user: dan branch: sqlar-shell-support, size: 237340)
2017-12-11
20:22
[4c7a2c12] part of check-in [0394889a] Enhance virtual table "fsdir" in ext/misc/fileio.c. Add support for "-C" to the shell command's ".ar c" command. (check-in: [0394889a] user: dan branch: sqlar-shell-support, size: 233622)
2017-12-09
18:28
[8e57abbd] part of check-in [8cd70960] Add support for -C to ".ar x". (check-in: [8cd70960] user: dan branch: sqlar-shell-support, size: 233763)
17:58
[907661ee] part of check-in [840401cc] Improve parsing of ".ar" commands. Add new test file for the same. (check-in: [840401cc] user: dan branch: sqlar-shell-support, size: 233426)
2017-12-07
21:03
[2f9ae0be] part of check-in [0cc699d1] Add the ".ar x" command to the shell. For extracting the contents of sqlar archives. (check-in: [0cc699d1] user: dan branch: sqlar-shell-support, size: 230700)
15:44
[56c4c091] part of check-in [c9827a01] Begin adding support for the sqlar archive format to shell.c. There is no "extract" command so far, only "create". (check-in: [c9827a01] user: dan branch: sqlar-shell-support, size: 229729)
2017-12-05
18:32
[ab727c09] part of check-in [0296286a] If SQLITE_HAVE_ZLIB is defined at build-time, include the functions in ext/misc/compress.c in the shell. (check-in: [0296286a] user: dan branch: sqlar-shell-support, size: 223689)
2017-12-01
18:40
[6ffed0c5] part of check-in [5771b1d6] Fix the ".lint fkey-indexes" shell command so that it works with WITHOUT ROWID tables. (check-in: [5771b1d6] user: dan branch: trunk, size: 223556)
2017-11-26
02:14
[c441d7dd] part of check-in [6500cdbd] Fix an CSV output quoting problem in the command-line shell on Windows. (check-in: [6500cdbd] user: drh branch: trunk, size: 223554)
2017-11-21
21:14
[cb1b5e41] part of check-in [9cb47430] Fix compilation issue (C99-ism) in the shell seen with MSVC. (check-in: [9cb47430] user: mistachkin branch: trunk, size: 223578)
2017-11-15
19:14
[a87f3094] part of check-in [1ca3b8cc] Futher improvements to the .testctrl interface in the shell. (check-in: [1ca3b8cc] user: drh branch: trunk, size: 223563)
17:07
[e261e3c2] part of check-in [5d66219c] UI improvements on the .testctrl dot-command in the shell. (check-in: [5d66219c] user: drh branch: trunk, size: 223981)
2017-10-27
17:09
[08cbffc3] part of check-in [c8aaf371] Handle the Ctrl-C event for the shell on Win32. (check-in: [c8aaf371] user: mistachkin branch: trunk, size: 223352)
2017-10-17
13:44
[f13262c8] part of check-in [e2af0cc6] Fix the ".check" command of the command-line shell to return 1 (error) rather than 2 (exit) on a test failure. (check-in: [e2af0cc6] user: drh branch: trunk, size: 222915)
2017-10-12
20:37
[5446de0a] part of check-in [eaeeb09d] Add the sqlite_dbpage virtual table (enabled using SQLITE_ENABLE_DBPAGE_VTAB). Make that virtual table and dbstat available to the command-line shell. (check-in: [eaeeb09d] user: drh branch: trunk, size: 222915)
10:28
[423944f4] part of check-in [5d0ceb8d] Make sure the tableColumnList() routine of the command-line shell does not cause a null-pointer dereference in an error condition. (check-in: [5d0ceb8d] user: drh branch: branch-3.21, size: 222773)
2017-10-11
18:26
[7842db26] part of check-in [48418f2e] Add the checkfreelist extension to the command-line shell. (check-in: [48418f2e] user: drh branch: dbpage, size: 222969)
17:51
[73d8000b] part of check-in [497409e1] Convert the implementation of the ".dbstat" dot-command of the command-line shell to use the sqlite_dbpage table. (check-in: [497409e1] user: drh branch: dbpage, size: 222888)
2017-10-05
19:12
[e03f7d47] part of check-in [4258fb57] Fix the command-line shell so that the ".schema --indent" command does a better job of dealing with \r\n in the middle of a CREATE statement in the schema. (check-in: [4258fb57] user: drh branch: trunk, size: 222746)
2017-09-13
18:38
[30d6799f] part of check-in [ebada072] Experimental sqlite3_stmt_retryable() interface. (check-in: [ebada072] user: drh branch: sqlite3_stmt_retryable, size: 223012)
2017-09-09
00:51
[bb9720a8] part of check-in [faa22e29] Fix harmless compiler warnings seen with MSVC. (check-in: [faa22e29] user: mistachkin branch: trunk, size: 222702)
2017-08-28
17:26
[6bd94bfe] part of check-in [cc440400] Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (check-in: [cc440400] user: drh branch: begin-concurrent-branch-3.19, size: 222631)
15:51
[af3fb9ea] part of check-in [54b00024] Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. (check-in: [54b00024] user: drh branch: trunk, size: 222701)
14:33
[31cd78c3] part of check-in [2348045f] Backport changes to shell.c into shell.c.in. (check-in: [2348045f] user: drh branch: trunk, size: 223870)
2017-07-18
20:59
[b5725aca] part of check-in [505fdc8f] Fix shell.c.in so that it aligns with shell.c. (check-in: [505fdc8f] user: drh branch: trunk, size: 223800)
2017-07-14
00:28
[dae43a6a] part of check-in [271ca4ac] Fix harmless compiler warnings in the readline tab-completion logic of the command-line shell. (check-in: [271ca4ac] user: drh branch: trunk, size: 223799)
2017-07-11
18:11
[98bfdeeb] part of check-in [55e93f25] Fix harmless compiler warnings in the core. (check-in: [55e93f25] user: drh branch: trunk, size: 223798)
13:59
[18510e3f] part of check-in [95cd1d9f] Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. (check-in: [95cd1d9f] user: drh branch: trunk, size: 223781)
13:34
Added: [9d75c83c] part of check-in [17e0bb12] Change the src/shell.c file so that it is generated from a new script at tool/mkshellc.tcl and the template file src/shell.c.in, and automatically includes the extensions it needs out of ext/misc. (check-in: [17e0bb12] user: drh branch: trunk, size: 221535)