/ File History
Login

History of src/shell.c

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