SQLite

All files named "src/shell.c"
Login

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

History for src/shell.c

2017-12-12
18:17
Deleted: Merge latest begin-concurrent changes into this branch. (check-in: [3fde0b4d] user: dan branch: begin-concurrent-pnu, size: 0)
2017-10-24
19:12
Deleted: Merge all enhancements and fixes from the 3.21.0 release. (check-in: [13be3a44] user: drh branch: apple-osx, size: 0)
2017-10-12
14:13
Deleted: Update this branch to match latest trunk. (check-in: [d325da6c] user: dan branch: schemalint, size: 0)
13:47
Deleted: The src/shell.c file is now generated from src/shell.c.in, so remove shell.c from version control and update the makefiles to build it automatically. (check-in: [36acc0a9] user: drh branch: trunk, size: 0)
11:33
[edadbfd5] part of check-in [c36761e1] Fix a potential crash that may follow an OOM or other system error in the shell tool. (check-in: [c36761e1] user: dan branch: trunk, size: 265020)
10:28
[b7a09766] 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: 265022)
2017-10-11
18:26
[ffb06532] part of check-in [48418f2e] Add the checkfreelist extension to the command-line shell. (check-in: [48418f2e] user: drh branch: dbpage, size: 273533)
17:51
[b1c14539] 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: 265137)
2017-10-05
19:12
[cbf450e7] 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: 264995)
2017-09-13
18:38
[dc398976] part of check-in [ebada072] Experimental sqlite3_stmt_retryable() interface. (check-in: [ebada072] user: drh branch: sqlite3_stmt_retryable, size: 265261)
2017-09-09
00:51
[c1206a23] part of check-in [faa22e29] Fix harmless compiler warnings seen with MSVC. (check-in: [faa22e29] user: mistachkin branch: trunk, size: 264951)
2017-08-30
13:21
[319082ac] part of check-in [bcc20be5] Remove unnecessary "__declspec(dllexport)" qualifiers from generated file shell.c. (check-in: [bcc20be5] user: dan branch: trunk, size: 264950)
2017-08-28
11:12
[117305aa] part of check-in [cf0d3715] Fix the ".dump", ".schema", and ".fullschema" commands of the command-line shell so that they work even if PRAGMA empty_result_callbacks is enabled. Fix for ticket [02f0f4c54f281]. (check-in: [cf0d3715] user: drh branch: trunk, size: 266182)
2017-08-22
21:07
[8f2a8b9e] part of check-in [564c7340] Less dramatic changes to the source-id following an edit. Modify the way that the amalgamation is constructed to give it the opportunity to detect changes and modify the source-id. (check-in: [564c7340] user: drh branch: trunk, size: 266116)
2017-07-20
13:17
[bd6a37cb] part of check-in [22eda098] Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints. (check-in: [22eda098] user: drh branch: index-on-date-func, size: 266112)
2017-07-18
14:41
[dd449428] part of check-in [0b69aa7e] Change the default command-line shell history depth to 2000 lines. (check-in: [0b69aa7e] user: drh branch: trunk, size: 266113)
2017-07-14
00:28
[e89ad113] 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: 266112)
2017-07-11
18:11
[0401a716] part of check-in [55e93f25] Fix harmless compiler warnings in the core. (check-in: [55e93f25] user: drh branch: trunk, size: 266111)
13:59
[19726a6f] 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: 265482)
13:34
[71a338b3] 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: 245845)
2017-07-10
18:04
[c042ed1f] part of check-in [bde431b1] Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. (check-in: [bde431b1] user: drh branch: trunk, size: 242086)
2017-07-07
18:06
[a7067f64] part of check-in [cc329eb8] In the command-line shell, when running ".schema" give a sensible error when the database file is locked. (check-in: [cc329eb8] user: drh branch: trunk, size: 241630)
2017-07-06
22:40
[6e1c9307] part of check-in [907fd3aa] Always load the schema before starting tab-completion. (check-in: [907fd3aa] user: drh branch: experimental-namelist, size: 243323)
20:08
[5a93d49f] part of check-in [c906739f] Tab-completion now also works using readline/editline. (check-in: [c906739f] user: drh branch: experimental-namelist, size: 243165)
19:26
[5f5dc595] part of check-in [5cc7b0e2] Use the sqlite3_namelist() interface to implement simple tab-completion using linenoise. (check-in: [5cc7b0e2] user: drh branch: experimental-namelist, size: 242355)
2017-06-29
21:33
[a2b148e4] part of check-in [5e3f9ea5] In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. (check-in: [5e3f9ea5] user: drh branch: trunk, size: 241448)
21:11
[d0015629] part of check-in [7782c04e] Remove the ".explain" command from the ".help" output of the command-line shell, though keep the implementation around for backwards compatibility. (check-in: [7782c04e] user: drh branch: trunk, size: 241223)
2017-06-26
18:42
[227b86f2] part of check-in [7c15d762] The ".import" command of the shell, and the csv virtual table extension both ignore a single UTF-8 BOM at the beginning of their input. (check-in: [7c15d762] user: drh branch: trunk, size: 240939)
2017-06-24
13:31
[2026e88e] part of check-in [0583b84a] Make sure enough memory is allocated for pathological quoting cases when computing a quoted table name in the command-line shell. (check-in: [0583b84a] user: drh branch: trunk, size: 240399)
2017-06-15
16:56
[bcd3358a] part of check-in [254617a1] Move the "shell_add_schema()" SQL function used by the ".schema" command of the command-line shell to a different spot in the shell.c source file so that it is not in the middle of an unrelated module. (check-in: [254617a1] user: drh branch: trunk, size: 240397)
13:07
[c45ae9a9] part of check-in [9afd7a2f] Fix harmless compiler warnings in the shell.c file (check-in: [9afd7a2f] user: drh branch: trunk, size: 240397)
12:50
[9be3234b] part of check-in [c7f778b7] Improvements to the ".tables" command in the command-line shell so that it shows the name of all schemas if the name is anything other than "main". (check-in: [c7f778b7] user: drh branch: trunk, size: 240452)
12:21
[41671b1b] part of check-in [48e08628] In the command-line shell, enhance the ".schema" command show that it shows the schema for ATTACH-ed databases in addition to "main". (check-in: [48e08628] user: drh branch: trunk, size: 241020)
2017-06-09
02:27
[a4329263] part of check-in [3168e2c9] Adjust the implementation of the ".selftest" feature of the shell to avoid using the deprecated sqlite3_get_table() interface. (check-in: [3168e2c9] user: drh branch: trunk, size: 238114)
2017-06-05
12:29
[eca7e7fe] part of check-in [ed0842c1] Fix the column width deduction logic in the command-line shell to account for multi-byte utf8 characters. (check-in: [ed0842c1] user: drh branch: trunk, size: 238172)
2017-05-29
03:48
[3f761fe6] part of check-in [7cc940a9] Improve shell help text for the '.open' command. (check-in: [7cc940a9] user: mistachkin branch: trunk, size: 237931)
2017-05-23
20:00
[615fb4e2] part of check-in [84996aef] Remove the msvc.h header file from the autoconf tarball. (check-in: [84996aef] user: drh branch: trunk, size: 237944)
2017-05-22
18:00
[9235003e] part of check-in [5fe28e15] Add the ".cd" command to the command-line shell. (check-in: [5fe28e15] user: drh branch: trunk, size: 237481)
2017-05-06
17:12
[a37d96b2] part of check-in [198ff4c0] Fix requirements marks and harmless compiler warnings. (check-in: [198ff4c0] user: drh branch: trunk, size: 236938)
2017-05-04
11:13
[e5950029] part of check-in [b9a58dac] Fix a collision of the "B0" identifier name between the termios.h header file and the SHA3 implementation in the shell. (check-in: [b9a58dac] user: drh branch: trunk, size: 236928)
2017-04-17
13:18
[21b79c0e] part of check-in [f508aff8] Fix the ".column" output mode in the command-line shell so that it correctly counts and formats multi-byte UTF characters. (check-in: [f508aff8] user: drh branch: trunk, size: 236805)
2017-04-08
13:42
[70f4957b] part of check-in [78c1e903] Fix the quoting mechanism for ".dump" so that it is not applied for the ".mode quote" output. (check-in: [78c1e903] user: drh branch: trunk, size: 236320)
00:55
[13512de3] part of check-in [a6ce57ee] Fix the ".dump" command so that it works with ".headers on". Also fix the display of ".mode insert" with ".headers on". (check-in: [a6ce57ee] user: drh branch: trunk, size: 234672)
2017-04-07
11:45
[36807254] part of check-in [4c2b5729] Use replace() instead of char() to quote newline and return characters in strings in the output of .dump, to avoid excess expression complexity. (check-in: [4c2b5729] user: drh branch: shell-fix, size: 234363)
2017-04-06
14:56
[e9fede68] part of check-in [48826b22] Fix the ".lint fkey" shell command for cases where the child key is also an INTEGER PRIMARY KEY. (check-in: [48826b22] user: dan branch: trunk, size: 233448)
12:06
[358aaf26] part of check-in [327eff25] Fix the ".lint fkey" shell tool command so that it works for foreign keys that refer implicitly to primary key columns with non-BINARY default collation sequences. (check-in: [327eff25] user: dan branch: trunk, size: 233295)
2017-03-31
11:20
[e524688c] part of check-in [cb721d0b] Merge latest trunk into this branch. (check-in: [cb721d0b] user: dan branch: schemalint, size: 234171)
2017-03-25
18:15
[ceb2b2f1] part of check-in [bd5bbe4e] Disable the new --preserve-rowids option on the CLI ".dump" command if compiled with SQLITE_OMIT_VIRTUALTABLE. (check-in: [bd5bbe4e] user: drh branch: trunk, size: 233231)
12:08
[042b74d5] part of check-in [32be9c3f] Fix two harmless compiler warnings. (check-in: [32be9c3f] user: drh branch: trunk, size: 232990)
2017-03-22
12:51
[ce39c4bb] part of check-in [a7868297] Fix harmless compiler warnings in the shell. (check-in: [a7868297] user: drh branch: trunk, size: 232966)
2017-03-15
14:20
[77054c02] part of check-in [37f766db] Mention the ".selftest" command in the ".help" output of the CLI. (check-in: [37f766db] user: drh branch: trunk, size: 232974)
2017-03-11
01:56
[353f3ceb] part of check-in [8b2954dd] The output of the ".dump" command in the CLI quotes newline and carriage-return characters using "char(10)" and "char(13)". (check-in: [8b2954dd] user: drh branch: string-quoting-dump, size: 232905)
00:46
[df29706f] part of check-in [7359fcac] Increase the number of significant digits in floating point literals on ".dump" output from the shell. (check-in: [7359fcac] user: drh branch: trunk, size: 232284)
2017-03-10
14:36
[4d9be7f0] part of check-in [118f5c05] Enhance the ".stats" dot-command in the CLI to use sqlite3_status64() instead of sqlite3_status(). (check-in: [118f5c05] user: drh branch: trunk, size: 232115)
01:05
[0435e7ea] part of check-in [b044b152] Improvements to ".selftest --init". Tests are number in increments of 10 starting with 100. The tests are generated inside a SAVEPOINT. Errors are reported during test generation. Tests can be appended to existing tests. Add a test case to verify the schema. (check-in: [b044b152] user: drh branch: trunk, size: 232185)
2017-03-09
22:00
[2009654e] part of check-in [f4fcd46f] Remove the test/dbselftest.c program. In its place, add the ".selftest" command to the CLI. The new CLI version is .selftest is slightly different in that it uses SHA3 hashing instead of SHA1, so the new is subtly incompatible with the old. (check-in: [f4fcd46f] user: drh branch: trunk, size: 231414)
18:13
[f4a7169d] part of check-in [6c627e50] Fix the ".dump" command to correctly extract tail data from corrupt WITHOUT ROWID tables. (check-in: [6c627e50] user: drh branch: trunk, size: 226184)
16:32
[9eb1fe6b] part of check-in [5dc82a15] Add the --recovery-mode option to the CLI ".dump" command. This involves enhancing the "PRAGMA reverse_unordered_selects" command to accept a "TOGGLE" option. Recovery mode used to be always on. Now it is opt-in. Not sure this is the correct approach. Also not sure if TOGGLE is a good feature to have on boolean PRAGMA statements. (check-in: [5dc82a15] user: drh branch: dump-recovery, size: 226333)
13:50
[397e51c3] part of check-in [50eec5d9] Begin moving separate boolean variables in the ShellState object of the CLI into the shellFlgs bitmask. (check-in: [50eec5d9] user: drh branch: trunk, size: 225456)
2017-03-08
23:29
[7708b950] part of check-in [aacac906] Refactor the output logic in the CLI. Not sure we want to go this way. Just saving the work for historical reference, or in case I decide to come back to it. (check-in: [aacac906] user: drh branch: shell-print-refactor, size: 223903)
18:06
[1160c054] part of check-in [2ea300fb] Make sure the database connection is open prior to running the ".sha3sum" command. (check-in: [2ea300fb] user: drh branch: trunk, size: 224717)
17:56
[bf10f163] part of check-in [30f87883] In the ".sha3sum" command, if there is a LIKE pattern, show the hashes for each table separately. Without a LIKE pattern, show a single hash over the entire database. (check-in: [30f87883] user: drh branch: trunk, size: 224698)
16:10
[8cebab1f] part of check-in [fc663799] Add the ".sha3sum" command to the CLI - used to compute a cryptographic hash of the content of a database file or of individual tables with in that file. (check-in: [fc663799] user: drh branch: trunk, size: 223835)
12:25
[d1ba571e] part of check-in [de65f907] In the CLI, avoid unnecessary identifier quoting in the ".dump" output. Also add new ".dump" test cases. (check-in: [de65f907] user: drh branch: trunk, size: 200868)
11:44
[c42c3031] part of check-in [c60aee24] Add the --preserve-rowids option to the ".dump" command in the CLI. (check-in: [c60aee24] user: drh branch: trunk, size: 198616)
2017-03-01
11:30
[27d2b310] part of check-in [ac760db0] Fix a use-after-free problem in the shell tool code that could occur if an SQL statement were executed after an ".open" command with invalid options. (check-in: [ac760db0] user: dan branch: trunk, size: 194584)
2017-02-17
23:52
[bf976d53] part of check-in [8cc9d74c] Fix the #endif location for an #ifndef SQLITE_UNTESTABLE macro in the command-line shell. (check-in: [8cc9d74c] user: drh branch: trunk, size: 194560)
01:43
[bb8e2078] part of check-in [8a03be1d] Enable the ".wheretrace" and ".selecttrace" extensions in the command-line shell when compiled on Windows using DEBUG=3 or higher. Fix a harmless warning in the shell that comes up when compiled this way. (check-in: [8a03be1d] user: drh branch: trunk, size: 194560)
2017-02-14
21:47
[a661e7cc] part of check-in [ca4f1e49] Clarification of the help text for the command-line shell. (check-in: [ca4f1e49] user: drh branch: trunk, size: 194555)
2017-01-27
01:52
[a84e453c] part of check-in [58f02e6e] In the command-line shell, enhance the ".mode" command so that it restores the default column and row separators for modes "line", "list", "column", and "tcl". (check-in: [58f02e6e] user: drh branch: trunk, size: 194568)
2017-01-22
16:34
[59de9aca] part of check-in [06b8001a] Fix an uninitialized variable in the command-line shell. (check-in: [06b8001a] user: drh branch: trunk, size: 194190)
2017-01-21
15:58
[0344f71d] part of check-in [ffda1d1e] Add extra (somewhat inefficient) trace callbacks for triggers if SQLITE_TRACE_TRIGGER is defined. (check-in: [ffda1d1e] user: dan branch: trigger-trace, size: 194716)
2016-12-29
19:48
[6095531a] part of check-in [afcdc4a6] Fix harmless compiler warnings in the command-line shell and in Lemon. (check-in: [afcdc4a6] user: drh branch: trunk, size: 194186)
2016-12-24
21:32
[48ab675e] part of check-in [def29333] Combine the implementations of the ".tables" and ".indexes" commands in the command-line shell. The ".indexes" command now puts the indexes in multiple columns, just like ".tables" and shows all indexes in all attached databases. (check-in: [def29333] user: drh branch: trunk, size: 194127)
18:18
[1594340a] part of check-in [8558512e] Change the output format of the ".databases" command in the command-line shell so that it shows the schema name, a colon, and the corresponding filename. (check-in: [8558512e] user: drh branch: trunk, size: 194967)
18:04
[e99c2d27] part of check-in [c0d5626e] In the command-line shell, improve the formatting to the ".databases" command and on the ".tables" command, only show the schema prefix for databases past the first ("main") database. (check-in: [c0d5626e] user: drh branch: trunk, size: 194937)
2016-12-22
14:53
[bf79a69d] part of check-in [fa86db2f] Fix harmless compiler warnings. (check-in: [fa86db2f] user: drh branch: trunk, size: 194951)
2016-12-17
08:18
[95fc9f4c] part of check-in [8dedd6ad] Fix a problem in the shell tools readfile() command causing blobs to be truncated at the first embedded 0x00 byte in release builds, or an assert() to fail in a debug build. (check-in: [8dedd6ad] user: dan branch: trunk, size: 194946)
2016-12-16
18:41
[9be556ad] part of check-in [1268dc77] Fix minor issues with the ".lint" command implemention in the shell and the shell help text related to ".lint". (check-in: [1268dc77] user: drh branch: fkey-missing-indexes, size: 194485)
17:28
[0f1f7935] part of check-in [ee621ade] Change ".fkey_missing_indexes" to ".lint fkey-indexes". (check-in: [ee621ade] user: dan branch: fkey-missing-indexes, size: 194394)
16:44
[667382b9] part of check-in [3ab05987] Update .fkey_missing_indexes to use the built-in pragma vtabs. (check-in: [3ab05987] user: dan branch: fkey-missing-indexes, size: 193994)
2016-12-15
06:01
[331be7c5] part of check-in [976c51b4] Add the -groupbyparent option to the ".fkey_missing_indexes" command. (check-in: [976c51b4] user: dan branch: fkey-missing-indexes, size: 199648)
2016-12-14
19:28
[bf722e55] part of check-in [7df23aca] Add the experimental ".fkey_missing_indexes" command to the shell tool. To identify indexes that should be created on child keys if FK processing is to be enabled. (check-in: [7df23aca] user: dan branch: fkey-missing-indexes, size: 198631)
2016-12-13
23:22
[f1c7fde7] part of check-in [c7021960] In the command-line shell, in the output of the ".dump", ".schema", and ".fullschema" commands, convert CREATE TABLE statements that appear to come from shadow tables into CREATE TABLE IF NOT EXISTS statements. (check-in: [c7021960] user: drh branch: trunk, size: 185576)
2016-12-07
15:49
[9597efa5] part of check-in [f3608187] Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. (check-in: [f3608187] user: drh branch: trunk, size: 184950)
2016-11-23
23:18
[a3fc2c71] part of check-in [9a603a18] Fix the error message for invalid ".mode" arguments in the command-line shell, so that it mentions the new "quote" mode. (check-in: [9a603a18] user: drh branch: trunk, size: 184978)
2016-11-20
17:59
[b6ba45f7] part of check-in [b3b7b42d] Fix harmless compiler warnings. (check-in: [b3b7b42d] user: drh branch: trunk, size: 184972)
2016-11-11
14:54
[f04e4af7] part of check-in [f98c8ac8] Back out the "--raw" option on ".read" in the command-line shell. Instead, fix the command-line shell so that if EOF is reached without seeing a final semicolon, it goes ahead and passes the accumulated SQL text to SQLite. (check-in: [f98c8ac8] user: drh branch: trunk, size: 184847)
05:19
[dd8dbdcf] part of check-in [6311a8bd] In the command line shell, avoid using utf8_printf() in a couple places where it is superfluous. (check-in: [6311a8bd] user: mistachkin branch: trunk, size: 185660)
04:37
[e77c47b0] part of check-in [09233770] Add the --raw option to the ".read" dot-command of the command-line shell, to cause the named file to be read and sent directly into sqlite3_exec() without any interpretation. (check-in: [09233770] user: drh branch: trunk, size: 185666)
2016-11-03
13:12
[63e54cfa] part of check-in [ba9873da] In the command-line shell, fix the .imposter command so that it works with indexes on expressions. Fix the ".mode quote" mode so that it works with ".headers ON". (check-in: [ba9873da] user: drh branch: trunk, size: 184864)
13:01
[859c497e] part of check-in [be3ec8fd] Add the ".imposter" command to the command-line shell. (check-in: [be3ec8fd] user: drh branch: trunk, size: 184413)
02:25
[0abcad59] part of check-in [ad08753a] Fix an possible NULL pointer deference in the command-line shell that can occur when using imposter mode. (check-in: [ad08753a] user: drh branch: trunk, size: 182077)
2016-10-21
17:39
[f0e8b54c] part of check-in [c4f5fa78] Add ".mode quote" to the command-line shell. (check-in: [c4f5fa78] user: drh branch: trunk, size: 182038)
2016-09-16
20:39
[b80396d2] part of check-in [6fc95dd7] Fix typo in the name of a Win32 string conversion routine. Replace several uses of raw_printf() with utf8_printf() in the shell. (check-in: [6fc95dd7] user: mistachkin branch: trunk, size: 181708)
19:11
[131978e9] part of check-in [e660402e] Fix problems with the fileRead() function in the command-line shell. Fix a harmless memory leak in the command-line shell, to make validation testing easier. (check-in: [e660402e] user: drh branch: trunk, size: 181604)
18:53
[6fbbb69f] part of check-in [9885dac4] Remove the #ifdef SQLITE_DEBUG from around the testcase_glob() routine in the command-line shell. (check-in: [9885dac4] user: drh branch: trunk, size: 181432)
11:53
[ae7058ef] part of check-in [a3e3b3e1] Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. (check-in: [a3e3b3e1] user: drh branch: trunk, size: 181487)
02:52
[2c558e83] part of check-in [792afefa] In the shell, make ".testcase" and ".check" available in all configurations, not just SQLITE_DEBUG. All testcases to be named. Show the result of each testcase on stdout. (check-in: [792afefa] user: drh branch: trunk, size: 181364)
00:26
[1de20c81] part of check-in [8e5c9203] In the command-line shell, add the --new option to the ".open" command. Also, report the current database filename as part of the ".show" command. (check-in: [8e5c9203] user: drh branch: trunk, size: 180809)
2016-09-15
21:35
[89a3adbf] part of check-in [62289f27] Add the ".testcase" and ".check" dot-commands in the shell, when compiled using SQLITE_DEBUG. (check-in: [62289f27] user: drh branch: trunk, size: 179894)
2016-09-07
10:10
[de7c7e98] part of check-in [d8451fe8] Fix the ".read" command in the command-line shell so that it understands that the input is not interactive. (check-in: [d8451fe8] user: drh branch: trunk, size: 175724)
2016-08-01
17:06
[79dda477] part of check-in [90d2c490] Fix other harmless compiler warnings. (check-in: [90d2c490] user: drh branch: trunk, size: 175702)
2016-07-25
11:27
[9351fc6d] part of check-in [67e1dc98] Add --enable-memsys3 and --enable-memsys5 options to the configure script. (check-in: [67e1dc98] user: drh branch: trunk, size: 175651)
2016-07-23
20:27
[ad6375a1] part of check-in [c8e0539b] Use sqlite3_trace_v2() instead of sqlite3_trace() in the shell. (check-in: [c8e0539b] user: drh branch: trunk, size: 175594)
2016-07-13
13:05
[a8a9e392] part of check-in [824b39e5] Fix harmless compiler warnings in shell.c for NetBSD. (check-in: [824b39e5] user: drh branch: trunk, size: 175488)
2016-05-28
15:03
[c80b8d56] part of check-in [3a461043] Enhance the sqlite3_load_extension() API so that the first parameter (the "db" parameter) can be NULL. An extension that is not associated with any database connection remains loaded for the life of the process. (check-in: [3a461043] user: drh branch: persistent-extensions, size: 175483)
2016-04-15
15:03
[14ff7f66] part of check-in [3e217d62] CLI enhancement: Add the ".eqp full" option, that shows both the EXPLAIN QUERY PLAN and the EXPLAIN output for each command run. Also disable any ".wheretrace" and ".selecttrace" when showing EQP output. (check-in: [3e217d62] user: drh branch: trunk, size: 175474)
01:55
[f01fc4f2] part of check-in [9e14aa14] Progress toward getting DISTINCT to use a seek to advance to the next distinct row, when driven by an appropriate index. (check-in: [9e14aa14] user: drh branch: skip-ahead-distinct, size: 173623)
2016-04-13
21:00
[ebcdf99f] part of check-in [55a62483] Fix compiler warnings by removing surplus local variables in the schema pretty-printer logic of the command-line shell. (check-in: [55a62483] user: drh branch: trunk, size: 173625)
15:33
[aeaab684] part of check-in [83cfe82c] Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (check-in: [83cfe82c] user: drh branch: trunk, size: 173643)
2016-04-04
17:34
[b7922fa2] part of check-in [4534ebf1] Improved handling of UTF8 by the command-line shell. (check-in: [4534ebf1] user: drh branch: trunk, size: 171316)
17:23
[e0996a0b] part of check-in [65c7bcc4] Add the ".auth ON|OFF" command to the command-line shell. (check-in: [65c7bcc4] user: drh branch: trunk, size: 170373)
12:38
[faa78340] part of check-in [0213d6af] Fix harmless compiler warnings. (check-in: [0213d6af] user: drh branch: trunk, size: 168540)
02:33
[ba897473] part of check-in [b36dfdff] Refinements to the previous check-in. (check-in: [b36dfdff] user: mistachkin branch: altShellFix, size: 169447)
02:16
[cfe5edc1] part of check-in [74183a5f] Experimental changes to the command line shell to make it work better with Unicode on Windows. (check-in: [74183a5f] user: mistachkin branch: altShellFix, size: 169411)
2016-04-03
20:50
[e126f647] part of check-in [f76c3a0c] Replace the new fprintf() calls. (check-in: [f76c3a0c] user: mistachkin branch: altShellFix, size: 168614)
20:45
[c8a75d0d] part of check-in [566b551e] Merge updates from trunk. (check-in: [566b551e] user: mistachkin branch: altShellFix, size: 168508)
2016-03-09
08:08
[4aba7844] part of check-in [59caca43] Merge latest trunk changes with this branch. (check-in: [59caca43] user: dan branch: schemalint, size: 160695)
2016-03-04
16:42
[cd3f82fd] part of check-in [456df336] Merge recent enhancements from trunk. Default page size is 4096. Writes to statement journals are avoided. (check-in: [456df336] user: drh branch: sessions, size: 168504)
2016-02-27
19:19
[5e0ab1e7] part of check-in [f681d800] Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. (check-in: [f681d800] user: drh branch: trunk, size: 159755)
17:12
[f30efdd6] part of check-in [3c36948f] Enhance the ".stats" command in sqlite3.exe to show one-time stats information if invoked with one argument. Also show /proc/PID/io information if run on Linux. (check-in: [3c36948f] user: drh branch: trunk, size: 159825)
2016-02-25
18:54
[529ff15f] part of check-in [b8659004] Merge all the latest changes from trunk. (check-in: [b8659004] user: drh branch: sessions, size: 167229)
13:33
[89b73e89] part of check-in [2e67a1c8] In the command-line shell: When the ".import" command is creating a new table using column names from the first row of CSV input, make sure double-quotes in the name are properly escaped. (check-in: [2e67a1c8] user: drh branch: trunk, size: 158480)
2016-02-13
14:07
[8cb62662] part of check-in [4d7a802e] Merge the changes for the 3.11.0 release candidate from trunk. (check-in: [4d7a802e] user: drh branch: sessions, size: 167229)
2016-02-11
21:01
[2cde87e0] part of check-in [ed49f297] Experimental integration of schemalint functionality with the shell tool. Does not work yet. (check-in: [ed49f297] user: dan branch: schemalint, size: 158845)
2016-02-09
20:31
[03674406] part of check-in [61951b15] In the shell, use the appropriate string constant instead of a literal new-line. (check-in: [61951b15] user: mistachkin branch: trunk, size: 158480)
20:04
[dad82078] part of check-in [6c6d7a6e] Improved auto-detection of EXPLAIN output in the shell. (check-in: [6c6d7a6e] user: drh branch: auto-explain, size: 158477)
18:39
[eae68d3a] part of check-in [1d62aa6b] Add auto-explain mode to the command-line shell. Default on. Auto-explain tries to automatically detect EXPLAIN queries and format them appropriately. (check-in: [1d62aa6b] user: drh branch: auto-explain, size: 157909)
2016-01-14
14:48
[01e109c2] part of check-in [007e5c6d] Merge the latest fixes and enhancements from trunk. (check-in: [007e5c6d] user: drh branch: sessions, size: 166655)
2016-01-12
19:37
[dcd7a836] part of check-in [5727562b] Add the ".vfslist" command to the command-line shell. (check-in: [5727562b] user: drh branch: trunk, size: 157906)
2016-01-04
19:02
[40ded7e3] part of check-in [c785cd78] Merge in last-minute patches for the 3.10.0 beta. (check-in: [c785cd78] user: drh branch: sessions, size: 165889)
2016-01-03
18:59
[3ecb7a85] part of check-in [54c5522d] Alternative to [76f5efa6], move definition of utf8_printf up. (check-in: [54c5522d] user: mistachkin branch: altShellFix, size: 157144)
11:27
[ed71dc76] part of check-in [76f5efa6] Fix a premature reference to utf8_printf in shell.c. (check-in: [76f5efa6] user: drh branch: trunk, size: 157140)
2016-01-01
13:25
[4f133a91] part of check-in [c0be246a] Merge the latest enhancements from trunk. (check-in: [c0be246a] user: drh branch: sessions, size: 165893)
2015-12-31
19:06
[8d152e83] part of check-in [8cf01fff] In the shell, use utf8_printf() when any string formatting is present and raw_printf() otherwise. (check-in: [8cf01fff] user: mistachkin branch: trunk, size: 157144)
2015-12-30
13:36
[ace08b69] part of check-in [a0a08b8c] Enhance the command-line shell to handle MBCS characters on input and output. (check-in: [a0a08b8c] user: drh branch: mbcs-shell, size: 155809)
2015-12-16
19:47
[341bfd2d] part of check-in [f6c9273c] Merge recent enhancements from trunk. (check-in: [f6c9273c] user: drh branch: sessions, size: 162743)
2015-12-07
21:46
[abbc74ea] part of check-in [9bbe1afc] Add the ".changes ON|OFF" command to the sqlite3.exe command-line shell, for testing and verifying the sqlite3_changes() and sqlite3_total_changes() interfaces. (check-in: [9bbe1afc] user: drh branch: trunk, size: 153994)
2015-12-02
20:40
[98bf4a35] part of check-in [d1a1278d] Merge recent enhancements from trunk. (check-in: [d1a1278d] user: drh branch: sessions, size: 162230)
2015-11-28
18:06
[27962379] part of check-in [7c6a809e] Add the SQLITE_FCNTL_VFS_POINTER file control which obtains a pointer to the top-level VFS in use by a database connection. (check-in: [7c6a809e] user: drh branch: trunk, size: 153481)
2015-11-19
19:40
[072fc360] part of check-in [7d6cfc79] Merge the latest enhancements from trunk. (check-in: [7d6cfc79] user: drh branch: sessions, size: 161631)
2015-11-17
19:17
[f0f59ea6] part of check-in [dc2ac024] Fix uninitialized variable in the command line shell. (check-in: [dc2ac024] user: mistachkin branch: trunk, size: 152882)
2015-11-16
08:54
[0092cd4e] part of check-in [ad5fcaa5] In the shell tool, avoid testing if (sqlite3_vfs.xGetCurrentInt64) is NULL for a version 1 VFS. This field is only defined for version 2 and greater. (check-in: [ad5fcaa5] user: dan branch: trunk, size: 152878)
2015-11-11
15:28
[acefb459] part of check-in [2518d5c9] Improvements to the SQLITE_CONFIG_PAGECACHE documentation. Enhance the command-line shell to be able to take advantage of the full range of SQLITE_CONFIG_PAGECACHE capabilities, such as setting pMem==NULL and N<0. (check-in: [2518d5c9] user: drh branch: trunk, size: 152878)
2015-10-09
15:29
[993863f8] part of check-in [c1d96fb6] Merge the version 3.9.0 changes and the incorporation of JSON1 and FTS5 into the amalgamation from trunk. (check-in: [c1d96fb6] user: drh branch: sessions, size: 161618)
2015-10-08
19:29
[d25df041] part of check-in [d820a1bd] First attempt to add json1 and fts5 to the amalgamation. This check-in does not compile. (check-in: [d820a1bd] user: drh branch: amalg-json1-fts5, size: 152869)
2015-09-30
14:50
[f38cfe6a] part of check-in [b2face9a] Merge recent enhancements from trunk, and especially the fix for ticket [1b266395d6bc10]. (check-in: [b2face9a] user: drh branch: sessions, size: 161766)
11:19
[dfd18e56] part of check-in [31a91ee7] Improve error handling in shell command ".tables". (check-in: [31a91ee7] user: dan branch: trunk, size: 153017)
2015-09-26
17:44
[a11b20da] part of check-in [33404b20] Enable adding JSON1 by appending the json1.c source file to the amalgamation and compiling with -DSQLITE_ENABLE_JSON1 (check-in: [33404b20] user: drh branch: trunk, size: 151980)
2015-09-25
16:29
[15186317] part of check-in [2c57b2f3] Disable the SQLITE_TESTCTRL_BENIGN_MALLOC_HOOKS mechanism and replace it with SQLITE_TESTCTRL_BENIGN_MALLOC_CTRL, which gives better control. (check-in: [2c57b2f3] user: drh branch: malloc-testing, size: 151702)
2015-09-14
10:47
[2b29a6f5] part of check-in [22ce9218] Merge the latest trunk enhancements. (check-in: [22ce9218] user: drh branch: sessions, size: 160730)
2015-09-01
18:52
[af164c3e] part of check-in [cb772366] Merge recent enhancements from trunk. (check-in: [cb772366] user: drh branch: sessions, size: 160732)
2015-08-31
14:27
[6332ef06] part of check-in [7bde6d4d] Merge the latest enhancements from trunk. (check-in: [7bde6d4d] user: drh branch: index-expr, size: 151981)
2015-08-29
19:03
[bbe2bab5] part of check-in [2e8e239c] Link the json1 extension into the command-line shell by default. (check-in: [2e8e239c] user: drh branch: trunk, size: 151983)
2015-08-25
16:57
[5a08835e] part of check-in [efaabdb7] Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. (check-in: [efaabdb7] user: drh branch: index-expr, size: 151832)
2015-08-20
23:54
[534f3323] part of check-in [e9196d56] Merge recent trunk enhancements, include table-valued functions. (check-in: [e9196d56] user: drh branch: sessions, size: 160583)
2015-08-10
20:22
[5e8e1115] part of check-in [ac5d2e9d] Add the sqlite3_experimental_log_open() interface. This is for diagnostic use only and is not intended to ever go on trunk. (check-in: [ac5d2e9d] user: drh branch: experimentalIoLog, size: 152165)
2015-08-07
20:06
[b1f91e60] part of check-in [6d47b35a] Add a specially formatted comment to shell.c to make it easier for scripts to edit. No code changes. (check-in: [6d47b35a] user: dan branch: trunk, size: 151834)
2015-06-25
15:44
[e4ad9031] part of check-in [924f4712] Merge all the latest enhancements from trunk. (check-in: [924f4712] user: drh branch: sessions, size: 160505)
2015-06-17
19:06
[5ebff868] part of check-in [7b84641e] Use 'binary' mode for popen with MSVC. (check-in: [7b84641e] user: mistachkin branch: popenMsvc, size: 151993)
18:57
[8af3cced] part of check-in [5b547da0] Improve spacing and comment style for the shell. No changes to code. (check-in: [5b547da0] user: mistachkin branch: trunk, size: 151756)
18:18
[09565d8e] part of check-in [199bfb67] Merge all recent enhancements and fixes from trunk. (check-in: [199bfb67] user: drh branch: sessions, size: 160490)
17:08
[69c9ca4d] part of check-in [fc4f4d1e] Fix a uninitialized variable use in the command-line shell when the ".open" command is invoked without any arguments. (check-in: [fc4f4d1e] user: drh branch: trunk, size: 151741)
2015-06-15
14:43
[ae5c3985] part of check-in [b0badb99] Fix harmless compiler warnings. (check-in: [b0badb99] user: drh branch: trunk, size: 151736)
2015-05-21
00:50
[a31c37ed] part of check-in [a71e2a72] Add the ".open" command to the command-line shell. Cherrypick from [21eccb919441]. (check-in: [a71e2a72] user: drh branch: branch-3.7.11, size: 94467)
2015-05-14
15:17
[f26cca96] part of check-in [4f922944] Merge in the IS-operator enhancements and other recent changes from trunk. (check-in: [4f922944] user: drh branch: sessions, size: 160454)
2015-05-08
01:04
[07dda7cd] part of check-in [902d0cb8] Fix harmless compiler warning with MSVC. (check-in: [902d0cb8] user: mistachkin branch: trunk, size: 151705)
2015-05-05
17:12
[a781037a] part of check-in [de7083cf] Merge all trunk enhancements and fixes into the sessions branch. (check-in: [de7083cf] user: drh branch: sessions, size: 160427)
2015-05-04
20:25
[1b6fc902] part of check-in [1c9c6eaa] Automatically enable the dbstat virtual table on all new database connections with the SQLITE_ENABLE_DBSTAT_VTAB compile-time option is used. (check-in: [1c9c6eaa] user: drh branch: trunk, size: 151678)
19:13
[ad4c91f8] part of check-in [850c1186] In the command-line shell, and the ".binary" command and additional C-style backslash escapes. (check-in: [850c1186] user: drh branch: trunk, size: 151824)
17:06
[4ef9436e] part of check-in [fc6504aa] Include the "dbstat" virtual table in the amalgamation. (check-in: [fc6504aa] user: drh branch: dbstat-in-amalgamation, size: 150815)
2015-05-02
18:25
[e83273a7] part of check-in [f8b15979] Add the SQLITE_LIMIT_PRINTF_WIDTH setting for sqlite3_limit() and associated logic for preventing DOS attacks using printf() with oversized widths or precisions. (check-in: [f8b15979] user: drh branch: limit-printf-width, size: 150888)
17:40
[b1e17be8] part of check-in [803cb60e] Add the ".limit" command to the command-line shell. (check-in: [803cb60e] user: drh branch: trunk, size: 150813)
2015-04-30
20:35
[0b68e745] part of check-in [822dfc00] Enhance the CLI to initialize the dbstat virtual table if compiled using SQLITE_ENABLE_STAT_VTAB. (check-in: [822dfc00] user: drh branch: trunk, size: 148346)
2015-04-29
16:50
[1e530790] part of check-in [48f553b0] Use sqlite3_malloc64() in place of sqlite3_malloc() internally. (check-in: [48f553b0] user: drh branch: trunk, size: 148202)
2015-04-28
12:27
[5e74f499] part of check-in [7ed86dd3] Add code to the shell to optionally initialize the dbstat virtual table. (check-in: [7ed86dd3] user: drh branch: stat-vtab-in-shell, size: 148337)
2015-04-23
13:49
[a412c46f] part of check-in [4e5f17d1] Merge the latest trunk enhancements and fixes into the sessions branch. (check-in: [4e5f17d1] user: drh branch: sessions, size: 156929)
2015-04-20
01:32
[48f78c32] part of check-in [b8ef1cde] Merge all recent trunk enhancements and fixes into the sessions branch. (check-in: [b8ef1cde] user: drh branch: sessions, size: 156832)
2015-04-19
21:43
[78eabce4] part of check-in [d05becd8] Fix harmless compiler warnings seen with MSVC 2015. (check-in: [d05becd8] user: mistachkin branch: vsix2015, size: 148180)
2015-04-16
15:05
[28b3e117] part of check-in [dd96211e] Add the --backslash option to the command-line shell for testing purposes. (check-in: [dd96211e] user: drh branch: trunk, size: 148083)
04:20
[04706b14] part of check-in [22827542] Merge updates from trunk. (check-in: [22827542] user: mistachkin branch: expShell, size: 148603)
2015-04-15
19:25
[72b61a9d] part of check-in [e018f4bf] Fix a potential one-byte buffer overread in the command-line shell. (check-in: [e018f4bf] user: drh branch: trunk, size: 147594)
2015-04-07
21:18
[6d509d55] part of check-in [c458db41] Merge updates from trunk. (check-in: [c458db41] user: mistachkin branch: expShell, size: 148590)
21:16
[7c436bca] part of check-in [6e504cd0] Enhance the shell export to support emitting column names in 'insert' mode when headers are enabled. (check-in: [6e504cd0] user: mistachkin branch: expShell, size: 148497)
2015-03-31
00:10
[c4d839ad] part of check-in [df94e61f] Merge all recent trunk enhancements and fixes into the sessions branch. (check-in: [df94e61f] user: drh branch: sessions, size: 156330)
2015-03-27
02:27
[84a1593b] part of check-in [0ec08ba8] Fix the ".testctrl imposter" command in the command-line shell to be consistent in error reporting and results with the other .testctrl commands. (check-in: [0ec08ba8] user: drh branch: trunk, size: 147581)
00:21
[f21e91ab] part of check-in [fe976c91] Using MSVC, get the sqlite3IoTrace variable working with the USE_STDCALL and/or DYNAMIC_SHELL options. (check-in: [fe976c91] user: mistachkin branch: trunk, size: 147547)
2015-03-25
00:09
[786d96e0] part of check-in [cbb93d1a] Backport the 'stdcall' related enhancements from trunk. (check-in: [cbb93d1a] user: mistachkin branch: stdcall-3.8.8, size: 141845)
2015-03-24
19:02
[560f5cee] part of check-in [54aaa6f2] Merge all recent trunk enhancements into the sessions branch. (check-in: [54aaa6f2] user: drh branch: sessions, size: 156259)
2015-03-23
21:32
[3ae1e538] part of check-in [0ee2d38d] Disable loadable extensions in the command-line shell on VxWorks user-space. (check-in: [0ee2d38d] user: drh branch: trunk, size: 147510)
2015-03-21
02:34
[b13fcdf5] part of check-in [441a00e7] Merge updates from trunk. (check-in: [441a00e7] user: mistachkin branch: expShell, size: 148248)
02:22
[9c1589c8] part of check-in [737630b8] Improvements to the MSVC build. Fix harmless compiler warnings. Enable use of 'stdcall'. (check-in: [737630b8] user: mistachkin branch: trunk, size: 147488)
2015-03-19
14:48
[d1ecce87] part of check-in [775a02d5] Fix typo in shell error message. (check-in: [775a02d5] user: mistachkin branch: trunk, size: 147443)
14:46
[c8b054cf] part of check-in [3e363f40] Merge updates from trunk. (check-in: [3e363f40] user: mistachkin branch: expShell, size: 148202)
13:30
[3e8fc22b] part of check-in [6a48b5d7] Fix a bug in error handling in the ".trace" command of the command-line shell. (check-in: [6a48b5d7] user: drh branch: trunk, size: 147442)
2015-03-09
13:07
[b90258c9] part of check-in [68c8937e] Merge recent trunk enhancements into the sessions branch. (check-in: [68c8937e] user: drh branch: sessions, size: 156191)
2015-03-03
19:56
[cce82ca2] part of check-in [55c21521] Fix compiler warnings when compiling under VxWorks 7. (check-in: [55c21521] user: drh branch: trunk, size: 147442)
2015-03-02
22:06
[e2e5b63a] part of check-in [7d92f1f1] Changes so that the amalgamation and the command-line shell build without modifications on VxWorks 7. Still gives a few compiler warnings, and still mostly untested on that platform. (check-in: [7d92f1f1] user: drh branch: trunk, size: 147176)
2015-02-28
14:03
[a552c1ff] part of check-in [6bf62463] In the command-line shell, the inability to read ~/.sqliterc is no longer a fatal error. A warning is issued, but processing continues. (check-in: [6bf62463] user: drh branch: trunk, size: 146620)
2015-02-27
19:40
[7929bf04] part of check-in [acf76843] Merge updates from trunk. (check-in: [acf76843] user: mistachkin branch: expShell, size: 147467)
2015-02-26
14:27
[c8a769c5] part of check-in [b1a9e291] In the command-line shell, change the units on the ".width" directive from bytes to characters. (check-in: [b1a9e291] user: drh branch: cli-char-width, size: 147432)
2015-02-25
14:02
[f21e2cec] part of check-in [131a2d31] Merge the latest trunk fixes into the sessions branch. (check-in: [131a2d31] user: drh branch: sessions, size: 155456)
12:52
[ee1a80bf] part of check-in [ec27ab0e] Add support for linenoise to shell.c. (check-in: [ec27ab0e] user: dan branch: branch-3.8.8, size: 141800)
10:54
[f06cca68] part of check-in [f7f2598c] Add support for linenoise to shell.c. (check-in: [f7f2598c] user: dan branch: linenoise, size: 146707)
2015-02-21
15:13
[75e9d6dc] part of check-in [f36bb5fa] Merge all recent trunk changes into the sessions branch. (check-in: [f36bb5fa] user: drh branch: sessions, size: 154885)
2015-02-12
22:45
[6276582e] part of check-in [9c5bcad1] For the shell '.import' command, make sure the last column value present is considered before NULL filling any missing ones. (check-in: [9c5bcad1] user: mistachkin branch: trunk, size: 146136)
2015-02-06
15:40
[a5c0f162] part of check-in [ae7eef11] Merge all the latest enhancements from trunk. (check-in: [ae7eef11] user: drh branch: sessions, size: 154882)
14:51
[82c25508] part of check-in [0f65a7e2] Change the name of ".info" to ".dbinfo" and add an optional second argument which is the ATTACH-ed DB about which information is provided. Provide ".indexes" as an alternative name to the legacy ".indices" command. (check-in: [0f65a7e2] user: drh branch: trunk, size: 146133)
14:19
[bb60212d] part of check-in [0a3100a7] Add the ".info" command to the shell. (check-in: [0a3100a7] user: drh branch: trunk, size: 145635)
2015-01-30
20:59
[22b4406b] part of check-in [42d56017] Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased. (check-in: [42d56017] user: drh branch: trunk, size: 142391)
2015-01-29
17:54
[ed7cf7c2] part of check-in [5940af8e] Add the INITMODE test-control. (check-in: [5940af8e] user: drh branch: initmode-testctrl, size: 142405)
02:26
[ff4dafe4] part of check-in [23054110] Experimental sqlite_db_config() setting to disable writing to all btrees except for one btree with a particular root page. (check-in: [23054110] user: drh branch: one-writable-btree, size: 143377)
2015-01-27
21:24
[efd35900] part of check-in [e7d2ec04] Fix harmless compiler warnings. (check-in: [e7d2ec04] user: mistachkin branch: trunk, size: 141915)
2015-01-24
12:12
[37c6d973] part of check-in [2a9ea9b4] In the command-line shell, make sure stderr is unbuffered so that it automatically flushes. This has always been the case already for unix and on Windows when the output is a console, but apparently was not the case on Windows when the output was a pipe. (check-in: [2a9ea9b4] user: drh branch: trunk, size: 141905)
2015-01-22
11:29
[acdf311a] part of check-in [bd63bf88] Change the undocumented ".selecttrace" command in the shell to accept an integer bitmask rather than a boolean. (check-in: [bd63bf88] user: drh branch: trunk, size: 141835)
2015-01-19
20:22
[f5e99e54] part of check-in [d8564f70] Remove a shell function that is now superfluous. (check-in: [d8564f70] user: mistachkin branch: expShell, size: 142612)
20:19
[1a542717] part of check-in [d9f4035b] Merge updates from trunk. (check-in: [d9f4035b] user: mistachkin branch: expShell, size: 142901)
15:05
[d2d3b467] part of check-in [824328f9] Enhance the command-line shell with the ability to set the SQLITE_TESTCTRL_NEVER_CORRUPT flag using: ".testctrl never_corrupt 1". (check-in: [824328f9] user: drh branch: trunk, size: 141852)
07:42
[e0fefd7e] part of check-in [c7167f88] Merge updates from trunk. (check-in: [c7167f88] user: mistachkin branch: expShell, size: 142782)
2015-01-18
20:30
[4958f393] part of check-in [7096e6c0] Set binary mode for output on Windows when writing a quoted string that might contain newline characters. (check-in: [7096e6c0] user: drh branch: trunk, size: 141733)
05:35
[b976fd2b] part of check-in [25e99f3f] Some experimental command line shell input/output enhancements. (check-in: [25e99f3f] user: mistachkin branch: expShell, size: 142210)
01:50
[96c40c85] part of check-in [80541e8b] Set the command-line shell stdin to binary mode on windows. (check-in: [80541e8b] user: drh branch: trunk, size: 141300)
2015-01-14
17:16
[ab438b98] part of check-in [0ba12454] Merge trunk 3.8.8 beta changes into the sessions branch (check-in: [0ba12454] user: drh branch: sessions, size: 149978)
2015-01-12
18:52
[5b8e786a] part of check-in [ca5f2c54] Merge updates from trunk. (check-in: [ca5f2c54] user: mistachkin branch: msvcW4, size: 141229)
18:02
[0cebd04b] part of check-in [856dd245] Work in progress on fixing harmless compiler warnings when using -W4 and MSVC. (check-in: [856dd245] user: mistachkin branch: msvcW4, size: 141327)
2015-01-10
16:49
[96ba1f63] part of check-in [9e92a5ed] Improvements to compile-time-option hygiene. Use "#if OPTION" instead of "#ifdef OPTION" in cases where that makes sense, so that -DOPTION=0 will work. Add the "Have-Not" configuration in releasetest.tcl which disables all of the "HAVE_component" compile-time options. (check-in: [9e92a5ed] user: drh branch: trunk, size: 141101)
2014-12-11
04:49
[1b7cb3ef] part of check-in [e0e102a0] Update a comment. (check-in: [e0e102a0] user: mistachkin branch: asciiMode, size: 141199)
03:29
[3628fab3] part of check-in [d48eda16] Rename a structure member to improve code clarity. (check-in: [d48eda16] user: mistachkin branch: asciiMode, size: 141196)
03:25
[d2c9565c] part of check-in [d8404340] Remove an unused structure member. (check-in: [d8404340] user: mistachkin branch: asciiMode, size: 141196)
03:20
[4649c6bd] part of check-in [cf9c6e7e] Further simplify shell mode changes. (check-in: [cf9c6e7e] user: mistachkin branch: asciiMode, size: 141256)
03:12
[84359f80] part of check-in [66a28f7a] Simplify and cleanup the implementation of the new ASCII mode for the shell. (check-in: [66a28f7a] user: mistachkin branch: asciiMode, size: 141406)
02:28
[1c7787d1] part of check-in [5b5d3e4d] Merge updates from trunk. (check-in: [5b5d3e4d] user: mistachkin branch: asciiMode, size: 142291)
2014-12-02
16:31
[81e4f2b5] part of check-in [2617d937] Merge all recent fixes and enhancements from trunk into sessions. (check-in: [2617d937] user: drh branch: sessions, size: 145183)
2014-11-28
13:35
[45d9c9bd] part of check-in [24fa2e98] Remove the ill-designed "-end" option from the command-line shell. Instead, allow multiple SQL or dot-commands as command-line arguments. Any -cmd commands are processed first, followed by other command-line arguments, for backwards compatibility. (check-in: [24fa2e98] user: drh branch: trunk, size: 136434)
11:54
[f49ecad5] part of check-in [b59397b1] Add the -end option to the command-line shell, which forces it to exit after reading prior command-line options (presumably including one or more -cmd options) and without reading standard input. (check-in: [b59397b1] user: drh branch: trunk, size: 135655)
2014-11-18
21:20
[a67b1304] part of check-in [f09055f3] Merge recent trunk enhancements, including the read-after-ROLLBACK change and the addition of sqlite3_stmt_scanstatus() support, as well as various minor bug fixes. (check-in: [f09055f3] user: drh branch: sessions, size: 144283)
2014-11-10
14:42
[bc28d599] part of check-in [7f3819f6] Shorten over-length source code lines in shell.c. (check-in: [7f3819f6] user: drh branch: trunk, size: 135534)
2014-11-07
13:52
[0500307f] part of check-in [57005085] In the ".scanstats on" output from the shell, round the estRows value to the nearest integer, rather than rounding toward zero. (check-in: [57005085] user: drh branch: trunk, size: 134944)
2014-11-06
12:46
[48fe276a] part of check-in [ee922682] Further improvements to the ".scanstats on" display in the shell. Be sure to show the results of all subqueries even if there are gaps in the SELECTID values. Add ".scanstats" to the ".help" output. (check-in: [ee922682] user: drh branch: scanstatus, size: 134938)
12:17
[64a941c0] part of check-in [d1c51c84] On the ".scanstats on" output in the shell, initialize the estimated count for the first loop of each subquery to the actual loop count. (check-in: [d1c51c84] user: drh branch: scanstatus, size: 134885)
12:08
[22c7c693] part of check-in [eacbbd88] Changes the formatting of ".scanstats on" in the shell so that the stats for subqueries are grouped together and occur after the main query. (check-in: [eacbbd88] user: drh branch: scanstatus, size: 134831)
04:42
[74768f90] part of check-in [64ad5761] Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the ".stmtscan on" output in the shell. (check-in: [64ad5761] user: drh branch: scanstatus, size: 134950)
03:55
[908ff96e] part of check-in [f9684000] Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for the estimated number of output rows per loop, rather than a 64-bit integer. Revise the output format for the ".scanstats on" in the shell to make use of this new capability. (check-in: [f9684000] user: drh branch: scanstatus, size: 134545)
2014-11-05
09:07
[5ad1eb4d] part of check-in [7974c0ed] Add the ".scanstats on" command to the shell tool. Executing this command causes the shell tool to print values from sqlite3_stmt_scanstatus() after each query is run. (check-in: [7974c0ed] user: dan branch: trunk, size: 134444)
2014-10-31
14:53
[e3a0e5d9] part of check-in [28b044a5] Merge recent trunk enhancements, and in particular the improvements to the b-tree balancing logic, into the sessions branch. (check-in: [28b044a5] user: drh branch: sessions, size: 141546)
2014-10-23
17:26
[ed2796b3] part of check-in [c6a5b67a] Add debugging code to count the number of iterations of each loop made as part of statement execution. (check-in: [c6a5b67a] user: dan branch: debug-loopcounters, size: 133963)
2014-10-17
21:35
[282f8f52] part of check-in [19fe4a0a] Fix a (probably harmless) bug in the CSV output mode of the command-line shell. (check-in: [19fe4a0a] user: drh branch: trunk, size: 132797)
2014-10-14
13:41
[f2b146c8] part of check-in [83d4114f] Merge recent trunk micro-optimizations and the DESC index GROUP BY ORDER BY bug fix into the sessions branch. (check-in: [83d4114f] user: drh branch: sessions, size: 141547)
2014-10-10
13:08
[18ee8bbe] part of check-in [177fff3b] Cause the command-line shell to return non-zero if the final SQL statement is incomplete. (check-in: [177fff3b] user: drh branch: trunk, size: 132798)
2014-10-01
01:52
[801af09a] part of check-in [2695772c] Merge the latest enhancements from trunk. (check-in: [2695772c] user: drh branch: sessions, size: 141531)
2014-09-30
12:33
[38f627b0] part of check-in [4ff51325] Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternative debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(), and sqlite3TreeViewSelect(). (check-in: [4ff51325] user: drh branch: trunk, size: 132782)
2014-09-21
22:49
[85aae71d] part of check-in [6406b77f] Merge all recent trunk changes into the sessions branch. (check-in: [6406b77f] user: drh branch: sessions, size: 141847)
2014-09-20
18:18
[dad23987] part of check-in [cbe0cf9d] Enable SELECT query planning tracing when compiled with SQLITE_ENABLE_SELECTTRACE and either SQLITE_DEBUG or SQLITE_TEST. (check-in: [cbe0cf9d] user: drh branch: select-trace, size: 133098)
2014-09-11
16:19
[c00220cd] part of check-in [842c6da8] Enhance the sqlite3_user_add() interface to initialize the user authentication logic. Add test cases for the extra argument on the end of the authorizer callback. (check-in: [842c6da8] user: drh branch: user-auth, size: 132848)
00:27
[7d26b652] part of check-in [2f6d8f32] Reorder parameters on the sqlite3_user_*() interfaces for consistency. Add the first TCL test cases. (check-in: [2f6d8f32] user: drh branch: user-auth, size: 132829)
2014-09-10
19:01
[4dac2ec6] part of check-in [a0455f9d] Add the ".user" shell command and implement the sqlite3_user_add() routine. Incremental check-in. The code compiles but does not work. (check-in: [a0455f9d] user: drh branch: user-auth, size: 132735)
2014-09-02
15:49
[ec6d5f63] part of check-in [d4cce2c7] Merge the latest trunk changes, including the multi-threaded sorter, into the sessions branch. (check-in: [d4cce2c7] user: drh branch: sessions, size: 139490)
2014-09-01
01:16
[713cef4d] part of check-in [3ef32461] Fix harmless compiler warnings for MSVC. (check-in: [3ef32461] user: mistachkin branch: trunk, size: 130739)
01:15
[31c5f73b] part of check-in [51f33cf1] Merge updates from trunk. (check-in: [51f33cf1] user: mistachkin branch: asciiMode, size: 136566)
2014-08-30
15:49
[10b3bbf9] part of check-in [f61db04b] In the command-line shell, added options --lookaside, --pagecache, and --scratch used to configure auxiliary memories. (check-in: [f61db04b] user: drh branch: trunk, size: 130709)
2014-08-25
23:44
[88378cef] part of check-in [e3305d4b] Remove the SQLITE_CONFIG_WORKER_THREADS configuration parameter. The number of worker threads in the sorter is now determined only by the PRAGMA threads=N setting. (check-in: [e3305d4b] user: drh branch: threads, size: 128749)
15:13
[6dab215a] part of check-in [29c5e8a7] Query or change the maximum number of worker threads allowed on each database connection separately using the "PRAGMA threads" command. (check-in: [29c5e8a7] user: drh branch: threads, size: 128801)
13:27
[200772ee] part of check-in [dfdc900f] Merge the recent performance enhancements implemented on trunk into the threads branch. (check-in: [dfdc900f] user: drh branch: threads, size: 128800)
2014-08-21
16:09
[34be9dc9] part of check-in [0b9e2c32] Merge all recent trunk changes, especially the fix for ticket [369d57fb8e5ccdff06f1], but also the skip-scan improvement and performance improvements in the b-tree code. (check-in: [0b9e2c32] user: drh branch: sessions, size: 137501)
2014-08-19
19:28
[728d2226] part of check-in [d09d63c0] Improvements to output formatting with the ".trace" command in the command-line shell. (check-in: [d09d63c0] user: drh branch: trunk, size: 128750)
00:26
[220564b7] part of check-in [b69f7dd1] Improved response to error conditions in the ".session" shell command and in the "changeset" command-line program. (check-in: [b69f7dd1] user: drh branch: sessions, size: 137416)
2014-08-18
20:01
[1761e117] part of check-in [7b12f1f9] A reasonably complete implementation of the "changeset" command-line tool and the ".sessions" command in the command-line shell. (check-in: [7b12f1f9] user: drh branch: sessions_from_cli, size: 137312)
17:56
[0845863f] part of check-in [55bb3544] Add the "changeset" command-line utility for getting an ASCII dump of change sets. (check-in: [55bb3544] user: drh branch: sessions_from_cli, size: 134786)
15:08
[6378fc28] part of check-in [c2fcf0b9] Begin adding commands to the command-line interface for interacting with the sessions extension. This is the first check-in of a work-in-progress. (check-in: [c2fcf0b9] user: drh branch: sessions_from_cli, size: 133219)
13:45
[41df1103] part of check-in [11a70e1a] Refactor the names of state objects in the command-line shell implementation.. (check-in: [11a70e1a] user: drh branch: trunk, size: 128665)
2014-08-15
22:37
[cdccecaa] part of check-in [c8ade949] Aborted merge. (check-in: [c8ade949] user: numist branch: obsolete, size: 124125)
2014-08-14
14:02
[26f8ef7f] part of check-in [a608fd1d] Merge the pre-3.8.6 changes into the threads branch. (check-in: [a608fd1d] user: drh branch: threads, size: 128810)
2014-08-11
14:21
[75bb7bd2] part of check-in [52b03f04] Fix harmless compiler warnings. (check-in: [52b03f04] user: drh branch: trunk, size: 128760)
2014-08-06
14:36
[4af71e7f] part of check-in [1202e977] Fix harmless compiler warnings. In the command-line shell, report if the ".system" command returns a non-zero result. (check-in: [1202e977] user: drh branch: trunk, size: 128791)
2014-07-24
22:51
[5129214f] part of check-in [9c424a5c] Correct help text and make consistent use of snprintf. (check-in: [9c424a5c] user: mistachkin branch: asciiMode, size: 134586)
22:20
[e1177e05] part of check-in [289092bb] Fix typo in comment and update help text. (check-in: [289092bb] user: mistachkin branch: asciiMode, size: 134592)
22:13
[3af679ca] part of check-in [8dc0cdf6] Merge updates from trunk. (check-in: [8dc0cdf6] user: mistachkin branch: asciiMode, size: 134515)
16:54
[05e9e7f6] part of check-in [77068589] Merge all recent trunk changes into the threads branch. (check-in: [77068589] user: drh branch: threads, size: 128777)
12:39
[191129c3] part of check-in [fb1048cb] Add the readfile(FILENAME) and writefile(FILENAME,CONTENT) SQL functions to the command-line shell. (check-in: [fb1048cb] user: drh branch: trunk, size: 128727)
12:09
[cca6ea15] part of check-in [16c8ce10] In the command-line shell, in CSV output mode, terminate rows with CRNL but do not expand NL characters in data into CRNL. Provide the extra -newline command-line option and the extra argument to .separator to designate an alternative newline character sequence for CSV output. (check-in: [16c8ce10] user: drh branch: trunk, size: 127004)
2014-07-19
20:15
[f1524cdc] part of check-in [7fe601ea] Add new ASCII mode to the shell capable of importing and exporting using the official unit and record separators (i.e. 0x1F and 0x1E, respectively). (check-in: [7fe601ea] user: mistachkin branch: asciiMode, size: 131529)
2014-07-18
14:43
[566aee82] part of check-in [fa80c64c] Improvements to the ".fullschema" command in the command-line shell. (check-in: [fa80c64c] user: drh branch: trunk, size: 126060)
2014-06-30
20:25
[2aa1fd88] part of check-in [ae23a65e] Merge the latest trunk changes into the threads branch. (check-in: [ae23a65e] user: drh branch: threads, size: 125690)
2014-06-23
23:28
[56de2dfa] part of check-in [ebec4892] Add the .fullschema command to the sqlite3.exe utility. This command shows the schema and the content of the sqlite_stat tables, all in one go. Useful when reporting problems with the query planner. (check-in: [ebec4892] user: drh branch: trunk, size: 125640)
2014-06-18
15:18
[3ac17418] part of check-in [0e1b7349] Merge in all recent changes from trunk, and especially the automatic index enhancements. (check-in: [0e1b7349] user: drh branch: threads, size: 124197)
2014-06-16
22:45
[058940e8] part of check-in [fc918f7d] Fix CSV import issue, reported via the mailing list, in the shell when the file to be imported ends with an empty line. (check-in: [fc918f7d] user: mistachkin branch: trunk, size: 124147)
15:01
[d472576b] part of check-in [b0b4c776] Add the ".eqp" dot-command to the ".help" output in the command-line shell. This was accidently omitted when the ".eqp" command was originally implemented for SQLite 3.8.4 (check-in [e6ecf7337658624]). (check-in: [b0b4c776] user: drh branch: trunk, size: 124146)
2014-06-05
13:22
[c431e19b] part of check-in [e4b01676] Bring the threads branch up-to-date with the 3.8.5 release. (check-in: [e4b01676] user: drh branch: threads, size: 124120)
2014-05-31
15:43
[98ce7f52] part of check-in [39fafe0a] Fix a harmless "scan-build" compiler warning in the command-line shell. (check-in: [39fafe0a] user: drh branch: trunk, size: 124070)
2014-05-29
20:39
[d4ec3e14] part of check-in [a80527f6] Fix a harmless compiler warning in the command-line shell code. (check-in: [a80527f6] user: drh branch: trunk, size: 124025)
20:24
[3d2cdb8d] part of check-in [416cb091] Merge changes from the trunk into the threads branch. (check-in: [416cb091] user: drh branch: threads, size: 124069)
20:17
[33f6c0bc] part of check-in [8f916ed1] Fix to the EXPLAIN indentation logic in the command-line shell. (check-in: [8f916ed1] user: drh branch: trunk, size: 124019)
12:36
[a9468905] part of check-in [48dce821] Improvements to error messages for errors in the dot-commands of the command-line shell. Add the ".once" command. The output of ".help" now goes to the designated output channel. (check-in: [48dce821] user: drh branch: trunk, size: 124019)
03:17
[f389c2bc] part of check-in [e58f4bd3] Only quote the arguments to the ".shell" and ".system" commands if they contain spaces. (check-in: [e58f4bd3] user: drh branch: trunk, size: 121631)
2014-05-28
20:22
[8a0f8f4c] part of check-in [d018a34a] Add the ".shell" and the ".system" commands (aliases for the same thing) to the command-line shell. (check-in: [d018a34a] user: drh branch: trunk, size: 121541)
2014-05-26
20:15
[4b976f04] part of check-in [82152027] Merge recent trunk changes into the threads branch. (check-in: [82152027] user: drh branch: threads, size: 121078)
18:27
[bfac06fb] part of check-in [856d44a2] Fix a problem in the shell when importing CSV files. If the leftmost field of the first row in the CSV file was both zero bytes in size and unquoted, no data was imported. (check-in: [856d44a2] user: dan branch: trunk, size: 121028)
2014-05-23
12:03
[86a6aa84] part of check-in [b5cde571] In the command-line shell, if three or more interrupt signals (control-c) are received in a row without a response from sqlite3_interrupt() then call exit(1) immediately. This allows control-C to interrupt the shell even if it is stuck in a computation or loop that does not involve the VDBE. (check-in: [b5cde571] user: drh branch: trunk, size: 120958)
2014-04-18
12:38
[6946aea9] part of check-in [8729aa3e] Merge recent trunk changes into the threads branch. (check-in: [8729aa3e] user: drh branch: threads, size: 120977)
00:06
[2afe7a71] part of check-in [9c696196] Add the SQLITE_TESTCTRL_BYTEORDER test control to interrogate SQLite's notion of the processor byte order and whether the byte order is known at compile-time or determined at run-time. (check-in: [9c696196] user: drh branch: trunk, size: 120927)
2014-04-07
18:44
[b44c3f17] part of check-in [cbfc0f6d] Experimental multi-threaded sorting changes to begin merging PMAs before SorterRewind() is called. (check-in: [cbfc0f6d] user: dan branch: abandoned, size: 120881)
2014-04-03
16:42
[afc0b1a5] part of check-in [a0910079] Merge all recent changes from trunk. (check-in: [a0910079] user: drh branch: threads, size: 120881)
00:32
[5260f2ad] part of check-in [9d2ae634] In the command-line shell, run set writable_schema before running the ".clone" command. (check-in: [9d2ae634] user: drh branch: trunk, size: 120831)
2014-04-01
15:38
[a0806075] part of check-in [643c86a0] Even if compile time option SQLITE_MAX_WORKER_THREADS is set to one or greater, set the default number of worker threads to zero. Distribute data more evenly between threads in sqlite3VdbeSorterWrite() to improve performance when sorting large amounts of data. Add new test file sort2.test. (check-in: [643c86a0] user: dan branch: threads, size: 120752)
2014-03-25
14:12
[f48b63f8] part of check-in [1cab8357] Enable four sorting threads by default in the command-line shell. (check-in: [1cab8357] user: drh branch: threads, size: 120656)
2014-03-20
18:45
[cee9f46f] part of check-in [01944c53] Fix the EXPLAIN indenter in the command-line shell to correctly handle NextIfOpen and PrevIfOpen opcodes. (check-in: [01944c53] user: drh branch: trunk, size: 120702)
2014-03-06
13:38
[bab4de12] part of check-in [0a4200f9] Improved EXPLAIN indentation of a loop in the ANALYZE logic for STAT4. Mark the not-found jump of a seek operation in that loop as never taken. (check-in: [0a4200f9] user: drh branch: trunk, size: 120647)
02:15
[c0cbbbe5] part of check-in [c87d8e07] Cosmetic change to the shell in-memory database warning to skip coloring the trailing period. (check-in: [c87d8e07] user: mistachkin branch: trunk, size: 120549)
2014-02-28
20:47
[7bf07bca] part of check-in [e6ecf733] In the command-line shell add the (undocumented and unsupported) ".eqp" command and -eqp command-line option, to cause EXPLAIN QUERY PLAN to be run on each SQL statement as it is evaluated. Intended use is for analysis of the query planner. (check-in: [e6ecf733] user: drh branch: trunk, size: 120549)
19:37
[e6d57332] part of check-in [0a3579d9] Provide an #ifdef in shell.c to work around issues when cross-compiling from Ubuntu to windows. (check-in: [0a3579d9] user: drh branch: trunk, size: 119479)
2014-02-27
15:11
[bf75ce6b] part of check-in [51ce713c] A better way of handling the USE_SYSTEM_SQLITE #define in shell.c. (check-in: [51ce713c] user: drh branch: trunk, size: 119456)
15:04
[720e79fa] part of check-in [a6690400] Add #defines to the command-line shell source code (shell.c) so that it can be imported directly into other projects (ex: Fossil) and used without editing. (check-in: [a6690400] user: drh branch: trunk, size: 119485)
2014-02-26
13:53
[ca2b066a] part of check-in [9c2e7612] In the command-line shell for CSV import, if the lines are \r\n terminated and the last field is blank, make sure an empty string and not a "\r" string is imported. (check-in: [9c2e7612] user: drh branch: trunk, size: 119231)
2014-02-11
16:22
[3dd86bf7] part of check-in [f5ad1e1b] Updates to the command-line shell. Simplify the banner message. Add the ".save" command as an alias for ".backup". When starting with no arguments, include a banner message warning that the database is transient and in-memory and mention the ".open" command. (check-in: [f5ad1e1b] user: drh branch: trunk, size: 119231)
14:37
[b1f75cfc] part of check-in [7989ce5f] Fixes to the "editline" support in the command-line shell. (check-in: [7989ce5f] user: drh branch: trunk, size: 118335)
2014-02-10
19:59
[cb8d1959] part of check-in [fe284afe] Add the ".save" command as an alias for ".backup". Improvements to the way font changes are implemented on the in-memory database warning. (check-in: [fe284afe] user: drh branch: memdb-warning, size: 119234)
19:36
[8b549f83] part of check-in [c9eba2f7] On unix, make the "transient in-memory database" text bold, but not red. Leave the text read on windows. (check-in: [c9eba2f7] user: drh branch: memdb-warning, size: 119233)
19:27
[7e4d5dcb] part of check-in [0fbc0fce] In the command-line shell, on the banner, warn about the use of a transient in-memory database in bold red text. (check-in: [0fbc0fce] user: drh branch: memdb-warning, size: 119236)
16:13
[df7d96e5] part of check-in [90e9deae] Modify the command-line shell to print a warning when using an in-memory database. (check-in: [90e9deae] user: drh branch: memdb-warning, size: 118612)
2014-02-06
02:46
[7dedf736] part of check-in [dd0db3f0] Add additional error messages and a progress spinner to the ".clone" command. (check-in: [dd0db3f0] user: drh branch: trunk, size: 118338)
01:15
[da0a97d9] part of check-in [4f9d9562] Rename the '.repair' shell command to '.clone'. (check-in: [4f9d9562] user: mistachkin branch: trunk, size: 117482)
00:49
[c128bf92] part of check-in [d1dfadea] Add the ".repair" command to the command-line shell. (check-in: [d1dfadea] user: drh branch: trunk, size: 117489)
2014-01-21
22:25
[24722d24] part of check-in [b2671e11] Change the recursive common table expression algorithm to use a queue instead of a pair of tables. Runs about 25% faster on the sudoku solver query. The OP_SwapCursors opcode is no longer required. The current implementation uses just a fifo, but the plan is to change it into a queue that will support ORDER BY and LIMIT in a recursive query. (check-in: [b2671e11] user: drh branch: cte-via-queue, size: 111461)
2014-01-13
20:38
[9f3bc02a] part of check-in [ac15455a] In the command-line shell, defend against a NULL-pointer dereference in the case where sqlite3_column_name() returns NULL (as might happen following an OOM error). (check-in: [ac15455a] user: drh branch: trunk, size: 111441)
2013-12-21
15:46
[a3541193] part of check-in [96397263] Fix the ".echo on" dot-command of the shell so that it echos comments in addition to SQL statements and dot-commands. Add the --explain option to speedtest1 so that the output can be piped into the command-line shell to show nicely-formated VDBE code for the entire test. (check-in: [96397263] user: drh branch: trunk, size: 111420)
2013-12-11
14:00
[18924f6c] part of check-in [5e239ecd] Fix a bug in the shell ".import" command: Do not end the field when an escaped double-quote occurs at the end of a CRNL line. (check-in: [5e239ecd] user: drh branch: trunk, size: 111318)
2013-11-27
13:24
[936a72ff] part of check-in [ceebcdca] Make sure the colWidth array is correctly initialized in the ".explain" command of the shell. (check-in: [ceebcdca] user: drh branch: trunk, size: 111311)
2013-11-21
23:37
[c4d06a92] part of check-in [3d47a556] Fix a harmless clang warning in the command-line shell. (check-in: [3d47a556] user: drh branch: trunk, size: 111314)
2013-11-18
08:41
[849ee96c] part of check-in [9c8d6856] Fix a problem with the shell tool EXPLAIN indentation code and VDBE sub-programs. (check-in: [9c8d6856] user: dan branch: trunk, size: 111306)
2013-11-15
03:16
[b98e7412] part of check-in [cbe85cc2] Another adjustment to the EXPLAIN indentation logic, in order to deal with the sorter loop on a CREATE INDEX statement. (check-in: [cbe85cc2] user: drh branch: trunk, size: 110732)
2013-11-14
23:59
[65a259d5] part of check-in [ea141a9b] Adjust the command-line shell EXPLAIN indentation logic to handle the second loop of an UPDATE that reads out a RowSet. (check-in: [ea141a9b] user: drh branch: trunk, size: 110718)
15:35
[044a7963] part of check-in [d1fbc6ca] An experimental virtual tables for showing the content of internal schema objects. (check-in: [d1fbc6ca] user: drh branch: schema2-vtab, size: 110904)
2013-11-13
19:01
[6ccc22b7] part of check-in [f668616a] Import the "PRAGMA vdbe_eqp" enhancement and the enhanced EXPLAIN formatting the shell from trunk. Fix a bug in skip-scan and add a test case to prevent a regression. (check-in: [f668616a] user: drh branch: skip-scan, size: 110712)
18:35
[3b23017d] part of check-in [e7d34ec6] In the shell tool, if an "EXPLAIN" command is executed in ".explain on" mode, attempt to automatically indent the bodies of loops in the output VDBE program. (check-in: [e7d34ec6] user: dan branch: trunk, size: 110648)
2013-10-30
12:43
[03d8d9b4] part of check-in [908e2c21] Enhance the timer in the shell to show wall-clock time in addition to user and kernel CPU time. (check-in: [908e2c21] user: drh branch: trunk, size: 107208)
12:30
[43647b08] part of check-in [5530cdc4] Have the shell ".timer on" command cause the shell to report wall-clock time for each query (as well as user and system CPU time). (check-in: [5530cdc4] user: dan branch: shell-wall-clock, size: 107162)
2013-10-24
15:20
[d5eebdc6] part of check-in [21eccb91] Add the ".open" command to the command-line shell. (check-in: [21eccb91] user: drh branch: trunk, size: 106438)
2013-10-11
16:35
[6f11f0e9] part of check-in [5f01cd36] Additional test cases and requirements marks for the unlikely(), likelihood() and instr() functions. (check-in: [5f01cd36] user: drh branch: trunk, size: 105627)
2013-10-01
15:30
[5ee50ca3] part of check-in [47323463] Change the ".dump" command in the command-line shell so that it COMMITs if there are database corruption errors but invokes ROLLBACK on any other kind of error. (check-in: [47323463] user: drh branch: trunk, size: 105619)
2013-09-04
16:08
[d920a891] part of check-in [d8fdc782] Fix a bug in the command-line shell for ".mode insert" on UTF16 databases with BLOB values. (check-in: [d8fdc782] user: drh branch: trunk, size: 105555)
2013-08-29
13:23
[0fb2ce98] part of check-in [43aa7d23] Fix an off-by-one error that causes a quoted empty string at the end of a CRNL-terminated line of CSV input to be misread by the shell. Cherrypick of [b5617e4fdadc4c]. (check-in: [43aa7d23] user: drh branch: branch-3.8.0, size: 105379)
2013-08-28
18:18
[dbe064d4] part of check-in [12d0a885] Add the win32-longpath VFS allowing windows filenames up to 32K characters in length. Remove unused code when -DSQLITE_MAX_MMAP_SIZE=0. Fix some compiler warnings on windows. (check-in: [12d0a885] user: drh branch: trunk, size: 105407)
13:33
[f726500a] part of check-in [b5617e4f] Fix an off-by-one error that causes a quoted empty string at the end of a CRNL-terminated line of CSV input to be misread by the shell. (check-in: [b5617e4f] user: drh branch: trunk, size: 105388)
01:54
[250e4770] part of check-in [8917e9f9] Fix several harmless compiler warnings. Fix a couple compiler issues with the shell. (check-in: [8917e9f9] user: mistachkin branch: mmapDisabled, size: 105397)
2013-08-26
23:18
[00a23311] part of check-in [a32af0ab] Merge the STAT4 capability into trunk. (check-in: [a32af0ab] user: drh branch: trunk, size: 105387)
2013-08-19
14:23
[1c317a4c] part of check-in [753a402e] Remove unused variables from the command-line shell sources. (check-in: [753a402e] user: drh branch: trunk, size: 105378)
11:15
[909f6c4a] part of check-in [a0d9ca4f] Fixes for harmless compiler warnings. (check-in: [a0d9ca4f] user: drh branch: trunk, size: 105394)
2013-08-07
18:42
[128eb16c] part of check-in [08f74c45] Merge latest trunk changes with this branch. (check-in: [08f74c45] user: dan branch: sqlite_stat4, size: 105366)
16:04
[cb075e24] part of check-in [1e80c4b1] Fix the ".dump" command on the command-line shell so that it works for "sqlite_stat4" in addition to "sqlite_stat1". (check-in: [1e80c4b1] user: drh branch: sqlite_stat4, size: 104701)
2013-08-06
14:36
[927e17b3] part of check-in [5dcc2d91] For the ".import" command of the command-line shell, start a transaction if there is not one active already. (check-in: [5dcc2d91] user: drh branch: trunk, size: 105357)
14:01
[18be30ad] part of check-in [2b1743d6] Clean up the input reader in the command-line shell for improved legibility and performance. (check-in: [2b1743d6] user: drh branch: trunk, size: 105169)
2013-07-25
17:07
[52f975ea] part of check-in [8bcbb33f] In the command-line shell, work around the fact that popen() and pclose() are not defined in stdio.h. in C89 and later. (check-in: [8bcbb33f] user: drh branch: trunk, size: 104692)
2013-07-18
20:28
[7da98ff9] part of check-in [37abfe0c] Remove unused "codec" code from the command-line shell. (check-in: [37abfe0c] user: drh branch: trunk, size: 104545)
2013-07-12
21:09
[4c02ec99] part of check-in [92adaee5] Make sure the shell does not try to put a zero terminator on the end of an unallocated zero-length string when running ".import" on an empty file. (check-in: [92adaee5] user: drh branch: trunk, size: 104721)
2013-06-30
20:24
[c8cd06e6] part of check-in [60b65e5e] Fix an issue in the command-line shell with CSV import of rows with empty columns. (check-in: [60b65e5e] user: drh branch: trunk, size: 104760)
2013-06-29
15:40
[0587c18f] part of check-in [b003b2b2] Fix the build of the command-line shell on windows. Windows uses "_pclose" rather than "pclose" as the pointer to the function that closes a popen pipe. (check-in: [b003b2b2] user: drh branch: trunk, size: 104786)
2013-06-27
14:07
[c0f38cee] part of check-in [4c02b344] If the filename argument to the ".import" command in the command-line shell begins with '|' then treat it as an input pipe rather than a file. (check-in: [4c02b344] user: drh branch: trunk, size: 104792)
13:26
[3b8fff51] part of check-in [656a1fe5] Improved handling of backslash escapes on double-quoted arguments to dot-commands in the command-line shell. (check-in: [656a1fe5] user: drh branch: trunk, size: 104289)
13:01
[fab2f606] part of check-in [e88fd5b2] The undocumented and unsupported ".selftest" command in the command-line shell utility is now only available if compiled with SQLITE_DEBUG. Also fix a windows compiler warning in that command. (check-in: [e88fd5b2] user: drh branch: trunk, size: 104146)
2013-06-26
22:46
[92cbe95e] part of check-in [93f63215] Update the ".import" command of the command-line shell so that it can accept field values that span multiple lines and so that it issues error messages if the input text does not strictly conform to RFC4180. (check-in: [93f63215] user: drh branch: trunk, size: 104037)
2013-06-25
22:01
[a02544af] part of check-in [f1366bab] Add a new (experimental) sqlite3_stmt_status() verb that returns the number of VM steps. (check-in: [f1366bab] user: drh branch: status-vm-step, size: 100851)
2013-05-31
14:31
[ab6eea96] part of check-in [b9578c37] Enhance the shell to provide more flexibility when entering numeric arguments on dot-commands. In particular, allow hex arguments to .wheretrace. (check-in: [b9578c37] user: drh branch: nextgen-query-plan-exp, size: 100696)
2013-05-24
11:57
[9a18124f] part of check-in [9e2c17c5] Fix harmless compiler warnings in the shell. (check-in: [9e2c17c5] user: drh branch: trunk, size: 99387)
2013-05-06
21:01
[2109d54f] part of check-in [e5b3cd74] In the command-line shell, output the elements of the schema in the order that they appear in the sqlite_master table. This is necessary in some cases to make the schema parsable. (check-in: [e5b3cd74] user: drh branch: trunk, size: 99401)
20:28
[115bc2fa] part of check-in [b72d3659] In the command-line shell, make sure the output of dot-commands goes to the same redirected output stream as the result of queries. Ticket [2f96536e7ff7dba] (check-in: [b72d3659] user: drh branch: trunk, size: 99562)
2013-04-25
14:59
[5d527e5d] part of check-in [de556add] Move the test_spellfix.c module to ext/misc/spellfix.c. (check-in: [de556add] user: drh branch: std-ext, size: 99481)
2013-04-17
17:33
[aca9d946] part of check-in [e2c94ab9] In the command-line shell, allow a dot-command to occur after a multi-line c-style comment. (check-in: [e2c94ab9] user: drh branch: trunk, size: 99757)
12:19
[a303eb45] part of check-in [467e2181] Update the command-line shell to give an exit code of 0 when the ".quit" command is run from the command-line. (check-in: [467e2181] user: drh branch: trunk, size: 99660)
2013-04-15
17:03
[06bca040] part of check-in [ea1404a1] Refactoring the mmap interface. The controlling pragma is now "mmap_size" instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. (check-in: [ea1404a1] user: drh branch: trunk, size: 99622)
2013-04-03
01:26
[319b7791] part of check-in [fc30d06c] Add the -mmap option to the command-line shell, for setting the default mmap_limit. (check-in: [fc30d06c] user: drh branch: experimental-mmap, size: 99590)
2013-02-20
00:54
[7c41bfcd] part of check-in [9bd9bd9c] On Minix, disable the ".timer" command in the shell in order to avoid calling getrusage(). (check-in: [9bd9bd9c] user: drh branch: trunk, size: 98709)
2013-01-28
18:18
[26679124] part of check-in [b4d94947] Cause the command-line shell to issue an error message if you give something that does not look like a boolean value to a dot-command that wants a boolean argument. (check-in: [b4d94947] user: drh branch: trunk, size: 98685)
2013-01-25
19:11
[215278ae] part of check-in [7813b17d] Fix the test_spellfix.c extension so that it can be made loadable at run-time. Add spellfix to the shell when building using the build-shell.sh script. (check-in: [7813b17d] user: drh branch: trunk, size: 98500)
18:33
[db1b04cc] part of check-in [8ba951d1] Enhance the command-line shell so that adding a non-zero numeric argument to the ".exit" command causes an immediate exit without cleaning up. This can be used (for example) to cause journal files to be left behind. (check-in: [8ba951d1] user: drh branch: trunk, size: 98358)
2013-01-23
18:53
[af0309c2] part of check-in [f1127e87] Improved parsing of the arguments to the ".backup" command in the command-line shell. (check-in: [f1127e87] user: drh branch: trunk, size: 98315)
2012-12-31
20:16
[11c96115] part of check-in [a611c750] More test cases for the REGEXP operator. Fix minor bugs uncovered by these test cases. (check-in: [a611c750] user: drh branch: trunk, size: 97627)
19:18
[e6525781] part of check-in [46c8c01b] Add the test_regexp.c module containing a cross-platform implementation of the REGEXP operator. (check-in: [46c8c01b] user: drh branch: trunk, size: 97623)
2012-12-04
00:23
[e392dd1c] part of check-in [41fd9dd2] Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (check-in: [41fd9dd2] user: mistachkin branch: tclMode, size: 97493)
2012-12-01
20:21
[99091f9d] part of check-in [2e5e6515] Do not exit the command-line shell if a ".read" command invokes a script that contains two errors. But reported on the mailing list. (check-in: [2e5e6515] user: drh branch: trunk, size: 97331)
2012-10-25
15:43
[24cd0aa7] part of check-in [a6d906cf] Fix typo in usage text for the command-line shell. Also, in the same usage text, make the file name argument to -init uppercase for consistency. (check-in: [a6d906cf] user: mistachkin branch: trunk, size: 97329)
15:32
[9e9af864] part of check-in [848f87e2] Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. (check-in: [848f87e2] user: drh branch: ssdsim, size: 97760)
15:23
[d570e6cb] part of check-in [317c80cb] Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). (check-in: [317c80cb] user: drh branch: trunk, size: 97329)
01:50
[62324221] part of check-in [9e6efcf0] Initial check-in of a test VFS designed to simulate a NAND-flash SSD for the purpose of measuring and subsequently minimizing write amplification caused by SQLite. The code in this check-in compiles but does not run. (check-in: [9e6efcf0] user: drh branch: ssdsim, size: 97594)
2012-09-21
22:50
[8ee5a3cb] part of check-in [1be4b16b] Enable query planner tracing using the new (and undocumented) ".wheretrace 1" command in the command-line shell if both the shell and the core are compiled with SQLITE_DEBUG and SQLITE_ENABLE_WHERETRACE. This is not a supported API. Use for testing and debugging only. (check-in: [1be4b16b] user: drh branch: trunk, size: 97189)
13:40
[f41fbf4c] part of check-in [a1d8269d] Command-line shell enhancements: Added the ".print" command. Enhanced the ".width" command so that negative widths will right-justify. (check-in: [a1d8269d] user: drh branch: trunk, size: 96979)
2012-08-27
21:19
[87953c5d] part of check-in [24420d6d] Add to #undef statements to the command-line shell, go make sure that the macros definitions that follow do not collide with system definitions. (check-in: [24420d6d] user: drh branch: trunk, size: 96378)
2012-06-27
16:41
[076e1c90] part of check-in [3b4f5add] Another changes to the shell in support of SQLITE_OMIT_AUTOINIT. (check-in: [3b4f5add] user: drh branch: trunk, size: 96351)
16:12
[88e34bc1] part of check-in [95c0c995] Update the shell so that it works with SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT. (check-in: [95c0c995] user: drh branch: trunk, size: 96325)
2012-06-21
14:05
[74e47ddb] part of check-in [d3d491a5] Merge several compiler compatibility fixes to trunk. (check-in: [d3d491a5] user: mistachkin branch: trunk, size: 96253)
13:00
[d3322514] part of check-in [ff828c67] Remove support for OS/2 from the source tree. (check-in: [ff828c67] user: drh branch: trunk, size: 96235)
2012-06-18
08:00
[79cbf565] part of check-in [f970a3de] Fix a few compilation issues that can occur with certain compilers (e.g. GCC 2.95.3, MSVC). (check-in: [f970a3de] user: mistachkin branch: compiler-compat, size: 96549)
2012-05-21
03:15
[c16f72e3] part of check-in [e092ff69] Change the ".schema" command of the shell to output VIEWs in declared order, rather than alphabetical order, so that nested views will appear in the correct order. Fix for ticket [cfe84e86839e59e8]. (check-in: [e092ff69] user: drh branch: trunk, size: 96531)
2012-04-24
12:12
[04399b2f] part of check-in [282f2a74] Fix a sign-extension problem for BLOB output in ".insert" mode of the command-line shell. (check-in: [282f2a74] user: drh branch: trunk, size: 96372)
2012-04-23
12:38
[151a17fe] part of check-in [ce2d06e2] Update the ".table" command in the shell to show all tables in all attached databases, and to avoid using the deprecated sqlite3_get_table() function. (check-in: [ce2d06e2] user: drh branch: trunk, size: 96367)
2012-04-21
11:33
[dec1a189] part of check-in [feff1ef0] If terminating interactive input to the command-line shell with ^D, issue an extra \n to move the cursor to the next line before exiting. This check-in also accidently adds the test_spellfix.c file to the source tree. (check-in: [feff1ef0] user: drh branch: trunk, size: 95298)
2012-04-17
09:09
[11185a9a] part of check-in [8e2363ad] Add an undocumented and possibly ephemeral ".breakpoint" command to the command-line shell, to call a no-op routine on which it is convenient to set a symbolic debugger breakpoint. (check-in: [8e2363ad] user: drh branch: trunk, size: 95253)
2012-04-16
17:22
[5d2484be] part of check-in [020b5e90] Fix a bug in the command-line shell logic that attempts to continue with a ".dump" even after encountering database corruption. (check-in: [020b5e90] user: drh branch: trunk, size: 94842)
2012-04-11
11:38
[6fef5d2c] part of check-in [93a0f452] Fix harmless static-analysis warnings, mosting having to do with memory leaks in the command-line shell. Add a clang analysis of the command-line shell to the "warnings-clang.sh" script. Other minor cleanups to the command-line shell code. (check-in: [93a0f452] user: drh branch: trunk, size: 94846)
2012-04-04
16:56
[ce4d4158] part of check-in [b9ac3d7e] Add the ".trace" option to the command-line shell. (check-in: [b9ac3d7e] user: drh branch: trunk, size: 95147)
2012-03-30
00:05
[abf18d6e] part of check-in [fa82062c] In the ".output" command of the shell, if the first character of the output filename is '|' then use popen() instead of fopen(). (check-in: [fa82062c] user: drh branch: trunk, size: 94288)
2012-03-24
20:09
[3179db5d] part of check-in [30b8dd32] Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell. (check-in: [30b8dd32] user: drh branch: trunk, size: 93837)
2012-03-22
12:50
[55e09ef7] part of check-in [638b7115] Always quote the names of tables in the output of the shell's ".dump" command, even if the name is pure alphabetic text, in case the name is a keyword. (check-in: [638b7115] user: drh branch: trunk, size: 93662)
2012-02-07
14:22
[92e96bf5] part of check-in [81ce52af] Port the command-line shell enhancements including the new --cmd option to the nx-devkit branch. (check-in: [81ce52af] user: drh branch: nx-devkit, size: 92270)
14:13
[aa28f117] part of check-in [9497893b] Command-line shell enhancements: Reorganize the "usage" comment so that options are in alphabetical order. Add the new "--cmd" option. Allow either "--option" or "-option" for options. (check-in: [9497893b] user: drh branch: trunk, size: 93661)
2012-01-28
21:08
[60d147c2] part of check-in [e6eea8d5] Update the .dump command of the command-line shell so that it (1) avoids putting the semicolon of a DDL statement on the same line as a comment, (2) avoids long expression, even when dumping a table with many columns, and (3) avoids unnecessary quoting of the table name. This fixes tickets [c04a8b8a4f] and [232637c465]. Shell change only; no changes to the SQLite core. (check-in: [e6eea8d5] user: drh branch: trunk, size: 93000)
2012-01-16
16:56
[f492df9f] part of check-in [93aa17d8] Enhance the command-lin shell to interpret CSV files as described by the wikipedia article on CSV. (check-in: [93aa17d8] user: drh branch: trunk, size: 92319)
2011-12-14
18:33
[aa4183d4] part of check-in [da118e02] Merge the nx-devkit changes into trunk. This includes the new SQLITE_FCNTL_VFSNAME file-control. (check-in: [da118e02] user: drh branch: trunk, size: 91925)
17:53
[670644f7] part of check-in [cdbfb553] Add a file-control that will discover the name of the bottom-level VFS and all the shims in between. (check-in: [cdbfb553] user: drh branch: vfsname-filectrl, size: 91609)
2011-12-12
20:01
[183c4b6a] part of check-in [c4e2ce48] Backport a minimal set of changes needed to get 8+3 filenames and the multiplexor shim playing well together. (check-in: [c4e2ce48] user: drh branch: nx-devkit, size: 91210)
16:51
[ea9c11ae] part of check-in [9b2691aa] Add magic comments to shell.c to make it easier for scripts to insert additional version information displays for custom builds. (check-in: [9b2691aa] user: drh branch: trunk, size: 91526)
2011-12-06
19:44
[a1eadb2f] part of check-in [79ae51c5] Begin adding the data-structure explaining subsystem. All is contained within (check-in: [79ae51c5] user: drh branch: tree-explain, size: 91480)
2011-11-09
16:12
[29812a90] part of check-in [bc10a753] Minor changes needed to restore full branch test coverage. (check-in: [bc10a753] user: drh branch: experimental-pcache, size: 91164)
2011-11-04
00:35
[6d2ad7f8] part of check-in [b06bf3b3] Enhance the shell so that the ".schema" command works with case insensitive LIKE patterns even with PRAGMA cache_sensitive_like=ON. (check-in: [b06bf3b3] user: drh branch: trunk, size: 91290)
2011-10-14
21:49
[f0ab7932] part of check-in [60fee957] Add assert() statements and eliminate needless variable assignments in order to get the clang scan-build utility to report zero problems against the SQLite core. Clang's static analysis did find one real problem - but it was in the command-line shell, not in the SQLite core. (check-in: [60fee957] user: drh branch: trunk, size: 91269)
2011-10-13
16:36
[e30e2010] part of check-in [8bf13b03] Provide a complete prototype for isatty() in the command-line shell sources. (check-in: [8bf13b03] user: drh branch: trunk, size: 91273)
16:30
[2a1dc64d] part of check-in [6df7343b] Change the command-line shell to do the ".dump" inside of a SAVEPOINT rather than a transaction, since this allows it to be run from within a transaction. (check-in: [6df7343b] user: drh branch: trunk, size: 91270)
16:02
[faba48cc] part of check-in [eeeba4f0] Enable large-file support for fopen() and friends in the command-line shell. Ticket [92af7da36b6fbd] (check-in: [eeeba4f0] user: drh branch: trunk, size: 91217)
13:34
[2a448342] part of check-in [1c00d545] Do the ".dump" command inside of a transaction to prevent other processes from modifying the database while the dump is underway. Ticket [2466653295e65] (check-in: [1c00d545] user: drh branch: trunk, size: 90989)
00:41
[bef48bc4] part of check-in [8a8dcd6b] If errors are encountered while processing the ".dump" command in the command-line shell, print error messages as comments in the output and ROLLBACK at the end rather than committing. Ticket [ee19e690ec9a5a2] (check-in: [8a8dcd6b] user: drh branch: trunk, size: 90974)
2011-10-11
20:41
[a07ce148] part of check-in [b94a80a8] Put in code to defend against signed/unsigned character problems in the command-line shell. (check-in: [b94a80a8] user: drh branch: trunk, size: 90602)
2011-09-28
01:10
[e8fe1251] part of check-in [f4dd32d3] In the shell, allow arbitrary table names on the ".import" command. Ticket [d1d84037b90a449]. (check-in: [f4dd32d3] user: drh branch: trunk, size: 90490)
2011-09-23
18:58
[1d3baca3] part of check-in [d279e1a3] Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell. (check-in: [d279e1a3] user: drh branch: trunk, size: 90494)
2011-09-16
20:16
[13fe2aed] part of check-in [69022071] Silence harmless compiler warning about redefinition of the _CRT_SECURE_NO_WARNINGS macro by shell.c. (check-in: [69022071] user: mistachkin branch: trunk, size: 90150)
2011-07-08
17:02
[bbe7818f] part of check-in [e305b5a9] Change the default chunk size on test_multiplex.c to 2147418112 bytes (formerly 1073741824 bytes) and make the default configurable at compile-time using SQLITE_MULTIPLEX_CHUNK_SIZE and at run-time using the "chunksize" URI query parameter. Add support fo test_multiplex to the shell. (check-in: [e305b5a9] user: drh branch: trunk, size: 90111)
2011-06-03
13:28
[0e0173b3] part of check-in [049c3c42] Include more detailed version information in the command-line shell output. (check-in: [049c3c42] user: drh branch: trunk, size: 89695)
2011-05-18
17:15
[decd0423] part of check-in [de58cb28] Enable URI filenames in the command-line shell. Add a check to the beginning of the shell to make sure it is compiled with the same SQLite source and header. (check-in: [de58cb28] user: drh branch: trunk, size: 89503)
2011-04-11
15:36
[72e7e176] part of check-in [73906b67] Updates to the OS/2 patches. This change also move the location of a global variable declaration in shell.c which might effect other build targets. (check-in: [73906b67] user: drh branch: trunk, size: 89264)
2011-04-07
03:41
[9c838979] part of check-in [748c9109] Fix a couple of MSVC compiler warnings; (check-in: [748c9109] user: shaneh branch: trunk, size: 89328)
2011-04-05
22:08
[a73b3006] part of check-in [3eeb0ff7] Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. (check-in: [3eeb0ff7] user: drh branch: trunk, size: 89326)
2011-03-23
11:16
[9dc0b4bb] part of check-in [1ed5e361] In the shell, make sure the ".log" command has at least one argument. (check-in: [1ed5e361] user: drh branch: trunk, size: 89319)
2011-03-17
16:45
[4a5e0ad8] part of check-in [54bacb95] Update the implementation of ".testctrl" in the command-line shell to use a look-up table rather than a long sequence of if-elses. Shorten source code lines of shell.c to 80 characters or less. (check-in: [54bacb95] user: drh branch: trunk, size: 89319)
2011-03-16
17:05
[75ec746b] part of check-in [baca45c5] Add the -vfstrace option to the usage error message in the shell. (check-in: [baca45c5] user: drh branch: trunk, size: 89256)
16:56
[1378c13b] part of check-in [f49a9ef3] Add the VFS-trace shim. (check-in: [f49a9ef3] user: drh branch: trunk, size: 89160)
2011-03-15
18:35
[ea406582] part of check-in [72570846] Fix an out-of-order variable declaration in shell.c. (check-in: [72570846] user: drh branch: trunk, size: 88739)
2011-03-12
17:02
[54f8fe0a] part of check-in [00051c32] Add the new optional "unix-excl" VFS. This VFS grabs an exclusive lock on the database preventing other processes from accessing it, but continues to allow other database connections from the same process. (check-in: [00051c32] user: drh branch: unix-excl, size: 88748)
2011-02-10
21:08
[649c5197] part of check-in [f85afa0e] Add .testctrl option to CLI. (check-in: [f85afa0e] user: shaneh branch: trunk, size: 88326)
2010-12-21
21:28
[83c6f0cc] part of check-in [b0888047] Add test cases for the new lookaside hit and miss status outputs. Add the output of lookaside hit and miss to the command-line shell statistics. (check-in: [b0888047] user: drh branch: trunk, size: 83508)
2010-12-17
14:03
[9afa9bdd] part of check-in [74fff692] Add the "-heap" option to the command-line shell - to allocate a fixed heap for use with SQLITE_ENABLE_MEMSYS5. (check-in: [74fff692] user: drh branch: trunk, size: 83019)
2010-12-08
03:28
[ee5905fe] part of check-in [925332c3] The command-line shell ignore errors in sqlite3_close() when shutting down. (check-in: [925332c3] user: drh branch: trunk, size: 82352)
00:02
[7b429fc7] part of check-in [e474fd9e] Changes to the shell which should, in theory, allow it to work with libeditline as an alternative to libreadline. (check-in: [e474fd9e] user: drh branch: trunk, size: 82484)
2010-07-28
17:36
[8517fc1f] part of check-in [ae89777e] Improve the accuracy of the Pager heap usage estimate. (check-in: [ae89777e] user: drh branch: trunk, size: 82346)
17:01
[cc1a4d20] part of check-in [f9adf66a] Record the pcache allocation size statistics even for pcache overflow allocations. Adjust the wording on one of the stat output lines in the shell. (check-in: [f9adf66a] user: drh branch: trunk, size: 82346)
16:05
[74c82a4e] part of check-in [419ce0ed] Modify CLI to optionally display "stats". (check-in: [419ce0ed] user: shaneh branch: trunk, size: 82346)
2010-05-06
20:19
[fd4ccdb3] part of check-in [c1762dda] Make sure to do a clean shutdown of the library upon existing the shell in order to remove WAL files. (check-in: [c1762dda] user: drh branch: trunk, size: 78117)
2010-03-03
14:23
[c40427c7] part of check-in [00e56790] Modify the command line tool to disable all mutexes. The command line tool is single-threaded. (check-in: [00e56790] user: dan branch: trunk, size: 78110)
2010-02-25
02:32
[546fe4b6] part of check-in [46f406b2] Merge in all of the logging enhancements. This is a cherrypick merge of the following check-ins: [103321e37a], [a8076aede3], [6d910245ad], [7c4cca6d1a], [edea3bb740], [1a6d4bb130], [a8c984c1d6], [69a493182f], and [1168763d2c]. (check-in: [46f406b2] user: drh branch: branch-3.6.22, size: 108335)
2010-02-23
01:47
[31cd5551] part of check-in [6d910245] Add the ".log" command to the shell. This shows that some errors are logged multiple times and other errors are never logged at all. (check-in: [6d910245] user: drh branch: trunk, size: 78064)
01:01
[285a9a83] part of check-in [c4401fc9] Remove the ".genfkey" command from the shell. We've had foreign-key support in the core since 3.6.19. Anyone who still needs the simulated foreign-key triggers can always generate them with an older version of the shell. (check-in: [c4401fc9] user: drh branch: trunk, size: 77059)
2010-02-15
15:47
[56521a17] part of check-in [c727601e] Fix a compiler warning in shell.c. Updates to comments in trigger.c. (check-in: [c727601e] user: drh branch: trunk, size: 107433)
2010-01-18
18:17
[d7408dbe] part of check-in [7080ae3b] Fix a problem with the CLI where not all SQL commands were being echoed. Added tests of same to tools/shell2.test. Ticket [eb620916be]. (check-in: [7080ae3b] user: shaneh branch: trunk, size: 107429)
2010-01-05
04:59
[b95c5fcf] part of check-in [e5d07045] Fix a problem in the shell tool. In some cases sqlite3_errmsg() was being called before sqlite3_finalize(), causing error messages to be more generic than they should be. (check-in: [e5d07045] user: dan branch: trunk, size: 107330)
2009-12-17
21:07
[b9fae60b] part of check-in [b1b48be1] In shell.c (CLI), modified local_getline() to remove '\r' as well as '\n' from end of lines. This provides consistency between MSVC and CYGWIN builds. (check-in: [b1b48be1] user: shaneh branch: trunk, size: 107568)
2009-11-11
04:17
[f4948cb6] part of check-in [09b4f19f] Modified CLI to raise an error when extra command line options are passed. Added tests to verify correct handling, as well as other basic handling of command line options. Ticket [f5cb008a65]. (check-in: [09b4f19f] user: shaneh branch: trunk, size: 107527)
2009-11-10
17:07
[360ed53f] part of check-in [8097c64a] Fix for datbase name being ignored with the -batch option in the CLI. Ticket [aeff892c57]. (check-in: [8097c64a] user: shaneh branch: trunk, size: 106932)
01:30
[0167e247] part of check-in [f6c045f6] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f6] user: drh branch: trunk, size: 106943)
2009-11-06
17:20
[07e6265e] part of check-in [9fb69919] Improved shell "dot" command argument handling. Ticket [f12a9eeedc]. (check-in: [9fb69919] user: shaneh branch: trunk, size: 107000)
2009-10-24
02:06
[f66531a5] part of check-in [e3898e25] In shell, modified to not print informational messages during startup while in "batch mode". Ticket [2cb66577f6]. (check-in: [e3898e25] user: shane branch: trunk, size: 106388)
02:00
[0e43ac51] part of check-in [7201244e] In shell, changed ".tables" command to not add '%' to specified pattern. This is consistent with other commands that take a LIKE pattern (.dump, .schema, .indices). Updated internal help to better describe LIKE pattern usage. Fixed a few more inconsistencies in error messages. Ticket [6da68f691b]. (check-in: [7201244e] user: shane branch: trunk, size: 106085)
2009-10-23
01:27
[19c86a22] part of check-in [1ebac9ed] In shell, ensure that do_meta_command() returns consistent error values. Adjusted the text of some error message to be more consistent. Ticket [beb2dd69ad]. (check-in: [1ebac9ed] user: shane branch: trunk, size: 104917)
00:37
[4b1d54c6] part of check-in [009efad0] In shell, modified "import" handling to ensure error code returned correctly on exit. Ticket [bd770b2c52]. (check-in: [009efad0] user: shane branch: trunk, size: 104412)
2009-10-22
21:23
[3a2b0649] part of check-in [790402c1] In shell, reworked .header and .echo handling. Updated shell_exec() to (really) handle multiple statements. Tickets [72adc99de9], [7b61b6c6ce], and [eb620916be]. (check-in: [790402c1] user: shane branch: trunk, size: 104017)
18:12
[5d875ff5] part of check-in [ab99faca] In shell, in shell_exec() logic, use type info if available when outputting in "insert" mode for other types in addition to blobs. Changed shell_exec() to use sqlite_prepare_v2(). Ticket [72adc99de9] and [7b61b6c6ce]. (check-in: [ab99faca] user: shane branch: trunk, size: 103269)
17:30
[47dc8e71] part of check-in [a2ad9e63] Updated shell to output blobs in X'1234' form when in "insert" mode. Ticket [72adc99de9]. (check-in: [a2ad9e63] user: shane branch: trunk, size: 102936)
2009-10-21
14:11
[9a9fab0d] part of check-in [c8815fcd] Modified shell to call output_html_string() for header values in .mode html. Updated output_html_string() to support the 5 basic HTML entities (<,>,&,',"). Ticket [dc3a6e5b31]. (check-in: [c8815fcd] user: shane branch: trunk, size: 97975)
13:53
[9b242f44] part of check-in [c6f22f3e] Made detectSchemaProblem function and aSchemaTable array static. Ticket [6f8b0c5855]. (check-in: [c6f22f3e] user: shane branch: trunk, size: 97623)
03:56
[98ce80c6] part of check-in [8a8eeb0c] For the shell, changed the output of the errors on lines 2910 and 2914 to goto stderr. I left the timer values going to stdout as all of the other interactive shell commands (startup banner, help, etc.) go to stdout and I felt this was more consistent. Ticket [43db771bb2]. (check-in: [8a8eeb0c] user: shane branch: trunk, size: 97609)
03:42
[40364dae] part of check-in [83216fbe] For Windows version of shell, add support for .timer command using the GetProcessTimes() API if available (in the same way getrusage() is used on UNIX.) Ticket [89668ca167]. (check-in: [83216fbe] user: shane branch: trunk, size: 97591)
2009-10-08
13:42
[270231b3] part of check-in [273ccbf1] Fix a problem in the legacy genfkey code to do with column names that require quoting. (check-in: [273ccbf1] user: dan branch: trunk, size: 95325)
2009-09-23
15:51
[d6e64471] part of check-in [0755b9b6] Modify the ".dump" command on the CLI so that it always issues a PRAGMA foreign_keys=OFF at the top of the output. (check-in: [0755b9b6] user: drh branch: trunk, size: 95301)
2009-09-19
17:00
[d0171721] part of check-in [d5d39981] Check in implementation of foreign key constraints. (check-in: [d5d39981] user: dan branch: trunk, size: 95031)
2009-05-31
17:16
[db264365] part of check-in [a028d69c] Fix the ".genfkey" command of the CLI so that it does not leak memory if sqlite3_realloc() fails. Ticket #3891. (CVS 6696) (check-in: [a028d69c] user: drh branch: trunk, size: 95032)
2009-05-21
15:15
[7eacd0bd] part of check-in [bedd5ad1] In the CLI in the ".dump" command, do not attempt to clear the sqlite_sequence table until the first row of content of that table is seen. Ticket #3867 (CVS 6664) (check-in: [bedd5ad1] user: drh branch: trunk, size: 94891)
14:51
[7d20ab57] part of check-in [a0028d48] In the CLI, always "dump" the sqlite_sequence table last. Ticket #3867 (CVS 6663) (check-in: [a0028d48] user: drh branch: trunk, size: 94557)
2009-03-16
10:59
[0a11f831] part of check-in [324a1aff] Remove surplus white space from shell.c. Use strlen30() instead of strlen(). (CVS 6346) (check-in: [324a1aff] user: drh branch: trunk, size: 94392)
2009-03-13
15:32
[de2fef6f] part of check-in [943b11fb] Do not overrun a buffer in the genfkey code (now part of shell.c). Fix for #3722. (CVS 6344) (check-in: [943b11fb] user: danielk1977 branch: trunk, size: 94404)
2009-03-05
03:48
[0e2ebb9f] part of check-in [5477833e] Removed compiler warnings from MSVC builds. Ticket #3701. (CVS 6335) (check-in: [5477833e] user: shane branch: trunk, size: 94357)
2009-02-25
19:07
[0cada720] part of check-in [48ee0e47] Move the new genfkey shell command out from within #ifdef _WIN32_ (CVS 6327) (check-in: [48ee0e47] user: drh branch: trunk, size: 94002)
15:43
[6ffbdb81] part of check-in [36d69966] Remove genfkey.c. Change genfkey.README to talk about the new shell dot-command, not the old standalone genfkey program. (CVS 6326) (check-in: [36d69966] user: danielk1977 branch: trunk, size: 94010)
15:22
[95ca116d] part of check-in [0a59fb28] Add the 'genfkey' functionality to the sqlite3 shell. Accessed using a new dot-command - ".genfkey". (CVS 6325) (check-in: [0a59fb28] user: danielk1977 branch: trunk, size: 93941)
2009-02-04
22:46
[f109ebbb] part of check-in [e420a3ce] Add "backup" and "restore" methods to the TCL interfaces and test cases to exercise those methods. (CVS 6260) (check-in: [e420a3ce] user: drh branch: trunk, size: 64196)
20:55
[6c674a4a] part of check-in [003e1d62] Add ".backup" and ".restore" commands to the CLI - implemented using the new backup API. (CVS 6259) (check-in: [003e1d62] user: drh branch: trunk, size: 63989)
2009-01-30
05:40
[8965cf0c] part of check-in [c74c78e4] Minor changes to remove a few MSVC compiler warnings at /W3. Ticket #3610. (CVS 6215) (check-in: [c74c78e4] user: shane branch: trunk, size: 61852)
2009-01-14
23:38
[0d801ef6] part of check-in [7bc08bc7] Make some changes requested by Fedora. (CVS 6181) (check-in: [7bc08bc7] user: drh branch: trunk, size: 61824)
23:17
[fe2e3d4a] part of check-in [6f6b638e] Fix the shell so that the ".schema" command works regardless of the pragma settings. Ticket #3585. (CVS 6180) (check-in: [6f6b638e] user: drh branch: trunk, size: 61819)
2008-12-18
22:25
[65d19f89] part of check-in [dcc8935f] Fix the Oracle and MS-Sql command-line terminator logic in the CLI. Ticket #3544. (CVS 6041) (check-in: [dcc8935f] user: drh branch: trunk, size: 61644)
2008-12-11
02:58
[60638e2f] part of check-in [72fd92bd] Removed a few more harmless warnings from MSVC. (CVS 6018) (check-in: [72fd92bd] user: shane branch: trunk, size: 61307)
2008-12-10
22:30
[25576287] part of check-in [715dcd52] Work to remove harmless MSVC compiler warnings. (CVS 6013) (check-in: [715dcd52] user: shane branch: trunk, size: 61288)
22:15
[4b9c41be] part of check-in [258722b6] Fix an issue with the new sqlite3Strlen30() introduced by check-in (6007). Additional casts for compiler warnings. (CVS 6011) (check-in: [258722b6] user: drh branch: trunk, size: 61079)
19:26
[793aaebd] part of check-in [c872d554] Never use strlen(). Use our own internal sqlite3Strlen30() which is guaranteed to never overflow an integer. Additional explicit casts to avoid nuisance warning messages. (CVS 6007) (check-in: [c872d554] user: drh branch: trunk, size: 61240)
2008-12-08
18:27
[484bddee] part of check-in [6c0b2e75] Fix a bug in win32 command-line client introduced during efforts to reduce the number of harmless compiler warnings (check-in (5982).) (CVS 5992) (check-in: [6c0b2e75] user: drh branch: trunk, size: 60767)
2008-12-05
17:17
[be9eeb58] part of check-in [adedd697] Fix harmless compiler warnings. Improved comments in the query optimizer. (CVS 5982) (check-in: [adedd697] user: drh branch: trunk, size: 60769)
2008-12-04
12:26
[838c745e] part of check-in [cb9c1543] Fix a memory leak in the shell that occurs when a ".import" command fails. Ticket #3517 (CVS 5975) (check-in: [cb9c1543] user: drh branch: trunk, size: 60574)
2008-11-17
08:05
[650d1a87] part of check-in [f45a1493] Added support for vxworks >= 6.4; RTP mode tested, kernel mode untested. (CVS 5910) (check-in: [f45a1493] user: chw branch: trunk, size: 60553)
2008-11-11
18:55
[01835f43] part of check-in [dacae200] Send the "Incomplete SQL" error message of the CLI to stderr instead of stdout. Ticket #3476. (CVS 5885) (check-in: [dacae200] user: drh branch: trunk, size: 60350)
00:30
[33ae5c8c] part of check-in [68662e3b] Fix the CLI so that it does not terminate input when an Oracle or MS-SQL command terminator mark is seen in the middle of a string literal. Ticket #3490. (CVS 5878) (check-in: [68662e3b] user: drh branch: trunk, size: 60341)
2008-08-11
19:12
[d83b578a] part of check-in [860babd8] Make the CLI more tolerant of malformed schemas by setting the writable_schema pragma prior to running the ".dump" command. (CVS 5554) (check-in: [860babd8] user: drh branch: trunk, size: 60315)
2008-07-11
17:23
[4b835fe7] part of check-in [1041deb6] Tweak to the ".timer" command in the CLI to help it work better with GCC. (CVS 5398) (check-in: [1041deb6] user: drh branch: trunk, size: 60188)
2008-06-28
11:29
[484e7297] part of check-in [0ab0b030] Added reminder message to terminate SQL statements with a semicolon on shell startup. This closes #3099. (CVS 5325) (check-in: [0ab0b030] user: mihailim branch: trunk, size: 60204)
2008-06-26
10:41
[479807b8] part of check-in [cdd4cf4c] Change the OS_XXX pre-processor symbols to SQLITE_OS_XXX. Symbols "OS_UNIX", "OS_WIN", "OS_WINCE", "OS_OS2" and "OS_OTHER" are now "SQLITE_OS_UNIX", "SQLITE_OS_WIN", "SQLITE_OS_WINCE", "SQLITE_OS_OS2" and "SQLITE_OS_OTHER", respectively. (CVS 5311) (check-in: [cdd4cf4c] user: danielk1977 branch: trunk, size: 60150)
2008-06-23
21:26
[61fa6193] part of check-in [bf2e283d] Reverted previous checkin (on second thought, changing case could break badly written homegrown parsers such as sometimes encountered in embedded firmware.) (CVS 5289) (check-in: [bf2e283d] user: mihailim branch: trunk, size: 60133)
21:18
[3f3c184e] part of check-in [e07ed82c] Changed HTML mode output to use lowercase tags making good on the XHTML output promise (the DTDs indeed mandate lowercase) and closing #450. (CVS 5288) (check-in: [e07ed82c] user: mihailim branch: trunk, size: 60133)
2008-05-19
15:53
[a12ea645] part of check-in [70793be6] In the CLI, handle the compilation option -DOS_OS2=0 correctly. (CVS 5141) (check-in: [70793be6] user: drh branch: trunk, size: 60128)
2008-05-05
16:27
[668ad976] part of check-in [0bec7ebf] Do not segfault in the CLI if sqlite3_open() fails to create a database connection object. Ticket #3096. (CVS 5084) (check-in: [0bec7ebf] user: drh branch: trunk, size: 60112)
2008-04-15
18:50
[be22ec05] part of check-in [cafa8ac2] Support UTF-8 filenames on OS/2 by converting them to and from the local codepage. Ticket 3052. (CVS 5014) (check-in: [cafa8ac2] user: pweilbacher branch: trunk, size: 60053)
2008-03-04
17:45
[22297fff] part of check-in [9c6694bb] Various renames & cleanups to limit exported symbols on amalgamation build (CVS 4819) (check-in: [9c6694bb] user: mlcreech branch: trunk, size: 59952)
2008-02-15
17:38
[c1ef4eb7] part of check-in [dedf5f23] Fix a bug in the ".show" command of the CLI. Ticket #2942. (CVS 4792) (check-in: [dedf5f23] user: drh branch: trunk, size: 59957)
2008-01-21
16:22
[ca06cb68] part of check-in [720bc20a] Miscellaneous test coverage improvements. (CVS 4734) (check-in: [720bc20a] user: drh branch: trunk, size: 60026)
2008-01-14
15:20
[0691a3d5] part of check-in [187f41f5] Fix for ticket #2883. (CVS 4711) (check-in: [187f41f5] user: drh branch: trunk, size: 60025)
2008-01-03
07:09
[5391e889] part of check-in [b166c33a] Fix EXPLAIN and EXPLAIN query plan to work with new opcode format. (CVS 4662) (check-in: [b166c33a] user: danielk1977 branch: trunk, size: 60027)
2007-12-18
15:41
[77895a54] part of check-in [493a17c4] In the CLI, quote strings that contain the separator character. Ticket #2850. (CVS 4638) (check-in: [493a17c4] user: drh branch: trunk, size: 59517)
2007-11-26
22:54
[c97be281] part of check-in [d0a4c2a3] Use macro __DARWIN__ rather than __MACOS__ for conditional compilation of MacOSX specific features. Ticket #2780. (CVS 4561) (check-in: [d0a4c2a3] user: drh branch: trunk, size: 59380)
2007-11-12
21:09
[5b950381] part of check-in [8ad0ab8c] Various changes to enable compilation of SQLite library and command line shell with the Windows CE cross compiler from cegcc.sourceforge.net (CVS 4541) (check-in: [8ad0ab8c] user: chw branch: trunk, size: 59728)
2007-11-02
12:53
[0b9dd90a] part of check-in [56680360] Add the ".timer" command to the CLI. (CVS 4522) (check-in: [56680360] user: drh branch: trunk, size: 59313)
2007-09-07
01:12
[82089379] part of check-in [f780a17f] Modify the CLI so that it will ignore whitespace at the end of lines. Ticket #2631 (CVS 4412) (check-in: [f780a17f] user: drh branch: trunk, size: 57941)
2007-07-30
20:41
[ac29402b] part of check-in [49a2e855] Make excess output from the CLI appear inside SQL comments so as not to interfere with generated SQL. Ticket #2544. (CVS 4192) (check-in: [49a2e855] user: drh branch: trunk, size: 57890)
18:24
[d9e727be] part of check-in [271e27fd] Get rid of the following compile-time warning: "src/shell.c:112: warning: 'iotracePrintf' defined but not used" (CVS 4188) (check-in: [271e27fd] user: rse branch: trunk, size: 57887)
2007-07-03
05:31
[e7534cce] part of check-in [a008905b] Fix a memory leak in shell.c. Reported on the mailing list. This has only been informally tested. (CVS 4153) (check-in: [a008905b] user: danielk1977 branch: trunk, size: 57823)
2007-06-20
13:10
[4b0fc3c7] part of check-in [6eaf29f5] Fix a bug in the command-line shell that prevents the reading of the ".sqliterc" file. Ticket #2433. (CVS 4100) (check-in: [6eaf29f5] user: drh branch: trunk, size: 57815)
2007-05-04
13:15
[d07ae326] part of check-in [ba4845b3] Eliminate all uses of sprintf() and strcpy(). These were not being misused. But getting rid of them removes a library dependency. And it avoids warnings from the OpenBSD compiler. Ticket #2336. (CVS 3916) (check-in: [ba4845b3] user: drh branch: trunk, size: 57792)
2007-05-03
17:18
[762c8165] part of check-in [8a43e167] Improvements to I/O tracing output. Require -DSQLITE_ENABLE_IOTRACE when compiling shell.c in order to link in the I/O tracing capability. (CVS 3909) (check-in: [8a43e167] user: drh branch: trunk, size: 57172)
2007-02-28
06:14
[3ae46545] part of check-in [ceb3a07f] Work around incompatibilities in the windows printf() routine within the new I/O tracing logic. (CVS 3666) (check-in: [ceb3a07f] user: drh branch: trunk, size: 57033)
04:47
[a7df003f] part of check-in [007ca283] Add the undocumented and experimental I/O tracing interface. This interface is likely to change and may be completely abandoned in the near future. (CVS 3665) (check-in: [007ca283] user: drh branch: trunk, size: 56971)
2007-01-08
14:31
[d13ca007] part of check-in [3a422bb9] Updates to the sqlite3 command-line shell documentation. Ticket #2144. (CVS 3573) (check-in: [3a422bb9] user: drh branch: trunk, size: 55899)
2006-12-19
18:47
[f270a799] part of check-in [6f8a5623] Fix a typo in shell.c. Ticket #2111. (CVS 3533) (check-in: [6f8a5623] user: drh branch: trunk, size: 55828)
2006-11-20
16:21
[934cdcf6] part of check-in [9fdc2496] Fix the ".dump" command in the shell. Ticket #2072. Also ticket #2065. (CVS 3515) (check-in: [9fdc2496] user: drh branch: trunk, size: 55827)
2006-11-08
12:25
[41513f31] part of check-in [f39978ef] Make the .exit and .quit commands work again in the shell. Ticket #2056. (CVS 3505) (check-in: [f39978ef] user: drh branch: trunk, size: 55357)
2006-10-31
18:08
[e5bda308] part of check-in [ebd44f0b] Make the command-line shell ".dump" command more resilient in the face of database corruption. (CVS 3496) (check-in: [ebd44f0b] user: drh branch: trunk, size: 55237)
2006-10-27
14:21
[3cd7e846] part of check-in [58171a41] Fix the ".dump" command in the command-line shell so that it shows TRIGGERs and VIEWs. Ticket #2044. (CVS 3493) (check-in: [58171a41] user: drh branch: trunk, size: 55284)
2006-10-26
18:15
[718c9dc5] part of check-in [517712d6] Bring CVS output into more commonly accepted practice. Tickets #2030, #1573. Add command-line options -bail and ".bail" commands. Default behavior is to continue after encountering an error. Ticket #2045. (CVS 3491) (check-in: [517712d6] user: drh branch: trunk, size: 55318)
14:25
[73cbdcb3] part of check-in [3baa04cf] Command-line shell enhancements. Bail out when errors are seen in non-interactive mode. Override isatty() using -interactive or -batch command-line options. Report line number in error messages. Tickets #2009, #2045. (CVS 3490) (check-in: [3baa04cf] user: drh branch: trunk, size: 53264)
2006-09-25
13:09
[1c17cd03] part of check-in [815d8f84] Remove legacy cruft from shell.c. (CVS 3439) (check-in: [815d8f84] user: drh branch: trunk, size: 53074)
2006-09-13
20:22
[672326e8] part of check-in [afd40184] Modify the ".dump" command in the command-line shell so that it works with virtual tables. (CVS 3416) (check-in: [afd40184] user: drh branch: trunk, size: 53251)
2006-09-06
21:39
[233f7766] part of check-in [b3eb1732] Include io.h on Windows to quell a build warning about access() having no prototype. (CVS 3394) (check-in: [b3eb1732] user: adamd branch: trunk, size: 52842)
2006-08-29
12:04
[3496a1b0] part of check-in [9763b4bf] Improved built-in help in the command-line shell. Enable the fulltext search extension in the TCL interface. (CVS 3372) (check-in: [9763b4bf] user: drh branch: trunk, size: 52772)
2006-08-19
11:15
[bc41feff] part of check-in [10907bb2] Improved method for finding the home directory under windows. Ticket #1926. (CVS 3357) (check-in: [10907bb2] user: drh branch: trunk, size: 52674)
2006-07-28
20:16
[9e95f12e] part of check-in [47353f62] Report any error which occurs in closing the database at exit. Free a couple of strings which were leaking. (CVS 3340) (check-in: [47353f62] user: adamd branch: trunk, size: 52297)
2006-06-27
20:39
[359551ab] part of check-in [9f13972b] Better handling of NULL column names. (CVS 3317) (check-in: [9f13972b] user: drh branch: trunk, size: 52146)
15:16
[48d8e657] part of check-in [4692319c] The ability to load extensions is turned off by default. It must be enabled by calling sqlite3_enable_load_extension() before it will work. This prevents security problems in legacy applications. Ticket #1863. (CVS 3311) (check-in: [4692319c] user: drh branch: trunk, size: 52099)
2006-06-13
15:12
[ad73192b] part of check-in [0bcec959] Improved comments and documentation of sqlite3_load_extension(). (CVS 3229) (check-in: [0bcec959] user: drh branch: trunk, size: 52012)
2006-06-12
12:57
[55bf6335] part of check-in [65c6e5e1] Patches to get things working better for OS2. Ticket #1836. (CVS 3217) (check-in: [65c6e5e1] user: drh branch: trunk, size: 51928)
2006-06-08
16:10
[b9eb3ed4] part of check-in [39e34278] In the shell, make sure the database is opened before trying to do an ".import". Bug reported on the mailing list. (CVS 3209) (check-in: [39e34278] user: drh branch: trunk, size: 51822)
15:28
[4f1e4a4d] part of check-in [4ca932d3] New shell command ".load" and the sqlite3_load_extension() API allow new SQL functions and collating sequences to be loaded at run-time from a DLL or shared library. (CVS 3207) (check-in: [4ca932d3] user: drh branch: trunk, size: 51806)
2006-06-06
12:32
[087d388b] part of check-in [fd0fae48] Command "sqlite3 -version" returns 0 instead of 1. Ticket #1771. (CVS 3204) (check-in: [fd0fae48] user: drh branch: trunk, size: 51376)
2006-06-03
17:37
[894d780d] part of check-in [0eabda82] Do not record blank lines in the command-line editing history of the shell. (CVS 3197) (check-in: [0eabda82] user: drh branch: trunk, size: 51376)
2006-05-10
14:39
[1862fab6] part of check-in [364031d6] Out-of-memory checks added to tclsqlite.c and shell.c. Tickets #1805 and #1806. (CVS 3182) (check-in: [364031d6] user: drh branch: trunk, size: 51364)
2006-03-19
13:00
[5cce3dab] part of check-in [8ae6ccc7] Increase test coverage to above 98%. (CVS 3144) (check-in: [8ae6ccc7] user: drh branch: trunk, size: 51266)
2006-03-06
20:55
[7a4b16f8] part of check-in [e510e6dd] Code changes resulting from Coverity analysis. http://scan.coverity.com/ Found 1 potential segfault in sqlite3_mprintf(). Also 2 failures to fclose() following a malloc() failure. And lots of cases where unnecessary conditionals could be removed from the code. (CVS 3126) (check-in: [e510e6dd] user: drh branch: trunk, size: 51260)
2006-01-31
19:31
[738f55ed] part of check-in [b922c8e4] Fix some pointless warnings from overly-pedantic compilers. (CVS 3048) (check-in: [b922c8e4] user: drh branch: trunk, size: 51164)
19:07
[fc75e0c9] part of check-in [1e68ac59] 3rd parameter to sqlite3_prepare() should be -1 if the string length is unknown. Passing in zero causes a zero-length SQL statement to be prepared, which is a no-op. Ticket #1651. This bug introduced by the fix for ticket #1650. (CVS 3047) (check-in: [1e68ac59] user: drh branch: trunk, size: 51144)
2006-01-25
15:55
[ea0e4654] part of check-in [e4e6a205] Rename files using for testing only so that their name begins with "test". (CVS 3028) (check-in: [e4e6a205] user: drh branch: trunk, size: 51142)
2005-12-29
12:53
[66b07337] part of check-in [1586921b] Fix for ticket #1575. (CVS 2844) (check-in: [1586921b] user: drh branch: trunk, size: 51917)
2005-12-09
14:25
[4872acee] part of check-in [601c3354] Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) (check-in: [601c3354] user: danielk1977 branch: trunk, size: 51925)
2005-09-11
02:03
[3596c1e5] part of check-in [3f191cf4] The ".dump" command from the shell correctly saves the state of the sqlite_sequence and sqlite_stat1 tables, if they exist. Ticket #1419. (CVS 2687) (check-in: [3f191cf4] user: drh branch: trunk, size: 51879)
2005-09-10
22:40
[bf574fc9] part of check-in [26565b89] The shell does not output the sqlite_stat1 table on .dump or .schema. The ANALYZE command now gathers statistics on tables that have only a single index because this sometimes helps when reordering tables in a join. (CVS 2686) (check-in: [26565b89] user: drh branch: trunk, size: 51787)
2005-08-30
20:12
[b21daba0] part of check-in [528df777] The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) (check-in: [528df777] user: drh branch: trunk, size: 51662)
2005-08-29
23:06
[d2d4ef04] part of check-in [71a71cef] Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) (check-in: [71a71cef] user: drh branch: trunk, size: 51657)
2005-08-27
01:50
[7fb744da] part of check-in [dd3b00aa] Widen the opcode column of explain output in the shell. (CVS 2625) (check-in: [dd3b00aa] user: drh branch: trunk, size: 51506)
2005-08-05
18:50
[86c16f0d] part of check-in [73fafd21] Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) (check-in: [73fafd21] user: drh branch: trunk, size: 51506)
2005-02-23
12:35
[25b3217d] part of check-in [4ae1a9fc] Remove strcasecmp from shell.c. Tickets #1108, #1122. (CVS 2359) (check-in: [4ae1a9fc] user: drh branch: trunk, size: 51492)
2005-02-16
03:53
[46a1757c] part of check-in [b82c06fd] The ".dump" method in the shell for version 2 should not sort tables by name because this can put views out of dependency order. Ticket #1124. (CVS 2347) (check-in: [b82c06fd] user: drh branch: version_2, size: 38711)
2005-02-03
00:42
[3cb0ef12] part of check-in [76c4a96c] Fix the ".dump" command in the shell so that it works with AUTOVACUUM. This is related to ticket #1095. (CVS 2310) (check-in: [76c4a96c] user: drh branch: trunk, size: 51496)
2005-01-23
23:43
[1f0da77e] part of check-in [0778383b] Modification to shell.c to avoid a compiler warning on some compilers. (CVS 2268) (check-in: [0778383b] user: danielk1977 branch: trunk, size: 51385)
2005-01-13
11:10
[591364a0] part of check-in [2c7a1a16] Fix typo in shell .help. Ticket #1071. (CVS 2206) (check-in: [2c7a1a16] user: danielk1977 branch: trunk, size: 51256)
2004-11-22
05:26
[e8f4f486] part of check-in [9df837c0] Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) (check-in: [9df837c0] user: danielk1977 branch: trunk, size: 51255)
2004-10-26
00:08
[55adda3c] part of check-in [507d8e6f] Fix a bug in the ".databases" command of the command-line shell. Ticket #973 (CVS 2030) (check-in: [507d8e6f] user: drh branch: trunk, size: 51179)
2004-10-07
00:32
[2012beee] part of check-in [1376a0bb] In the command-line shell in CSV move, put strings in C-style double-quotes. Ticket #911. (CVS 2009) (check-in: [1376a0bb] user: drh branch: trunk, size: 51161)
2004-10-06
14:39
[bfd23e72] part of check-in [dcbf4817] Fix the ".import" command of the command-line shell so that it ignores \n and \r at the end of a line. Ticket #939. (CVS 2003) (check-in: [dcbf4817] user: drh branch: trunk, size: 50222)
2004-09-24
12:50
[0856973c] part of check-in [1ee3a787] Fix typo in ".help" output from the shell. Ticket #914. (CVS 1978) (check-in: [1ee3a787] user: drh branch: trunk, size: 50198)
2004-08-31
23:41
[4f1a2760] part of check-in [68a712f3] Changes to support compiling under windows. (CVS 1925) (check-in: [68a712f3] user: drh branch: trunk, size: 50198)
2004-08-30
01:54
[64932b37] part of check-in [d3f3acb7] Modify the sqlite shell program so that the ".dump" command does not give up if it encounters an SQLITE_CORRUPT error. It tries to keep going in order to extract as much information as it can from the corrupt database. (CVS 1919) (check-in: [d3f3acb7] user: drh branch: trunk, size: 49822)
2004-08-14
18:18
[42f65424] part of check-in [6b8178de] The command-line shell should avoid writing changes into string constants. (CVS 1886) (check-in: [6b8178de] user: drh branch: trunk, size: 48509)
2004-08-08
20:22
[69d8036a] part of check-in [b0659738] Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) (check-in: [b0659738] user: drh branch: trunk, size: 48478)
2004-08-04
15:16
[4b40fac1] part of check-in [ed489f77] In the command-line shell: importments to the "help" message and better error checking in the new .import command. (CVS 1877) (check-in: [ed489f77] user: drh branch: trunk, size: 48371)
2004-08-01
00:10
[7371f0a4] part of check-in [b56afe64] Add the ".import" command to the command-line shell. (CVS 1873) (check-in: [b56afe64] user: drh branch: trunk, size: 47699)
2004-07-22
02:40
[93c96c84] part of check-in [b77bec35] Changes in support of using a codec. (CVS 1844) (check-in: [b77bec35] user: drh branch: trunk, size: 42237)
2004-06-30
08:20
[ebec5da5] part of check-in [fa19c77b] Fixes for compiler warnings. Also more coverage. (CVS 1775) (check-in: [fa19c77b] user: danielk1977 branch: trunk, size: 42375)
2004-06-19
09:08
[24b64170] part of check-in [c49d8bdc] Make sure ATTACH and DETACH fail if a transaction is active. (CVS 1633) (check-in: [c49d8bdc] user: danielk1977 branch: trunk, size: 41407)
2004-06-08
00:39
[ca519519] part of check-in [97aa54bb] Enhance the built-in function quote() to support blob values. (CVS 1541) (check-in: [97aa54bb] user: danielk1977 branch: trunk, size: 41405)
00:02
[a70b41be] part of check-in [62e31f39] Remove the third argument from the sqlite3_open() API. (CVS 1540) (check-in: [62e31f39] user: danielk1977 branch: trunk, size: 43587)
2004-06-05
08:04
[79af86d3] part of check-in [e82eb722] Ensure blob values survive the ".dump" command of the shell. (CVS 1531) (check-in: [e82eb722] user: danielk1977 branch: trunk, size: 43590)
2004-05-31
23:56
[a9e2ad8f] part of check-in [af8e2006] Remove the sqlite3_error_string() API. (CVS 1514) (check-in: [af8e2006] user: danielk1977 branch: trunk, size: 38711)
19:34
[cca77450] part of check-in [f3b80bbb] Change the name of the sqlite3_freemem API function to just sqlite3_free. (CVS 1512) (check-in: [f3b80bbb] user: drh branch: trunk, size: 38710)
18:23
[b71bdc35] part of check-in [4c37b6d2] Change the name of the include file to "sqlite3.h". The names of the shell command and static library become "sqlite3" and "libsqlite3.a". (CVS 1510) (check-in: [4c37b6d2] user: drh branch: trunk, size: 38730)
2004-05-24
07:04
[ed4d237b] part of check-in [b7155db2] Have the vdbe handle strings in the same encoding as the database. (CVS 1445) (check-in: [b7155db2] user: danielk1977 branch: trunk, size: 38740)
2004-05-22
09:21
[657623c2] part of check-in [b4492173] Use the new form of the sqlite3_open() API everywhere. (CVS 1437) (check-in: [b4492173] user: danielk1977 branch: trunk, size: 38722)
2004-05-14
11:00
[0c4662e1] part of check-in [dbfe6e93] Implement type affinity for table and index records (CVS 1375) (check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 38764)
2004-05-10
10:34
[255b8b90] part of check-in [2242423e] Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338) (check-in: [2242423e] user: danielk1977 branch: trunk, size: 38755)
2004-05-08
08:23
[9a242ad0] part of check-in [8af6474c] Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) (check-in: [8af6474c] user: danielk1977 branch: trunk, size: 38725)
2004-03-17
23:42
[920af040] part of check-in [85238f06] Change the ".database" command in the shell to allocate more characters to the database name and filename. (CVS 1300) (check-in: [85238f06] user: drh branch: trunk, size: 38705)
2004-03-09
13:37
[01fdfff6] part of check-in [b6817e99] The shell program now ignores extra whitespace at the end of dot-commands. (CVS 1288) (check-in: [b6817e99] user: drh branch: trunk, size: 38625)
2004-02-25
02:25
[b19e750f] part of check-in [114b72f8] Shell program saves command-line history on a ".quit". Ticket #614. (CVS 1270) (check-in: [114b72f8] user: drh branch: trunk, size: 38596)
2004-02-14
16:31
[c3d3404f] part of check-in [9771ad1e] The sqlite_exec() function is now implemented using sqlite_compile() and sqlite_step(). This opens up lots of opportunity to remove old code. (CVS 1240) (check-in: [9771ad1e] user: drh branch: trunk, size: 38634)
2004-02-13
20:09
[60b33fe4] part of check-in [5a56090d] Fix an uninitialized variable in shell.c that would cause a crash if you specified SQL on the command-line. (CVS 1238) (check-in: [5a56090d] user: drh branch: trunk, size: 38631)
2004-02-12
20:49
[f6975f87] part of check-in [5fe8f023] Add a new parameter to the (unimplemented) encryption API. (CVS 1234) (check-in: [5fe8f023] user: drh branch: trunk, size: 38616)
2004-02-11
10:37
[c1c7242e] part of check-in [95989717] Fix the shells so that they always enable the codec if it is available, even if no key is supplied. (CVS 1226) (check-in: [95989717] user: drh branch: trunk, size: 38613)
02:18
[514056d5] part of check-in [5200e9ed] Pass all (relevant) regression tests when using the codec. (CVS 1223) (check-in: [5200e9ed] user: drh branch: trunk, size: 38640)
2004-02-10
02:57
[77b1d34a] part of check-in [9c6b4758] Make the pager accessible from the btree structure always, not just during debugging. (CVS 1219) (check-in: [9c6b4758] user: drh branch: trunk, size: 38644)
2004-02-01
01:22
[a069d352] part of check-in [3c796de8] Fix the handling of -init option to the sqlite shell. Ticket #568. Also add hooks for encrypting the database. (CVS 1206) (check-in: [3c796de8] user: drh branch: trunk, size: 38550)
2003-12-04
20:51
[3b067edc] part of check-in [e5e6a848] Use sqlite_freemem() instead of free() in the shell. Windows needs this. (Unix does not care.) Ticket #444. (CVS 1125) (check-in: [e5e6a848] user: drh branch: trunk, size: 37987)
2003-07-18
01:30
[c2ba26c8] part of check-in [558969ee] In the sqlite shell, change the name of function getline() to local_getline() to avoid a clash with a library function. Ticket #400. (CVS 1056) (check-in: [558969ee] user: drh branch: trunk, size: 37927)
2003-06-16
00:16
[3ed26890] part of check-in [bcf5eeec] Preserve blank lines in the middle of SQL statements in the shell. Ticket #352 (CVS 1026) (check-in: [bcf5eeec] user: drh branch: trunk, size: 37903)
2003-05-19
23:55
[b63089a9] part of check-in [e8566cf5] Fix segfault that occurs when opening a non-existing database in the shell then immediately doing ".q". (CVS 986) (check-in: [e8566cf5] user: drh branch: trunk, size: 37876)
2003-05-13
00:24
[2565cb32] part of check-in [6e5c497a] Remove unnecessary "#include <sqliteInt.h>" from the shell code. (CVS 971) (check-in: [6e5c497a] user: drh branch: trunk, size: 37864)
2003-05-11
20:07
[88305ca3] part of check-in [bad20653] Changed ".databases" command to use PRAGMA database_list. (CVS 967) (check-in: [bad20653] user: jplyon branch: trunk, size: 37890)
2003-05-04
18:30
[89a14538] part of check-in [5656fe48] Shell command-line parsing enhancements suggested by Mike Hall. (CVS 956) (check-in: [5656fe48] user: drh branch: trunk, size: 37857)
07:25
[c53ff468] part of check-in [741a5a8d] added shell command ".databases" to list name and file of open ones. (CVS 953) (check-in: [741a5a8d] user: jplyon branch: trunk, size: 36710)
2003-04-30
11:38
[6f59240f] part of check-in [20fcead4] In the shell tool, delay opening the database until it is needed but also make sure it is opened before trying to use the "db" pointer. Ticket #302. (CVS 945) (check-in: [20fcead4] user: drh branch: trunk, size: 36195)
2003-04-29
18:01
[4dc33c49] part of check-in [8211f57b] Accept a "/" or "go" on a line by itself as an SQL statement terminator in the command-line shell. This allows SQL Server and Oracle scripts to be played into SQLite without change. (CVS 944) (check-in: [8211f57b] user: drh branch: trunk, size: 34770)
2003-04-26
03:03
[6557e37e] part of check-in [639957e9] Fix the shell tool to do a better job of ignoring whitespace. Ticket #234. (CVS 940) (check-in: [639957e9] user: drh branch: trunk, size: 34175)
02:50
[137f4a1e] part of check-in [92ded933] Only print the "Loading resources from..." line when the output is a TTY. Ticket #168. (CVS 939) (check-in: [92ded933] user: drh branch: trunk, size: 34016)
2003-04-24
01:45
[e0b3da1f] part of check-in [206b1739] Fix some issues with INSTEAD OF triggers. (CVS 930) (check-in: [206b1739] user: drh branch: trunk, size: 33951)
2003-04-17
22:57
[a0b70437] part of check-in [1e5e00fb] Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) (check-in: [1e5e00fb] user: drh branch: trunk, size: 33926)
02:54
[6980eadd] part of check-in [35caefe3] Change the shell to use the sqliteIsNumber() routine for determining if values are numeric. Modified os.c so that it should now work with DJGPP - though I have no way of testing this. (CVS 913) (check-in: [35caefe3] user: drh branch: trunk, size: 33909)
2003-04-03
19:35
[97f397c0] part of check-in [452128c6] Fix for ticket #276. (CVS 897) (check-in: [452128c6] user: drh branch: trunk, size: 34257)
2003-03-30
19:17
[c13ff46e] part of check-in [b6d6e07f] Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 889) (check-in: [b6d6e07f] user: drh branch: trunk, size: 34244)
2003-02-05
14:06
[0d260a00] part of check-in [e21afb82] Make the shell run much faster for inputs where a single SQL statement spans thousands of lines by avoiding the call to sqlite_complete() unless the input ends in a semicolon. (CVS 860) (check-in: [e21afb82] user: drh branch: trunk, size: 34548)
2003-01-18
17:05
[cbb29252] part of check-in [32a8e6e9] Do not report an error if the input to the sqlite shell ends in a comment. Ticket #211. (CVS 838) (check-in: [32a8e6e9] user: drh branch: trunk, size: 34273)
2003-01-08
13:02
[c9946847] part of check-in [13f82d67] Port ot MacOS Classic. Ticket #218. (CVS 820) (check-in: [13f82d67] user: drh branch: trunk, size: 33877)
2002-11-11
13:56
[53185af1] part of check-in [dc5d9c12] Remove extra from HTML output. Ticket #189. (CVS 786) (check-in: [dc5d9c12] user: drh branch: trunk, size: 33491)
2002-08-21
11:26
[9e9a6eb6] part of check-in [ea011990] Fix for ticket #137: Use getpwuid() instead of getpwent(). (CVS 723) (check-in: [ea011990] user: drh branch: trunk, size: 33496)
2002-07-13
17:33
[37a8405a] part of check-in [e1842e04] Fix for ticket #64: Better error reporting in the shell. (CVS 676) (check-in: [e1842e04] user: drh branch: trunk, size: 33548)
2002-07-10
21:26
[16cb2db2] part of check-in [ff8b6f4e] When reporting back the datatype of columns, use the text of the datatype as it appears in the CREATE TABLE statement, if available. Also: removed the ".reindex" command from the shell. (CVS 669) (check-in: [ff8b6f4e] user: drh branch: trunk, size: 33421)
2002-06-25
19:31
[0b06e442] part of check-in [332164d6] Add the sqlite_open_aux_file() API. (CVS 646) (check-in: [332164d6] user: drh branch: trunk, size: 34530)
01:09
[7b9d98ef] part of check-in [9c1432bf] Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) (check-in: [9c1432bf] user: drh branch: trunk, size: 34226)
2002-05-21
13:02
[1d22fe87] part of check-in [f795afd6] Modify the shell so that when it is doing a ".dump" it always uses single quotes and not double quotes for quoting literal strings. This is for portability to other databases that only support single quote string literals. (CVS 574) (check-in: [f795afd6] user: drh branch: trunk, size: 33146)
2002-04-21
19:06
[5acbe59e] part of check-in [8a50c57c] Fix for ticket #21 (I think): Do not return an "out of memory" error if we can not find the users home directory. Instead, just report that we could not find the home directory. (CVS 540) (check-in: [8a50c57c] user: drh branch: trunk, size: 33256)
2002-04-19
12:34
[c0800304] part of check-in [ca4abf3f] Add support for saving the sqlite shell command-line history across sessions. (CVS 536) (check-in: [ca4abf3f] user: drh branch: trunk, size: 33064)
01:00
[56ed7250] part of check-in [6c32c07e] Added rights release for Matthew O. Persico (CVS 535) (check-in: [6c32c07e] user: persicom branch: trunk, size: 32010)
2002-04-18
12:39
[4a225aa8] part of check-in [0582168b] Change shell.c so that it will compile under windows. Shorten the help command somewhat. Add the state of ".header" to the output of ".show". (CVS 534) (check-in: [0582168b] user: drh branch: trunk, size: 31881)
02:53
[e473e195] part of check-in [4bdd040e] Mistake in help text. Spurious trailing whitespace removed. (CVS 532) (check-in: [4bdd040e] user: persicom branch: trunk, size: 32296)
02:46
[33e2574f] part of check-in [e751338c] General: o Added global static chars mainPrompt and continuePrompt. o Moved Argv0 declaration to head of file. Needed in do_meta_command, previously found below that. o Added struct previous_mode_data to support new .explain toggle functionality. o Added nullvalue, explainPrev and outfile members to struct callback_data. o Added modeDescr array for number/text translation ofdisplay modes. o Modified zHelp to match new functionality.

