Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of src/shell.c.in
2019-11-25
| ||
23:55 | Experimental file-controls for controlling the use of the -shm file. file: [6ecf8033] check-in: [12b8fa23] user: drh branch: reuse-shm, size: 339763 | |
2019-11-18
| ||
17:46 | Add support for SQLITE_OPEN_NOFOLLOW. file: [4a3a9e1c] check-in: [cb79c828] user: drh branch: trunk, size: 339285 | |
2019-11-07
| ||
19:59 | Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. file: [5e402d7f] check-in: [4ab9dbb9] user: drh branch: limit_heap_k, size: 338744 | |
2019-11-02
| ||
00:00 | Restore the on-line ".help" for the ".explain" command in the CLI. file: [c06961f2] check-in: [28b8f103] user: drh branch: trunk, size: 338669 | |
2019-10-29
| ||
16:18 | 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] file: [a17d143f] check-in: [4d424f30] user: drh branch: trunk, size: 338808 | |
2019-10-26
| ||
16:02 | Fix a problem in the legacy ".explain on" formatting when it is used on a query with more than 8 output columns. file: [01d14c1e] check-in: [070b4982] user: drh branch: trunk, size: 338735 | |
2019-10-18
| ||
15:58 | 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. file: [3093bdf5] check-in: [9dc0d345] user: drh branch: trunk, size: 338648 | |
2019-10-04
| ||
15:31 | Bring the reuse-schema branch up-to-date with version 3.30.0. file: [2c49eff3] check-in: [6e09afec] user: drh branch: reuse-schema, size: 346284 | |
2019-10-02
| ||
00:25 | Disable sqlite3_drop_module() tests when virtual tables are omitted from the build. file: [d70bcf63] check-in: [9f4035f9] user: drh branch: trunk, size: 337778 | |
2019-09-30
| ||
16:57 | Merge in the 3.30.0 beta 1 changes. file: [a2d3a981] check-in: [06796124] user: drh branch: reuse-schema, size: 346240 | |
2019-09-26
| ||
20:05 | 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. file: [026d8a5b] check-in: [e768179b] user: drh branch: trunk, size: 337734 | |
2019-09-16
| ||
12:35 | Merge all recent trunk enhancements into the reuse-schema branch. file: [f3f258a9] check-in: [27eb2236] user: drh branch: reuse-schema, size: 346493 | |
2019-09-14
| ||
16:44 | Add the --no-rowids option to the ".recover" command. file: [68698630] check-in: [01d71b94] user: dan branch: trunk, size: 337987 | |
2019-08-26
| ||
14:57 | Tweak the shell tool ".recover" command so that it can recover rows that consist of a rowid and no fields. file: [e5fb9150] check-in: [279ac7fd] user: dan branch: trunk, size: 337513 | |
12:50 | Enforce 80-character line discipline in the CLI. Minor improvements to the CLI built-in help. file: [596e4160] check-in: [9690013a] user: drh branch: trunk, size: 337505 | |
2019-08-23
| ||
23:05 | Fix the built-in edit() SQL function in the CLI so that it works with zero-length blobs. file: [9a0706cd] check-in: [e3249012] user: drh branch: trunk, size: 337676 | |
2019-08-19
| ||
20:35 | Omit the "_except" term from the name of the new interface. file: [e0f0758b] check-in: [e5ba47c2] user: drh branch: sqlite3_drop_modules_except, size: 337684 | |
2019-08-17
| ||
19:45 | The experimental sqlite3_drop_modules_except() interface. file: [e0754f1d] check-in: [0851db4d] user: drh branch: sqlite3_drop_modules_except, size: 337622 | |
15:27 | Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. file: [48f7a9ee] check-in: [9c4bca64] user: drh branch: trunk, size: 337239 | |
2019-08-16
| ||
22:58 | Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. file: [d2465e77] check-in: [31e34fa3] user: drh branch: trunk, size: 337233 | |
2019-08-15
| ||
21:27 | 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. file: [b748cfb4] check-in: [61b4bccd] user: drh branch: trunk, size: 336807 | |
2019-08-13
| ||
15:22 | Merge latest trunk changes with this branch. file: [42051fc4] check-in: [5b4689d8] user: dan branch: reuse-schema, size: 345240 | |
2019-08-12
| ||
16:25 | 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. file: [66cd8289] check-in: [636ca447] user: drh branch: trunk, size: 336734 | |
15:19 | Make the sha3 extension part of the amalgamation, enabled using SQLITE_ENABLE_SHA3. file: [4dac87db] check-in: [a48a7b78] user: drh branch: sha3, size: 336538 | |
14:17 | Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. file: [1b9efc93] check-in: [48d9b48a] user: drh branch: trunk, size: 336563 | |
2019-08-08
| ||
19:40 | Fix harmless compiler warnings. file: [920360b4] check-in: [1eef4dde] user: drh branch: trunk, size: 336478 | |
15:24 | 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. file: [3f2c64bf] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 336450 | |
2019-08-06
| ||
20:26 | Enhance the ".recover" output in the shell to use double-quotes around table and column identifiers. file: [97714cd5] check-in: [846d2d2d] user: drh branch: trunk, size: 336603 | |
18:40 | Add "PRAGMA foreign_keys=OFF;" to the start of the script output by ".recover", just as is done for ".dump". file: [486dbf00] check-in: [bfc29e62] user: dan branch: trunk, size: 335875 | |
2019-08-03
| ||
01:39 | 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. file: [e5351f14] check-in: [49aa3448] user: drh branch: prng-seed-test-control, size: 335580 | |
2019-08-02
| ||
20:45 | Add the SQLITE_TESTCTRL_PRNG_SEED test control. file: [5ab94c68] check-in: [3ac57231] user: drh branch: prng-seed-test-control, size: 335066 | |
2019-07-26
| ||
20:54 | Merge latest changes from trunk into this branch. file: [8b51039f] check-in: [7f1e4e4b] user: dan branch: reuse-schema, size: 343532 | |
2019-07-24
| ||
20:10 | Improve the ".recover" command so that it handles intkey pages linked into non-intkey b-trees, and vice-versa, better. file: [9c203a8c] check-in: [9c458acb] user: dan branch: trunk, size: 335026 | |
19:20 | Improve the ".recover" command's handling of corrupt database schemas. file: [8bc78eac] check-in: [becaaa4d] user: dan branch: trunk, size: 334636 | |
08:15 | 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. file: [68ef28e3] check-in: [87d76047] user: dan branch: trunk, size: 334601 | |
2019-07-17
| ||
15:05 | 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". file: [a571d51d] check-in: [9ec92939] user: drh branch: trunk, size: 334012 | |
07:23 | Add casts to shell.c.in to avoid warnings on systems where size_t is 32 bits. file: [360607dc] check-in: [fe014288] user: dan branch: trunk, size: 333862 | |
2019-07-13
| ||
17:21 | Fix a double-quoted string literal used in the ".schema" command of the CLI. file: [5c0171b6] check-in: [fcd937d9] user: drh branch: trunk, size: 333838 | |
2019-07-08
| ||
21:32 | Merge recent trunk enhancements into the reuse-schema branch. file: [46729dfe] check-in: [fae92fee] user: drh branch: reuse-schema, size: 342332 | |
2019-06-21
| ||
14:05 | Fix a typo in an option name for the .dbconfig command in shell.c.in: s/wriable_schema/writable_schema/ file: [82f8a473] check-in: [1c58522e] user: dan branch: trunk, size: 333826 | |
2019-06-17
| ||
13:56 | Improved interface to double-quoted string literal enabling/disabling. file: [6edadde4] check-in: [923cfd53] user: drh branch: new-dbconfig-options, size: 333826 | |
2019-06-14
| ||
21:25 | Add SQLITE_DBCONFIG options LEGACY_ALTER_TABLE, NO_DQS_SCHEMA, and NO_DQS. file: [21e30c2c] check-in: [1fad2092] user: drh branch: new-dbconfig-options, size: 333826 | |
2019-06-13
| ||
14:07 | Do not use the %lld printf conversion in the platform printf() as some legacy platforms do not support it. file: [ad3405c9] check-in: [f8696b60] user: drh branch: trunk, size: 333525 | |
13:52 | Fix a minor error in a test script, and harmless compiler warnings in the CLI code. file: [fec94208] check-in: [eaa34626] user: drh branch: trunk, size: 333447 | |
2019-06-05
| ||
14:29 | CLI enhancements: Add the ".filectrl" command. Make the ".testctrl" command visible to ".help". file: [9648bc20] check-in: [7b3a99fc] user: drh branch: trunk, size: 333437 | |
2019-06-04
| ||
18:21 | In the CLI, add a small delay (0.1 seconds) after launching the output command for ".once" before deleting the temporary file. file: [6a58aac0] check-in: [4979f138] user: drh branch: trunk, size: 329021 | |
2019-06-03
| ||
13:46 | In the CLI, add ".help" text for the .shared-schema command. file: [a0011aba] check-in: [3ba6f790] user: drh branch: reuse-schema, size: 337501 | |
2019-05-24
| ||
13:15 | The ".shared-schema" command in the CLI requires the sqlite_dbpage table, so disable it if the build does not include that extension. file: [ce8c9243] check-in: [0913ff4d] user: drh branch: reuse-schema, size: 337205 | |
2019-05-14
| ||
22:25 | Merge all the latest trunk enhancements into the reuse-schema branch. file: [9353bb93] check-in: [018f3199] user: drh branch: reuse-schema, size: 337121 | |
2019-05-10
| ||
17:50 | Fix harmless compiler warnings in the CLI. file: [6c992809] check-in: [2846bc04] user: drh branch: trunk, size: 328995 | |
2019-05-09
| ||
18:33 | Fix a problem in the ".recover" command allowing a circular loop of b-tree pages in a database file to cause an infinite loop. file: [1f3e8c70] check-in: [8d2a062e] user: dan branch: trunk, size: 328112 | |
18:13 | Make the ".schema" command in the CLI resistant to corrupt database files. file: [332af861] check-in: [f22c7e22] user: drh branch: trunk, size: 328115 | |
16:57 | Avoid long delays that can occur when ".recover"ing data from a database with a corrupt freelist. file: [6aa1d26e] check-in: [20f06bf2] user: dan branch: trunk, size: 328069 | |
14:15 | Have ".recover" handle cases where the sqlite_master table contains malformed SQL statements. file: [f5d3a1f3] check-in: [e736da9c] user: dan branch: trunk, size: 328057 | |
11:45 | Fix a problem with running the ".recover" command on a database that is zero pages in size. file: [517b3e2a] check-in: [47fa6534] user: dan branch: trunk, size: 328015 | |
11:18 | Improved error handling for the ".open --hexdb" command of the CLI. file: [5d0e2b03] check-in: [4fa831d5] user: drh branch: trunk, size: 327996 | |
2019-05-03
| ||
02:41 | Fix the ".open --hexdb" command in the CLI so that it works even with terminal input. file: [5470f088] check-in: [9b5d9434] user: drh branch: trunk, size: 328046 | |
2019-04-29
| ||
11:41 | Fix a buffer overwrite in shell.c.in (part of the new .recover code). file: [567236da] check-in: [92facbc7] user: dan branch: trunk, size: 328018 | |
2019-04-27
| ||
20:15 | Fix building the shell with SQLITE_OMIT_VIRTUAL_TABLE. And without SQLITE_ENABLE_DBPAGE_VTAB. file: [104bbae9] check-in: [425d708c] user: dan branch: dbdata, size: 328018 | |
19:36 | Add comments and fix formatting issues in new code in shell.c.in. file: [2316b9ee] check-in: [b91d819b] user: dan branch: dbdata, size: 327368 | |
18:47 | Add the "--lost-and-found" option to the ".recover" command. For setting the name of the orphaned rows table. file: [51f027f6] check-in: [67bb88e2] user: dan branch: dbdata, size: 326074 | |
15:35 | 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. file: [3701177f] check-in: [91df4b8e] user: dan branch: dbdata, size: 323450 | |
2019-04-26
| ||
21:11 | 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. file: [146dbc27] check-in: [7221f6e3] user: dan branch: dbdata, size: 323011 | |
17:20 | An experimental interface for retrieving the estimated cost and estimated number of output rows for a query. file: [7544d689] check-in: [1b25fa10] user: drh branch: cost-est, size: 302279 | |
15:40 | Fix another problem with database freelist handling in the ".recover" command. file: [44dce9f5] check-in: [bee2652a] user: dan branch: dbdata, size: 321983 | |
15:14 | Fix a locking-page related problem with the ".recover" command. file: [63b10758] check-in: [afdae104] user: dan branch: dbdata, size: 321918 | |
2019-04-25
| ||
20:06 | Merge latest trunk changes into this branch. file: [78004b10] check-in: [1da302d8] user: dan branch: dbdata, size: 321103 | |
19:23 | 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. file: [a3b1bb23] check-in: [8d2f52bb] user: dan branch: dbdata, size: 321119 | |
16:20 | Fix a bug preventing .recover from working on databases where the final page of the db is corrupt. file: [2e9b6b05] check-in: [959bbd11] user: dan branch: dbdata, size: 318831 | |
2019-04-24
| ||
20:48 | Improve the performance of the .recover command. file: [569ee1f7] check-in: [a5076831] user: dan branch: dbdata, size: 318774 | |
2019-04-23
| ||
20:48 | Have ".recover" handle "\r" and "\n" in the same way as ".dump". file: [6e56c606] check-in: [f95f0f02] user: dan branch: dbdata, size: 318346 | |
18:03 | Fixes for the ".recover" shell command. file: [6c02cbd1] check-in: [8dcc1d89] user: dan branch: dbdata, size: 316049 | |
15:30 | 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. file: [bcfa17eb] check-in: [4258e42d] user: drh branch: trunk, size: 302024 | |
2019-04-22
| ||
20:52 | Enhance the ".recover" command. Fix a problem with overflow pages in dbdata.c. file: [7dd0babc] check-in: [f193ca58] user: dan branch: dbdata, size: 314766 | |
2019-04-20
| ||
20:57 | Add the ".recovery" command to the shell tool. For recovering the maximum amount data from corrupt databases. Still needs work. file: [3646e448] check-in: [7461d2e1] user: dan branch: dbdata, size: 309929 | |
2019-04-17
| ||
23:32 | Work around lack of a C99 feature in MSVC. file: [903dafb0] check-in: [f6ebe1c2] user: mistachkin branch: msvc, size: 302272 | |
13:58 | Fix a typo in the CLI help output for the ".dump" command. file: [0d1a1abd] check-in: [57638248] user: drh branch: trunk, size: 302042 | |
2019-04-04
| ||
20:21 | Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. file: [bf49f877] check-in: [b40a4edc] user: drh branch: disable-vtab, size: 302514 | |
2019-03-26
| ||
11:57 | Merge recent trunk enhancements. file: [30eac60e] check-in: [db4e2cc3] user: drh branch: reuse-schema, size: 310513 | |
2019-03-25
| ||
22:05 | Fix an obsolete comment in the CLI. No code changes. file: [c1986496] check-in: [fade103c] user: drh branch: trunk, size: 302040 | |
21:56 | 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. file: [3e95f0e2] check-in: [e775ef00] user: drh branch: trunk, size: 302036 | |
21:35 | 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. file: [35d0257c] check-in: [24ef3844] user: drh branch: trunk, size: 302162 | |
15:09 | Improvements to the help text in the CLI. file: [9c166e41] check-in: [919fec91] user: drh branch: trunk, size: 301687 | |
14:24 | 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. file: [652ba411] check-in: [191a023a] user: drh branch: trunk, size: 301685 | |
2019-03-21
| ||
17:22 | Merge latest trunk changes with this branch. file: [2030093c] check-in: [3196f5f4] user: dan branch: reuse-schema, size: 308972 | |
17:13 | Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. file: [c82e5dce] check-in: [b8e53608] user: dan branch: reuse-schema, size: 308608 | |
2019-03-20
| ||
18:22 | In the CLI, give better error messages if something goes wrong with the ".dbinfo" command. file: [576ba793] check-in: [3649a77b] user: drh branch: trunk, size: 300499 | |
16:03 | Merge latest trunk changes into this branch. file: [84f22bfb] check-in: [4cd20ca6] user: dan branch: reuse-schema, size: 308609 | |
2019-03-06
| ||
14:53 | Add the sqlite3_stmt_isexplain() interface. file: [01c0cc01] check-in: [ee642d3e] user: drh branch: trunk, size: 300135 | |
2019-03-04
| ||
07:25 | Merge latest trunk changes into this branch. file: [0ba39416] check-in: [97a9604d] user: dan branch: reuse-schema, size: 308749 | |
2019-02-28
| ||
20:10 | Add the ".parameter" command to the CLI. file: [249c0bf3] check-in: [1f9fa585] user: drh branch: trunk, size: 300275 | |
2019-02-26
| ||
15:43 | 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. file: [89848d1e] check-in: [7d8e8a95] user: dan branch: reuse-schema, size: 302872 | |
2019-02-25
| ||
18:43 | Enhance the command-line shell to accept bound parameters, using the TEMP table named "$Parameters" to look up the values for bound parameters. file: [a238f3f8] check-in: [7c941ce5] user: drh branch: trunk, size: 295995 | |
2019-02-14
| ||
18:38 | Change the name of the SQLITE_OPEN_REUSE_SCHEMA flag to SQLITE_OPEN_SHARED_SCHEMA. file: [d7d63fd1] check-in: [7257fcc8] user: dan branch: reuse-schema, size: 294959 | |
2019-02-11
| ||
20:13 | Merge latest trunk changes into this branch. file: [e32838e3] check-in: [dbedd81b] user: dan branch: reuse-schema, size: 294960 | |
2019-02-05
| ||
20:51 | Omit the ".progress" command from the shell if it is compiled with the SQLITE_OMIT_PROGRESS_CALLBACK option. file: [f2c1adbe] check-in: [4d0a949f] user: drh branch: trunk, size: 294398 | |
19:51 | Merge latest trunk into this branch. file: [d3c5b1c0] check-in: [c089cc4f] user: dan branch: reuse-schema, size: 294723 | |
19:48 | Fix compiler warnings on Windows. file: [b5149a7d] check-in: [4978ee8b] user: drh branch: trunk, size: 294191 | |
2019-02-04
| ||
19:52 | Mention the new -memtrace command-line option in the -help output of the CLI. file: [72a09544] check-in: [ada91aef] user: drh branch: trunk, size: 294161 | |
14:53 | Add the ".progress" command to the CLI. file: [d9898bed] check-in: [ad84ca24] user: drh branch: trunk, size: 294084 | |
2019-01-27
| ||
19:50 | 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. file: [705a00be] check-in: [42687d45] user: drh branch: trunk, size: 291271 | |
2019-01-26
| ||
15:40 | 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. file: [324bc8df] check-in: [626502fa] user: drh branch: trunk, size: 291264 | |
2019-01-22
| ||
16:44 | Use _strdup() instead of strdup() on Windows builds of the CLI, to avoid a compiler warning reported on the mailing list. file: [58f69c91] check-in: [a7126a4f] user: drh branch: trunk, size: 290484 | |
16:06 | 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. file: [7649cd10] check-in: [30f08d58] user: drh branch: trunk, size: 290435 | |
2019-01-21
| ||
14:55 | Add the --memtrace option to the CLI. file: [58b94d24] check-in: [a1e12fa2] user: drh branch: trunk, size: 289620 | |
2019-01-11
| ||
17:19 | Omit errors about missing SAVEPOINTs when aborting the .archive command in the CLI. file: [b3cd745b] check-in: [2a47387b] user: drh branch: trunk, size: 289454 | |
2019-01-04
| ||
14:29 | If the ".open" command fails in the CLI, reopen to :memory: so that at least some database is available for subsequent commands. file: [0722a9e3] check-in: [d7f55c62] user: drh branch: trunk, size: 289438 | |
2018-12-17
| ||
22:19 | Move variable declaration to address compilation issue (C89). file: [207da303] check-in: [d64f248d] user: mistachkin branch: trunk, size: 289379 | |
2018-12-13
| ||
22:58 | Fix the dbtotxt decoder in the CLI so that it ignores excess bytes. file: [e1790e0d] check-in: [18740bd4] user: drh branch: trunk, size: 289369 | |
18:59 | 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". file: [a9b26ab3] check-in: [7ffa9858] user: drh branch: trunk, size: 289457 | |
18:30 | Fix the CLI so that the ".open --hexdb" command works even if it is contained in a subscript that is read using ".read". file: [b998c6d7] check-in: [67a87399] user: drh branch: trunk, size: 289174 | |
15:06 | 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. file: [6c06ff40] check-in: [e3bf1d3e] user: drh branch: trunk, size: 289014 | |
2018-12-08
| ||
01:09 | Add the --async option to the ".backup" command in the CLI. file: [5f38bd0e] check-in: [7b6a605b] user: drh branch: vacuum-into, size: 286173 | |
2018-12-05
| ||
13:39 | 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. file: [1f0819e6] check-in: [7da617e9] user: drh branch: trunk, size: 285865 | |
2018-11-26
| ||
18:09 | 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. file: [482e23a3] check-in: [6e133054] user: drh branch: trunk, size: 282805 | |
2018-11-17
| ||
18:45 | Merge latest trunk changes into this branch. file: [91ccfc85] check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 283233 | |
2018-11-16
| ||
14:36 | 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. file: [6a9d8a56] check-in: [d584a0cb] user: dan branch: trunk, size: 282671 | |
2018-11-15
| ||
21:20 | Fix some problems with the feature on this branch. Many problems remain. file: [9f517c22] check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 283255 | |
2018-11-09
| ||
18:44 | Merge latest trunk changes with this branch. file: [37a6b4c3] check-in: [ae88f8e1] user: dan branch: reuse-schema, size: 283253 | |
2018-11-03
| ||
16:09 | Add the SQLITE_DBCONFIG_DEFENSIVE flag. file: [060ccc32] check-in: [af3f29d4] user: drh branch: dbconfig-defensive, size: 282693 | |
2018-10-30
| ||
15:31 | 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. file: [f5a89e43] check-in: [90b2a684] user: drh branch: trunk, size: 282621 | |
14:36 | 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. file: [a1fa7476] check-in: [7989bbda] user: drh branch: trunk, size: 282416 | |
13:19 | 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. file: [ac4a731d] check-in: [5e0129ee] user: drh branch: trunk, size: 282282 | |
2018-10-11
| ||
16:53 | Fix harmless compiler warnings in the CLI. file: [248af8c0] check-in: [1916d291] user: drh branch: trunk, size: 281318 | |
10:37 | In the CLI, fix a file descriptor leak following OOM and a missing va_end() call. file: [fa815984] check-in: [ec36d15a] user: drh branch: trunk, size: 281308 | |
2018-10-10
| ||
18:56 | 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. file: [d574c3be] check-in: [696e82f7] user: drh branch: trunk, size: 281277 | |
2018-10-08
| ||
23:29 | 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. file: [f6c19d23] check-in: [3869b210] user: drh branch: reuse-schema, size: 281712 | |
2018-10-06
| ||
14:38 | Fix the ".help -all" option in the command-line shell. file: [09342e09] check-in: [aac8f1df] user: drh branch: trunk, size: 281181 | |
2018-10-03
| ||
11:13 | Change a type in shell.c.in from "int" to "sqlite3_int64" in order to avoid a compiler warning and possible integer overflow. file: [6046da2a] check-in: [bf0a6634] user: dan branch: trunk, size: 281060 | |
2018-09-26
| ||
18:02 | Further improvements to the ".help" command in the CLI. file: [2162b1dc] check-in: [edc3d18e] user: drh branch: trunk, size: 281050 | |
16:53 | 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. file: [03d87b06] check-in: [209afb8d] user: drh branch: trunk, size: 280262 | |
2018-08-06
| ||
02:08 | 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. file: [6e0aad85] check-in: [20c995d3] user: drh branch: trunk, size: 278499 | |
2018-07-29
| ||
18:56 | In the command-line shell, always exit if realloc() fails. file: [5e4c1397] check-in: [e390023c] user: drh branch: trunk, size: 277889 | |
2018-07-22
| ||
06:25 | In the Win32 VFS, when truncating a file, unmap it first. file: [f6ebd05c] check-in: [21510a66] user: mistachkin branch: trunk, size: 277850 | |
2018-07-18
| ||
19:09 | Add the SQLITE_FCNTL_DATA_VERSION file control file: [239aee55] check-in: [a5087c5c] user: drh branch: trunk, size: 277405 | |
2018-07-05
| ||
17:35 | Fix the .dump command in the command-line shell so that it does not show extraneous SELECT statements when ".echo on" is enabled. file: [f1c79c53] check-in: [11763cac] user: drh branch: trunk, size: 277235 | |
2018-06-19
| ||
21:15 | 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. file: [5473740b] check-in: [7fa8f16e] user: drh branch: ieee754, size: 278242 | |
2018-06-13
| ||
17:19 | Output infinity as 1e999 in the ".dump" command of the command-line shell. file: [8578421c] check-in: [ee431d55] user: drh branch: trunk, size: 277148 | |
2018-06-07
| ||
17:32 | Remove the NextIfOpen and PrevIfOpen opcodes which are no longer needed when the IN-early-out optimization is working. file: [4d0ddf10] check-in: [439c8162] user: drh branch: multikey-opt-idea, size: 276877 | |
15:23 | Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. file: [3151c40b] check-in: [bb87c054] user: drh branch: trunk, size: 276932 | |
2018-06-06
| ||
01:18 | 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. file: [099edada] check-in: [27291f2d] user: drh branch: trunk, size: 276890 | |
2018-05-30
| ||
07:24 | Fix a typo in an error message in the CLI. file: [c29cb307] check-in: [80883980] user: drh branch: trunk, size: 276853 | |
2018-05-18
| ||
17:11 | 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. file: [51c10020] check-in: [e3b2e0a0] user: drh branch: trunk, size: 276857 | |
2018-05-17
| ||
20:04 | 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. file: [e0f00698] check-in: [33dc8fad] user: drh branch: trunk, size: 276466 | |
14:09 | Improved error and help messages for the ".archive" command and "-A" option to the CLI. If a memory leak in --list processing. file: [d9154a6b] check-in: [02541ac6] user: drh branch: trunk, size: 275815 | |
13:29 | Fix memory errors associated with argv in the CLI when it is compiled on Windows. file: [e4086ed1] check-in: [4474d69b] user: drh branch: trunk, size: 275414 | |
2018-05-14
| ||
12:23 | Fix typo in the shell.c source file. file: [53affa90] check-in: [389dc0a9] user: mistachkin branch: trunk, size: 275230 | |
00:41 | Export the deduceDatabaseType() function the shell.c source file. file: [bd7ea498] check-in: [d0f35739] user: drh branch: trunk, size: 275232 | |
00:23 | Add the --append option to the ".backup" command in the CLI. file: [05d9da22] check-in: [0dfdbdee] user: drh branch: trunk, size: 275239 | |
2018-05-12
| ||
23:56 | 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. file: [df40a09c] check-in: [4ee136d6] user: drh branch: trunk, size: 275031 | |
2018-05-11
| ||
19:11 | In the CLI, return non-zero if there are errors on the command-line. file: [4caa8c44] check-in: [13e7300a] user: drh branch: trunk, size: 274949 | |
14:02 | Fix a typo in the help message from the ".sha3sum" command in the CLI. file: [c625e817] check-in: [e76f676c] user: drh branch: geojson, size: 274908 | |
14:00 | Make sure the open_db() routine in the CLI does not invoke access() with a NULL filename. file: [c696c384] check-in: [2b8fd3b4] user: drh branch: geojson, size: 274908 | |
2018-05-08
| ||
23:17 | Correctly format the STAT1 and STAT4 content in the output from the ".fullschema" command in the CLI. Fix for ticket [e63a34a0045832dc850367552]. file: [df233d55] check-in: [0c3f128f] user: drh branch: trunk, size: 274786 | |
2018-05-07
| ||
11:37 | Fix harmless compiler warnings associated with the new EXPLAIN QUERY PLAN logic. file: [e41979d8] check-in: [374d8e26] user: drh branch: trunk, size: 274774 | |
2018-05-02
| ||
00:33 | Begin reengineering the EXPLAIN QUERY PLAN function to provide more intuitive output. file: [29309f2a] check-in: [70b48a79] user: drh branch: rework-EQP, size: 274769 | |
2018-04-28
| ||
12:43 | 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. file: [54b902ab] check-in: [ff836cb8] user: drh branch: reset-database, size: 274862 | |
2018-04-27
| ||
20:49 | 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. file: [d751c9e8] check-in: [7b2a65a6] user: drh branch: shell-bindings, size: 274547 | |
17:39 | 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. file: [3bac9ab3] check-in: [1f2944d1] user: drh branch: shell-bindings, size: 274241 | |
2018-04-25
| ||
19:02 | Add new interfaces for accessing the list of SQL keywords: sqlite3_keyword_count(), sqlite3_keyword_name(), sqlite3_keyword_check(). file: [d63f06c8] check-in: [7dd34e37] user: drh branch: trunk, size: 273403 | |
17:10 | Add the new DO and NOTHING keywords to the keyword lists maintained by various extensions and auxiliary programs. file: [be819b84] check-in: [77a98a07] user: drh branch: trunk, size: 275440 | |
13:27 | 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. file: [38aa5740] check-in: [3bcdbccf] user: drh branch: trunk, size: 275419 | |
2018-04-24
| ||
13:07 | 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". file: [fc3f9e47] check-in: [f53716ee] user: drh branch: trunk, size: 274990 | |
2018-04-23
| ||
18:38 | Add the ".imposter off" variant of the ".imposter" dot-command in the CLI. file: [4115df36] check-in: [d3dad06f] user: drh branch: trunk, size: 271465 | |
2018-04-18
| ||
19:56 | 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. file: [8ab4687d] check-in: [ef74090a] user: dan branch: trunk, size: 271230 | |
15:21 | Add the --sorterref N option to the CLI. file: [6c9e2c11] check-in: [902a4089] user: drh branch: sorter-reference, size: 270604 | |
10:44 | Add checks to the CLI that issue a warning if SQLite gets initialized prior to the last sqlite3_config() call. file: [bcde676b] check-in: [40b11734] user: drh branch: trunk, size: 270795 | |
09:16 | Fix a problem in the shell preventing it from working with SQLITE_OMIT_AUTOINIT builds. file: [7fbdc5c5] check-in: [89209000] user: dan branch: trunk, size: 270391 | |
2018-04-10
| ||
10:37 | Remove an unnecessary SQLITE_UNTESTABLE compile-time conditional from the command-line shell. file: [cc960721] check-in: [80b75a34] user: drh branch: trunk, size: 270169 | |
2018-03-23
| ||
16:08 | Fix the -readonly option on the CLI so that it actually works. file: [d6a07811] check-in: [0477fb3f] user: drh branch: trunk, size: 270208 | |
14:24 | Enhance .schema in shell to enable matching patterns with literal underscores. file: [8e7fb346] check-in: [98e3f524] user: mistachkin branch: trunk, size: 270123 | |
13:18 | Fix an error in the CLI in the previous ([0249d9aecf69948]) check-in. Only the pattern to sqlite3_strlike() need to be escaped. file: [be2afd4b] check-in: [71d5f6e6] user: drh branch: trunk, size: 269926 | |
12:59 | Fix the ANALYZE command so that it will process tables whose names begin with "sqlite" as long as they do not being with "sqlite_". file: [f5687352] check-in: [0249d9ae] user: drh branch: trunk, size: 269938 | |
00:31 | Fix harmless compiler warnings seen with MSVC. file: [211a99f5] check-in: [2f2be1b1] user: mistachkin branch: trunk, size: 269921 | |
2018-03-20
| ||
12:04 | In the CLI, avoid extra .selecttrace and .wheretrace output when in ".eqp full" mode. file: [911b9e3b] check-in: [427bbf31] user: drh branch: push-down-disable, size: 269869 | |
2018-03-17
| ||
16:26 | Do not use sqlite3_column_decltype() in the CLI if it is compiled with SQLITE_OMIT_DECLTYPE. file: [52b1b3f5] check-in: [442e816b] user: drh branch: trunk, size: 269651 | |
2018-03-14
| ||
14:53 | Add the SQLITE_DBSTATUS_CACHE_SPILL option to sqlite3_db_status() file: [9b7e7ac1] check-in: [3faeb851] user: drh branch: dbstatus-cache-spill, size: 269621 | |
2018-03-09
| ||
22:18 | Fix the .archive command in the CLI so that it actually compresses content. file: [b0aad885] check-in: [3c2e3c2d] user: drh branch: trunk, size: 269444 | |
21:54 | Enhance the ".ar" command in the CLI so that it is able to update and create ZIP Archives. file: [b499275d] check-in: [9404765e] user: drh branch: trunk, size: 269459 | |
16:37 | Setting ".stats 2" in the CLI causes column metadata for each prepared statement to be displayed. file: [75490510] check-in: [7fea00fd] user: drh branch: trunk, size: 267987 | |
15:24 | Simplification to the shell_exec() mechanism in the CLI. file: [23eb7501] check-in: [72e8f529] user: drh branch: trunk, size: 266589 | |
2018-03-08
| ||
18:14 | Add the --append and --zip options of the CLI to the --help message. file: [edbc1b73] check-in: [f010c86e] user: drh branch: trunk, size: 267385 | |
2018-03-05
| ||
20:21 | Improved command-line help for the -A option on the CLI. file: [8c6ea9b4] check-in: [d937ac18] user: drh branch: trunk, size: 267217 | |
20:20 | 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. file: [4b2b00d2] check-in: [9d8081fa] user: drh branch: trunk, size: 267223 | |
19:34 | In the CLI, add a new command-line option "--archive" (also "--ar") that passes all subsequent arguments to the ".archive" command. file: [2115621c] check-in: [a5c4d30a] user: drh branch: trunk, size: 267131 | |
2018-02-26
| ||
16:49 | Fix heap issue in the shell on Win32 caused by allocator mismatch. file: [47dac081] check-in: [7b3a7551] user: mistachkin branch: trunk, size: 266335 | |
2018-02-15
| ||
01:03 | Fix the --heap, --pagecache, --lookaside and other options to the command-line shell that invoke sqlite3_config() so that they work again. file: [c1b14bc0] check-in: [00707f2f] user: drh branch: trunk, size: 266351 | |
2018-02-14
| ||
23:27 | Add the --readonly option to the ".open" command in the CLI. file: [6fdccd0a] check-in: [06870bb1] user: drh branch: trunk, size: 265777 | |
2018-02-04
| ||
20:33 | In the CLI, make sure sqlite3_initialize() is called correctly even for non-UTF8 hosts. file: [0b2c8d55] check-in: [a3591fb5] user: drh branch: trunk, size: 265266 | |
2018-01-31
| ||
01:38 | Changes to the autoconf tarball so that it does not try to use system() when building on iOS. file: [ada6d184] check-in: [32ed9c10] user: drh branch: trunk, size: 265266 | |
2018-01-24
| ||
01:58 | 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. file: [7cea439c] check-in: [c3e816cc] user: drh branch: trunk, size: 264887 | |
2018-01-23
| ||
00:05 | Fix harmless compiler warnings seen with MSVC. file: [06ffe417] check-in: [76a11a80] user: mistachkin branch: trunk, size: 264537 | |
2018-01-17
| ||
13:15 | Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. file: [4e1bcf8c] check-in: [bfbeffab] user: drh branch: trunk, size: 264478 | |
2018-01-16
| ||
20:05 | Move the ZLIB version announcement in the CLI out of the default banner and put it in the ".version" command. file: [568aacb5] check-in: [231679d6] user: drh branch: trunk, size: 264412 | |
19:03 | Show version of zlib in use when running the shell tool in interactive mode. file: [594f9427] check-in: [a8906b52] user: mistachkin branch: trunk, size: 263906 | |
2018-01-11
| ||
00:38 | Update the .help screen in the CLI. Make sure the temporary files for ".open" are not deleted too soon. file: [b87abffd] check-in: [b8d92d8d] user: drh branch: trunk, size: 263821 | |
00:04 | Add the built-in edit(VALUE) and edit(VALUE,EDITOR) function to the CLI. file: [52aef9f2] check-in: [ef823c47] user: drh branch: trunk, size: 263624 | |
2018-01-10
| ||
22:27 | Save and restore the output mode when doing ".once -x" or ".excel". file: [0baa3d01] check-in: [f697c164] user: drh branch: excel-shell-cmd, size: 260228 | |
22:15 | An attempt to get ".once -e" working reliably on Windows. file: [8ac56c0e] check-in: [9b97f9d2] user: drh branch: excel-shell-cmd, size: 259613 | |
21:50 | Fix a potential SQLITE_MISUSE in the .excel command when no database is open. file: [362e3af7] check-in: [9b95ff1a] user: drh branch: excel-shell-cmd, size: 259450 | |
21:41 | Add support for the ".excel" command (and ".once -e" and ".once -x") in the CLI. file: [d1dbc151] check-in: [23fa7c57] user: drh branch: excel-shell-cmd, size: 259429 | |
18:09 | Modify the new "--append" option to the .archive so that it takes a filename argument, the same as "--file". file: [2e72b9dc] check-in: [58e3b07c] user: drh branch: trunk, size: 256958 | |
17:39 | Fix minor problems with the new ".archive" command changes. file: [4cb216da] check-in: [612b30c9] user: drh branch: archive-improvements, size: 256930 | |
17:19 | In the fileio.c extension, change the filetype(MODE) function into lsmode(MODE). Use the new lsmode(MODE) function in shell.c. file: [926858c0] check-in: [52d12ba9] user: drh branch: archive-improvements, size: 256791 | |
16:50 | 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. file: [f8ae3a79] check-in: [28ab9304] user: drh branch: archive-improvements, size: 257405 | |
15:17 | 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. file: [7d49ed78] check-in: [430d1a7d] user: drh branch: archive-improvements, size: 258215 | |
13:44 | Checked into the wrong branch. file: [aae06c14] check-in: [55116dc3] user: drh branch: mistake, size: 257638 | |
13:11 | 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. file: [f86200b0] check-in: [a2baada4] user: drh branch: archive-improvements, size: 257380 | |
00:53 | Rearrange some routines in shell.c to avoid the need to forward reference a static function. file: [1e50d66d] check-in: [fd7f51a1] user: drh branch: trunk, size: 256677 | |
2018-01-09
| ||
15:57 | Fix another -fsanitize issue in new shell code. file: [4121ecd9] check-in: [6ee7b54c] user: dan branch: trunk, size: 256729 | |
15:25 | Fix the shell so that it can be built with SQLITE_OMIT_VIRTUALTABLE. file: [2a752aed] check-in: [931421a2] user: dan branch: trunk, size: 256675 | |
00:28 | Improve portability of compile-time MinGW detection for the command line shell. file: [fb615970] check-in: [4a723614] user: mistachkin branch: trunk, size: 256478 | |
2018-01-08
| ||
19:59 | Update the zipfile module so that it matches the documentation. file: [2aa65d15] check-in: [7e7e472f] user: dan branch: trunk, size: 256474 | |
17:05 | Fix a malloc/sqlite3_free mismatch in the shell tool code. file: [be04d679] check-in: [fe053b2e] user: dan branch: trunk, size: 256508 | |
2018-01-07
| ||
21:58 | Remove the dependency on test_windirent.h from the generated shell.c file. file: [0e20ac49] check-in: [0a50c9e3] user: drh branch: trunk, size: 256468 | |
20:38 | 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. file: [ffcef0e1] check-in: [67c4a8c6] user: drh branch: trunk, size: 256443 | |
2018-01-06
| ||
21:46 | The shell detects and opens ZIP archives using the zipfile extension. file: [c2231d96] check-in: [05c99eb8] user: drh branch: trunk, size: 256185 | |
19:19 | In the shell, include the ".archive" command only if compiling with SQLITE_HAVE_ZLIB. Add ".archive" to the ".help" output. file: [9f2ab2d0] check-in: [366469f5] user: drh branch: trunk, size: 253918 | |
15:49 | Better whitespace in the "CREATE TABLE sqlar()" statement for the ".ar" command. file: [1f1d02e8] check-in: [252ee55a] user: drh branch: trunk, size: 253324 | |
15:46 | Improved output from ".schema --indent" when a column definition is followed by a comment. file: [8874828e] check-in: [87da7eff] user: drh branch: trunk, size: 253308 | |
2018-01-05
| ||
21:01 | Make sure i64 and u64 typedefs are available throughout shell.c. file: [4cfa9394] check-in: [656fb5aa] user: drh branch: trunk, size: 252819 | |
20:26 | MinGW does not define the S_ISLNK macro; therefore, define it in the shell when needed. file: [df0e5728] check-in: [73023feb] user: mistachkin branch: trunk, size: 252764 | |
20:08 | Fix shell compilation with MinGW by including the 'dirent.h' header. file: [54b689b5] check-in: [dfe510b5] user: mistachkin branch: trunk, size: 252708 | |
14:55 | Fix compiler warnings. file: [17fc2866] check-in: [364ac333] user: drh branch: sqlar-shell-support, size: 252583 | |
00:53 | Add missing #ifdef. file: [f57fa72e] check-in: [a0e18aea] user: mistachkin branch: sqlar-shell-support, size: 252707 | |
2018-01-04
| ||
22:50 | Remove 'timespec' related code from the shell that has no effect and a (now) superfluous 'timespec' typedef from the Win32 dirent header file. file: [84af7b92] check-in: [57dac995] user: mistachkin branch: sqlar-shell-support, size: 252676 | |
22:46 | Get the shell enhancements compiling with MSVC. file: [e17f15b3] check-in: [335387f9] user: mistachkin branch: sqlar-shell-support, size: 252769 | |
19:54 | Merge in all recent trunk enhancements. file: [3e2db269] check-in: [406f7918] user: drh branch: sqlar-shell-support, size: 252625 | |
2018-01-03
| ||
23:54 | Fix compiler warnings on Windows. file: [23b0207a] check-in: [512b8e40] user: drh branch: memdb, size: 231374 | |
2018-01-02
| ||
12:50 | Do not attempt to use pragma_module_list in the command-line shell unless it has been compiled with -DSQLITE_INTROSPECTION_PRAGMAS. file: [a418ddce] check-in: [39ca5fcd] user: drh branch: trunk, size: 231372 | |
00:04 | 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. file: [6b1ec35f] check-in: [f80f6651] user: drh branch: trunk, size: 231329 | |
2018-01-01
| ||
21:49 | Improved name quoting and escaping in the auxiliary column info section of the ".schema" output for views and virtual tables. file: [e0d3ef67] check-in: [d64b14e3] user: drh branch: trunk, size: 230411 | |
21:28 | In the output of ".schema", show the column names of virtual tables and views in a separate comment. file: [f151a118] check-in: [2234a87f] user: drh branch: trunk, size: 230031 | |
20:11 | Minor simplification to the ".schema" logic in the command-line shell. file: [a3f30523] check-in: [add45c47] user: drh branch: trunk, size: 228677 | |
2017-12-27
| ||
21:13 | Improve the shell tool ".ar --list --verbose" command. file: [9177b6cc] check-in: [b64681a6] user: dan branch: sqlar-shell-support, size: 250054 | |
18:54 | Have the shell tool ".ar --list" and ".ar --extract" commands support zip files. Currently the "-zip" switch is required. file: [d1be3030] check-in: [a532a0f6] user: dan branch: sqlar-shell-support, size: 248943 | |
2017-12-26
| ||
20:39 | Add new file ext/misc/zipfile.c, containing a virtual table for read-only access to simple zip archives. file: [1c927f94] check-in: [8e366b99] user: dan branch: sqlar-shell-support, size: 247569 | |
18:04 | Add support for measuring and reporting coverage of the parser state machine using the SQLITE_TESTCTRL_PARSER_COVERAGE test-control. file: [f3ec8f90] check-in: [1253a872] user: drh branch: lemon-improvements, size: 229094 | |
2017-12-23
| ||
18:34 | Merge enhancements from trunk. file: [e739db28] check-in: [150f07fe] user: drh branch: sqlar-shell-support, size: 247500 | |
2017-12-21
| ||
21:02 | Add the ".eqp trigger" option to the ".eqp" command in the command-line shell. Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control. file: [339169a3] check-in: [2c51644a] user: drh branch: trunk, size: 228801 | |
18:55 | Add the ".expert" command to the shell tool's ".help" output. file: [ef343d70] check-in: [fc6193af] user: dan branch: trunk, size: 228204 | |
2017-12-19
| ||
17:42 | Experimentally add the SQLite expert functionality to the shell tool. file: [87a048fa] check-in: [51068dba] user: dan branch: expert-in-shell, size: 228123 | |
2017-12-16
| ||
19:11 | 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. file: [ad8c13b9] check-in: [7652b3c2] user: dan branch: sqlar-shell-support, size: 242256 | |
2017-12-14
| ||
19:15 | 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. file: [074b2129] check-in: [7b51269c] user: dan branch: sqlar-shell-support, size: 243234 | |
15:40 | Improve error and usage messages output by the shell ".ar" command. file: [4bdd2efe] check-in: [b9d2d5d9] user: dan branch: sqlar-shell-support, size: 243209 | |
2017-12-13
| ||
20:17 | Add the shell tool ".ar --update" command. file: [12313c05] check-in: [825e3c03] user: dan branch: sqlar-shell-support, size: 241382 | |
20:04 | Add support for the "--list" command. And for arguments to the "--extract" command. file: [b53eddcb] check-in: [32c4fa25] user: dan branch: sqlar-shell-support, size: 240689 | |
2017-12-12
| ||
20:28 | Add tests and fixes for the shell ".ar" command -f option. file: [a09773c8] check-in: [1a986797] user: dan branch: sqlar-shell-support, size: 237416 | |
20:04 | 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. file: [0ab6e3c1] check-in: [38dbeb1e] user: dan branch: sqlar-shell-support, size: 237340 | |
2017-12-11
| ||
20:22 | Enhance virtual table "fsdir" in ext/misc/fileio.c. Add support for "-C" to the shell command's ".ar c" command. file: [4c7a2c12] check-in: [0394889a] user: dan branch: sqlar-shell-support, size: 233622 | |
2017-12-09
| ||
18:28 | Add support for -C to ".ar x". file: [8e57abbd] check-in: [8cd70960] user: dan branch: sqlar-shell-support, size: 233763 | |
17:58 | Improve parsing of ".ar" commands. Add new test file for the same. file: [907661ee] check-in: [840401cc] user: dan branch: sqlar-shell-support, size: 233426 | |
2017-12-07
| ||
21:03 | Add the ".ar x" command to the shell. For extracting the contents of sqlar archives. file: [2f9ae0be] check-in: [0cc699d1] user: dan branch: sqlar-shell-support, size: 230700 | |
15:44 | Begin adding support for the sqlar archive format to shell.c. There is no "extract" command so far, only "create". file: [56c4c091] check-in: [c9827a01] user: dan branch: sqlar-shell-support, size: 229729 | |
2017-12-05
| ||
18:32 | If SQLITE_HAVE_ZLIB is defined at build-time, include the functions in ext/misc/compress.c in the shell. file: [ab727c09] check-in: [0296286a] user: dan branch: sqlar-shell-support, size: 223689 | |
2017-12-01
| ||
18:40 | Fix the ".lint fkey-indexes" shell command so that it works with WITHOUT ROWID tables. file: [6ffed0c5] check-in: [5771b1d6] user: dan branch: trunk, size: 223556 | |
2017-11-26
| ||
02:14 | Fix an CSV output quoting problem in the command-line shell on Windows. file: [c441d7dd] check-in: [6500cdbd] user: drh branch: trunk, size: 223554 | |
2017-11-21
| ||
21:14 | Fix compilation issue (C99-ism) in the shell seen with MSVC. file: [cb1b5e41] check-in: [9cb47430] user: mistachkin branch: trunk, size: 223578 | |
2017-11-15
| ||
19:14 | Futher improvements to the .testctrl interface in the shell. file: [a87f3094] check-in: [1ca3b8cc] user: drh branch: trunk, size: 223563 | |
17:07 | UI improvements on the .testctrl dot-command in the shell. file: [e261e3c2] check-in: [5d66219c] user: drh branch: trunk, size: 223981 | |
2017-10-27
| ||
17:09 | Handle the Ctrl-C event for the shell on Win32. file: [08cbffc3] check-in: [c8aaf371] user: mistachkin branch: trunk, size: 223352 | |
2017-10-17
| ||
13:44 | Fix the ".check" command of the command-line shell to return 1 (error) rather than 2 (exit) on a test failure. file: [f13262c8] check-in: [e2af0cc6] user: drh branch: trunk, size: 222915 | |
2017-10-12
| ||
20:37 | Add the sqlite_dbpage virtual table (enabled using SQLITE_ENABLE_DBPAGE_VTAB). Make that virtual table and dbstat available to the command-line shell. file: [5446de0a] check-in: [eaeeb09d] user: drh branch: trunk, size: 222915 | |
10:28 | Make sure the tableColumnList() routine of the command-line shell does not cause a null-pointer dereference in an error condition. file: [423944f4] check-in: [5d0ceb8d] user: drh branch: branch-3.21, size: 222773 | |
2017-10-11
| ||
18:26 | Add the checkfreelist extension to the command-line shell. file: [7842db26] check-in: [48418f2e] user: drh branch: dbpage, size: 222969 | |
17:51 | Convert the implementation of the ".dbstat" dot-command of the command-line shell to use the sqlite_dbpage table. file: [73d8000b] check-in: [497409e1] user: drh branch: dbpage, size: 222888 | |
2017-10-05
| ||
19:12 | 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. file: [e03f7d47] check-in: [4258fb57] user: drh branch: trunk, size: 222746 | |
2017-09-13
| ||
18:38 | Experimental sqlite3_stmt_retryable() interface. file: [30d6799f] check-in: [ebada072] user: drh branch: sqlite3_stmt_retryable, size: 223012 | |
2017-09-09
| ||
00:51 | Fix harmless compiler warnings seen with MSVC. file: [bb9720a8] check-in: [faa22e29] user: mistachkin branch: trunk, size: 222702 | |
2017-08-28
| ||
17:26 | 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. file: [6bd94bfe] check-in: [cc440400] user: drh branch: begin-concurrent-branch-3.19, size: 222631 | |
15:51 | 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. file: [af3fb9ea] check-in: [54b00024] user: drh branch: trunk, size: 222701 | |
14:33 | Backport changes to shell.c into shell.c.in. file: [31cd78c3] check-in: [2348045f] user: drh branch: trunk, size: 223870 | |
2017-07-18
| ||
20:59 | Fix shell.c.in so that it aligns with shell.c. file: [b5725aca] check-in: [505fdc8f] user: drh branch: trunk, size: 223800 | |
2017-07-14
| ||
00:28 | Fix harmless compiler warnings in the readline tab-completion logic of the command-line shell. file: [dae43a6a] check-in: [271ca4ac] user: drh branch: trunk, size: 223799 | |
2017-07-11
| ||
18:11 | Fix harmless compiler warnings in the core. file: [98bfdeeb] check-in: [55e93f25] user: drh branch: trunk, size: 223798 | |
13:59 | Add support for tab-completion (using the ext/misc/completion.c virtual table) to the command-line shell. file: [18510e3f] check-in: [95cd1d9f] user: drh branch: trunk, size: 223781 | |
13:34 | 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. file: [9d75c83c] check-in: [17e0bb12] user: drh branch: trunk, size: 221535 Added | |