callback(): o Added support for .nullvalue

do_meta_command(): o Output filename is now saved to callback struct. If using stdout, then the string "stdout" is saved. o Explain is now a toggle. When it is turned on, the current values of mode, header and colWidth are saved if not already in explain mode. When turned off, those values are restored. o Allow .mode plurals columns and lines and dot command plural .headers. o Added processing for new keywords .quit, .nullvalue, .show, .prompt.

main(): o Added -init as an option to override .sqliterc. o Added -nullvalue as a command line option. o Processes .sqliterc.

main_init(): o Genesis. Moved some initialization code here from inside main() so that it can be called initially by main and again if -init is specified.

one_input_line(): o Now takes prompts from settable values.

process_sqliterc(): o Genesis. Read .sqliterc from user's home directory and pass it to process_input(). File should contain meta commands for setups. (CVS 531) (check-in: [e751338c] user: persicom branch: trunk, size: 32365)

2002-04-13
23:42
[66bf0478] part of check-in [7edd1346] When doing a ".dump" command in the command-line shell, make sure VIEWs are created after TABLEs. (CVS 529) (check-in: [7edd1346] user: drh branch: trunk, size: 25333)
2002-04-08
02:42
[994ca7c8] part of check-in [760bf568] Add a -column option to the sqlite command-line utility. Patch from Matthew O. Persico. (CVS 522) (check-in: [760bf568] user: drh branch: trunk, size: 25338)
2002-04-04
15:10
[cf57c66e] part of check-in [93227418] Add an fflush() call to shell.c to insure that all output has been written before we prompt for a new line of input. (CVS 519) (check-in: [93227418] user: drh branch: trunk, size: 25233)
2002-03-03
23:06
[b3454229] part of check-in [81307762] More bugs fixed for views. (CVS 416) (check-in: [81307762] user: drh branch: trunk, size: 25217)
2002-02-26
23:24
[9f8249ca] part of check-in [f2310f36] Fix a bug in the quoting of .dump output. By Rajit Singh. (CVS 394) (check-in: [f2310f36] user: drh branch: trunk, size: 25193)
2002-02-21
02:25
[cbf48bf0] part of check-in [ffb00bf3] Do not allow dot-commands to occur in the middle of a real SQL command. (CVS 385) (check-in: [ffb00bf3] user: drh branch: trunk, size: 25172)
2002-01-24
00:00
[c102dfe3] part of check-in [5f8c097e] Do not escape the backslash character in shell output. (CVS 353) (check-in: [5f8c097e] user: drh branch: trunk, size: 25161)
2002-01-22
12:39
[a77f9f1f] part of check-in [593c986f] Fix a bug in the -separator command-line option. (CVS 351) (check-in: [593c986f] user: drh branch: trunk, size: 25499)
2002-01-15
18:39
[539a41d4] part of check-in [f8a026a3] Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) (check-in: [f8a026a3] user: drh branch: trunk, size: 25499)
2002-01-06
17:07
[f8008f06] part of check-in [9b0be4fc] Comment updates most. Also some small changes to the VDBE. (CVS 339) (check-in: [9b0be4fc] user: drh branch: trunk, size: 25474)
2001-11-25
13:18
[407095aa] part of check-in [653f37c3] Add the ability to do a single .command as the second argument to the command-line shell. (CVS 321) (check-in: [653f37c3] user: drh branch: trunk, size: 25474)
2001-11-24
00:31
[175f4e94] part of check-in [fc2aae04] Fix comparison functions so that they are consistent with the order of elements in indices. Fix the handling of large integers. (CVS 317) (check-in: [fc2aae04] user: drh branch: trunk, size: 25335)
2001-11-09
22:41
[18e9f1ca] part of check-in [6e7e7dbf] Minor bugs fixed. (CVS 307) (check-in: [6e7e7dbf] user: drh branch: trunk, size: 25333)
2001-10-19
16:44
[71597951] part of check-in [8467d84f] Version 2.0.6 (CVS 291) (check-in: [8467d84f] user: drh branch: trunk, size: 25311)
2001-10-06
16:33
[cb8c41f1] part of check-in [b63b3f36] Adding table column query capability to support ODBC. (CVS 278) (check-in: [b63b3f36] user: drh branch: trunk, size: 25149)
2001-10-01
14:29
[cd2ae9f2] part of check-in [20382325] The .dump output uses INSERT instead of COPY now. Expression syntax of the form "expr NOT NULL" is now supported. (CVS 276) (check-in: [20382325] user: drh branch: trunk, size: 25178)
2001-09-27
15:11
[977ec6b6] part of check-in [116fdad0] Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) (check-in: [116fdad0] user: drh branch: trunk, size: 24227)
2001-09-16
00:13
[8e573138] part of check-in [4e926efe] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (check-in: [4e926efe] user: drh branch: trunk, size: 24181)
2001-09-13
13:46
[1fcdf8c4] part of check-in [6ecc8b20] The code is in place to replace GDBM with BTree. But I have not yet attempted to compile it. I am sure the code contains bugs. (CVS 238) (check-in: [6ecc8b20] user: drh branch: trunk, size: 24736)
2001-04-11
14:28
[d9c64418] part of check-in [86b30cd0] better handling of out-of-memory errors (CVS 207) (check-in: [86b30cd0] user: drh branch: trunk, size: 24724)
2001-04-04
21:22
[c1785b4a] part of check-in [490d08a8] Clean up some compiler warnings (CVS 200) (check-in: [490d08a8] user: drh branch: trunk, size: 22581)
2001-01-04
14:27
[441e2091] part of check-in [5ddeeb47] :-) (CVS 174) (check-in: [5ddeeb47] user: drh branch: trunk, size: 22524)
14:20
[2188df59] part of check-in [d49e10fb] :-) (CVS 171) (check-in: [d49e10fb] user: drh branch: trunk, size: 22371)
2000-10-16
22:06
[14614992] part of check-in [f7ea08b9] Added an interrupt capability (CVS 153) (check-in: [f7ea08b9] user: drh branch: trunk, size: 22206)
2000-10-08
22:20
[ef5d1212] part of check-in [f9372072] Added the _printf() interface. (CVS 150) (check-in: [f9372072] user: drh branch: trunk, size: 21766)
2000-09-29
13:30
[3d25f670] part of check-in [e11f7527] :-) (CVS 147) (check-in: [e11f7527] user: drh branch: trunk, size: 21384)
2000-08-28
16:21
[f1ef4268] part of check-in [b8cec9b9] adding length() and substr() tests. fix shell.c bug (CVS 144) (check-in: [b8cec9b9] user: drh branch: trunk, size: 20442)
2000-08-22
13:40
[061186b1] part of check-in [c6b71d9b] :-) (CVS 138) (check-in: [c6b71d9b] user: drh branch: trunk, size: 20410)
13:27
[9bbb37f3] part of check-in [5f6559ee] :-) (CVS 137) (check-in: [5f6559ee] user: drh branch: trunk, size: 20356)
2000-08-17
09:50
[0aabf9e5] part of check-in [897b4bc0] allow readonly access when write permission denied (CVS 131) (check-in: [897b4bc0] user: drh branch: trunk, size: 20348)
2000-08-08
20:19
[cd560887] part of check-in [2b3511ec] Add pattern matching to the .table command (CVS 129) (check-in: [2b3511ec] user: drh branch: trunk, size: 20184)
2000-08-02
13:47
[2fd37083] part of check-in [b7b90237] file format change (CVS 122) (check-in: [b7b90237] user: drh branch: trunk, size: 19951)
2000-07-31
11:57
[a5eb8ee9] part of check-in [69b73ea3] fix a configuration problem on TAC-4 (CVS 113) (check-in: [69b73ea3] user: drh branch: trunk, size: 19843)
2000-07-29
13:20
[3fd7424c] part of check-in [57022a9d] better column names in the shell (CVS 111) (check-in: [57022a9d] user: drh branch: trunk, size: 19822)
2000-07-28
14:32
[ffcb1156] part of check-in [4fe8e51c] added the sqlite_busy_handler() interface (CVS 109) (check-in: [4fe8e51c] user: drh branch: trunk, size: 19461)
2000-06-21
13:59
[8387580e] part of check-in [e1bf96a4] :-) (CVS 104) (check-in: [e1bf96a4] user: drh branch: trunk, size: 19239)
2000-06-15
16:49
[78a35607] part of check-in [ac38f460] :-) (CVS 99) (check-in: [ac38f460] user: drh branch: trunk, size: 19238)
15:57
[082feaeb] part of check-in [f26d0cdf] :-) (CVS 98) (check-in: [f26d0cdf] user: drh branch: trunk, size: 18675)
2000-06-07
02:04
[3f4afc39] part of check-in [fc8d25ea] :-) (CVS 68) (check-in: [fc8d25ea] user: drh branch: trunk, size: 16624)
01:33
[9c981392] part of check-in [8bff1bee] :-) (CVS 67) (check-in: [8bff1bee] user: drh branch: trunk, size: 16610)
01:27
[23d9700d] part of check-in [5d2e72e4] :-) (CVS 66) (check-in: [5d2e72e4] user: drh branch: trunk, size: 16592)
00:12
[a2a2c5c6] part of check-in [80ee166e] :-) (CVS 65) (check-in: [80ee166e] user: drh branch: trunk, size: 14462)
2000-06-05
02:07
[5fa24c0b] part of check-in [1cf2873d] :-) (CVS 50) (check-in: [1cf2873d] user: drh branch: trunk, size: 14388)
2000-06-04
12:58
[d184aeae] part of check-in [6ea5cebf] rework the VDBE engine. NULL is now distinct from "" (CVS 49) (check-in: [6ea5cebf] user: drh branch: trunk, size: 14287)
2000-06-02
13:27
[bd658f92] part of check-in [2b55f9b7] :-) (CVS 37) (check-in: [2b55f9b7] user: drh branch: trunk, size: 14198)
2000-05-31
23:33
[9a42923e] part of check-in [9b8458bb] :-) (CVS 30) (check-in: [9b8458bb] user: drh branch: trunk, size: 14204)
02:27
[c5752d32] part of check-in [01d85b35] :-) (CVS 20) (check-in: [01d85b35] user: drh branch: trunk, size: 12762)
2000-05-30
18:45
[3ffa9059] part of check-in [97a0fb78] loads the complete ACD database! (CVS 17) (check-in: [97a0fb78] user: drh branch: trunk, size: 12752)
2000-05-29
17:44
[125f84ea] part of check-in [53841c66] :-) (CVS 2) (check-in: [53841c66] user: drh branch: trunk, size: 11002)
14:26
Added: [de770d16] part of check-in [6f3655f7] initial check-in of the new version (CVS 1) (check-in: [6f3655f7] user: drh branch: trunk, size: 10921)