SQLite
File History
Not logged in

History of files named src/shell.c

2015-01-30
20:59
[22b4406b0b] part of check-in [42d5601739] 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. (user: drh branch: trunk
2015-01-29
17:54
[ed7cf7c29f] part of check-in [5940af8e78] Add the INITMODE test-control. (user: drh branch: initmode-testctrl
02:26
[ff4dafe42c] part of check-in [2305411097c] Experimental sqlite_db_config() setting to disable writing to all btrees except for one btree with a particular root page. (user: drh branch: one-writable-btree
2015-01-27
21:24
[efd3590048] part of check-in [e7d2ec048c] Fix harmless compiler warnings. (user: mistachkin branch: trunk
2015-01-24
12:12
[37c6d97399] part of check-in [2a9ea9b4a7] 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. (user: drh branch: trunk
2015-01-22
11:29
[acdf311a7a] part of check-in [bd63bf882c] Change the undocumented ".selecttrace" command in the shell to accept an integer bitmask rather than a boolean. (user: drh branch: trunk
2015-01-19
20:22
[f5e99e5411] part of check-in [d8564f70e6] Remove a shell function that is now superfluous. (user: mistachkin branch: expShell
20:19
[1a54271746] part of check-in [d9f4035b38] Merge updates from trunk. (user: mistachkin branch: expShell
15:05
[d2d3b46701] part of check-in [824328f983] Enhance the command-line shell with the ability to set the SQLITE_TESTCTRL_NEVER_CORRUPT flag using: ".testctrl never_corrupt 1". (user: drh branch: trunk
07:42
[e0fefd7e94] part of check-in [c7167f88ec] Merge updates from trunk. (user: mistachkin branch: expShell
2015-01-18
20:30
[4958f393be] part of check-in [7096e6c06d] Set binary mode for output on Windows when writing a quoted string that might contain newline characters. (user: drh branch: trunk
05:35
[b976fd2b3d] part of check-in [25e99f3fe5] Some experimental command line shell input/output enhancements. (user: mistachkin branch: expShell
01:50
[96c40c8546] part of check-in [80541e8b94] Set the command-line shell stdin to binary mode on windows. (user: drh branch: trunk
2015-01-14
17:16
[ab438b9812] part of check-in [0ba124540b] Merge trunk 3.8.8 beta changes into the sessions branch (user: drh branch: sessions
2015-01-12
18:52
[5b8e786a7c] part of check-in [ca5f2c5452] Merge updates from trunk. (user: mistachkin branch: msvcW4
18:02
[0cebd04b20] part of check-in [856dd245ce] Work in progress on fixing harmless compiler warnings when using -W4 and MSVC. (user: mistachkin branch: msvcW4
2015-01-10
16:49
[96ba1f6300] part of check-in [9e92a5ed5a] 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. (user: drh branch: trunk
2014-12-11
04:49
[1b7cb3efc5] part of check-in [e0e102a0bd] Update a comment. (user: mistachkin branch: asciiMode
03:29
[3628fab3fb] part of check-in [d48eda16ef] Rename a structure member to improve code clarity. (user: mistachkin branch: asciiMode
03:25
[d2c9565c39] part of check-in [d8404340cb] Remove an unused structure member. (user: mistachkin branch: asciiMode
03:20
[4649c6bdfc] part of check-in [cf9c6e7eea] Further simplify shell mode changes. (user: mistachkin branch: asciiMode
03:12
[84359f80c4] part of check-in [66a28f7aba] Simplify and cleanup the implementation of the new ASCII mode for the shell. (user: mistachkin branch: asciiMode
02:28
[1c7787d106] part of check-in [5b5d3e4d0d] Merge updates from trunk. (user: mistachkin branch: asciiMode
2014-12-02
16:31
[81e4f2b573] part of check-in [2617d93713] Merge all recent fixes and enhancements from trunk into sessions. (user: drh branch: sessions
2014-11-28
13:35
[45d9c9bd7c] part of check-in [24fa2e9832] 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. (user: drh branch: trunk
11:54
[f49ecad5af] part of check-in [b59397b1f1] 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. (user: drh branch: trunk
2014-11-18
21:20
[a67b1304a7] part of check-in [f09055f3c4] 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. (user: drh branch: sessions
2014-11-10
14:42
[bc28d59921] part of check-in [7f3819f642] Shorten over-length source code lines in shell.c. (user: drh branch: trunk
2014-11-07
13:52
[0500307f63] part of check-in [5700508535c] In the ".scanstats on" output from the shell, round the estRows value to the nearest integer, rather than rounding toward zero. (user: drh branch: trunk
2014-11-06
12:46
[48fe276aad] part of check-in [ee922682bb] 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. (user: drh branch: scanstatus
12:17
[64a941c079] part of check-in [d1c51c8455] On the ".scanstats on" output in the shell, initialize the estimated count for the first loop of each subquery to the actual loop count. (user: drh branch: scanstatus
12:08
[22c7c693f3] part of check-in [eacbbd8849] Changes the formatting of ".scanstats on" in the shell so that the stats for subqueries are grouped together and occur after the main query. (user: drh branch: scanstatus
04:42
[74768f90bd] part of check-in [64ad5761a8] Add the SQLITE_SCANSTAT_SELECTID metric. Use it to improve the ".stmtscan on" output in the shell. (user: drh branch: scanstatus
03:55
[908ff96ef1] part of check-in [f968400066] 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. (user: drh branch: scanstatus
2014-11-05
09:07
[5ad1eb4dfc] part of check-in [7974c0ed10] 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. (user: dan branch: trunk
2014-10-31
14:53
[e3a0e5d94d] part of check-in [28b044a512] Merge recent trunk enhancements, and in particular the improvements to the b-tree balancing logic, into the sessions branch. (user: drh branch: sessions
2014-10-23
17:26
[ed2796b3bb] part of check-in [c6a5b67ae1] Add debugging code to count the number of iterations of each loop made as part of statement execution. (user: dan branch: debug-loopcounters
2014-10-17
21:35
[282f8f5278] part of check-in [19fe4a0a47] Fix a (probably harmless) bug in the CSV output mode of the command-line shell. (user: drh branch: trunk
2014-10-14
13:41
[f2b146c899] part of check-in [83d4114f2a] Merge recent trunk micro-optimizations and the DESC index GROUP BY ORDER BY bug fix into the sessions branch. (user: drh branch: sessions
2014-10-10
13:08
[18ee8bbe95] part of check-in [177fff3b98] Cause the command-line shell to return non-zero if the final SQL statement is incomplete. (user: drh branch: trunk
2014-10-01
01:52
[801af09adf] part of check-in [2695772c98] Merge the latest enhancements from trunk. (user: drh branch: sessions
2014-09-30
12:33
[38f627b088] part of check-in [4ff51325d6] Remove the SQLITE_ENABLE_TREE_EXPLAIN compile-time option. Add alternative debugging display routines: sqlite3TreeViewExpr(), sqlite3TreeViewExprList(), and sqlite3TreeViewSelect(). (user: drh branch: trunk
2014-09-21
22:49
[85aae71dcc] part of check-in [6406b77f2c] Merge all recent trunk changes into the sessions branch. (user: drh branch: sessions
2014-09-20
18:18
[dad23987c3] part of check-in [cbe0cf9ddf] Enable SELECT query planning tracing when compiled with SQLITE_ENABLE_SELECTTRACE and either SQLITE_DEBUG or SQLITE_TEST. (user: drh branch: select-trace
2014-09-11
16:19
[c00220cdd7] part of check-in [842c6da8f1] 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. (user: drh branch: user-auth
00:27
[7d26b6526f] part of check-in [2f6d8f32ee] Reorder parameters on the sqlite3_user_*() interfaces for consistency. Add the first TCL test cases. (user: drh branch: user-auth
2014-09-10
19:01
[4dac2ec625] part of check-in [a0455f9deb] Add the ".user" shell command and implement the sqlite3_user_add() routine. Incremental check-in. The code compiles but does not work. (user: drh branch: user-auth
2014-09-02
15:49
[ec6d5f630e] part of check-in [d4cce2c71e] Merge the latest trunk changes, including the multi-threaded sorter, into the sessions branch. (user: drh branch: sessions
2014-09-01
01:16
[713cef4d73] part of check-in [3ef3246120] Fix harmless compiler warnings for MSVC. (user: mistachkin branch: trunk
01:15
[31c5f73b52] part of check-in [51f33cf129] Merge updates from trunk. (user: mistachkin branch: asciiMode
2014-08-30
15:49
[10b3bbf929] part of check-in [f61db04be4] In the command-line shell, added options --lookaside, --pagecache, and --scratch used to configure auxiliary memories. (user: drh branch: trunk
2014-08-25
23:44
[88378cef39] part of check-in [e3305d4b4e] 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. (user: drh branch: threads
15:13
[6dab215a30] part of check-in [29c5e8a7c9] Query or change the maximum number of worker threads allowed on each database connection separately using the "PRAGMA threads" command. (user: drh branch: threads
13:27
[200772eebd] part of check-in [dfdc900f5d] Merge the recent performance enhancements implemented on trunk into the threads branch. (user: drh branch: threads
2014-08-21
16:09
[34be9dc9e7] part of check-in [0b9e2c3269] 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. (user: drh branch: sessions
2014-08-19
19:28
[728d222659] part of check-in [d09d63c077] Improvements to output formatting with the ".trace" command in the command-line shell. (user: drh branch: trunk
00:26
[220564b70a] part of check-in [b69f7dd1f3] Improved response to error conditions in the ".session" shell command and in the "changeset" command-line program. (user: drh branch: sessions
2014-08-18
20:01
[1761e117dd] part of check-in [7b12f1f9c0] A reasonably complete implementation of the "changeset" command-line tool and the ".sessions" command in the command-line shell. (user: drh branch: sessions_from_cli
17:56
[0845863fc7] part of check-in [55bb3544a6] Add the "changeset" command-line utility for getting an ASCII dump of change sets. (user: drh branch: sessions_from_cli
15:08
[6378fc281a] part of check-in [c2fcf0b9f4] 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. (user: drh branch: sessions_from_cli
13:45
[41df110361] part of check-in [11a70e1ae7] Refactor the names of state objects in the command-line shell implementation.. (user: drh branch: trunk
2014-08-14
14:02
[26f8ef7f52] part of check-in [a608fd1d52] Merge the pre-3.8.6 changes into the threads branch. (user: drh branch: threads
2014-08-11
14:21
[75bb7bd2c8] part of check-in [52b03f045e] Fix harmless compiler warnings. (user: drh branch: trunk
2014-08-06
14:36
[4af71e7f25] part of check-in [1202e9771f] Fix harmless compiler warnings. In the command-line shell, report if the ".system" command returns a non-zero result. (user: drh branch: trunk
2014-07-24
22:51
[5129214fbe] part of check-in [9c424a5c50] Correct help text and make consistent use of snprintf. (user: mistachkin branch: asciiMode
22:20
[e1177e053e] part of check-in [289092bb64] Fix typo in comment and update help text. (user: mistachkin branch: asciiMode
22:13
[3af679cad9] part of check-in [8dc0cdf652] Merge updates from trunk. (user: mistachkin branch: asciiMode
16:54
[05e9e7f667] part of check-in [770685892c] Merge all recent trunk changes into the threads branch. (user: drh branch: threads
12:39
[191129c3f7] part of check-in [fb1048cb2b] Add the readfile(FILENAME) and writefile(FILENAME,CONTENT) SQL functions to the command-line shell. (user: drh branch: trunk
12:09
[cca6ea1571] part of check-in [16c8ce10e1] 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. (user: drh branch: trunk
2014-07-19
20:15
[f1524cdcf1] part of check-in [7fe601ead0] 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). (user: mistachkin branch: asciiMode
2014-07-18
14:43
[566aee8213] part of check-in [fa80c64caa] Improvements to the ".fullschema" command in the command-line shell. (user: drh branch: trunk
2014-06-30
20:25
[2aa1fd880d] part of check-in [ae23a65eb1] Merge the latest trunk changes into the threads branch. (user: drh branch: threads
2014-06-23
23:28
[56de2dfa3f] part of check-in [ebec48921c] 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. (user: drh branch: trunk
2014-06-18
15:18
[3ac174189f] part of check-in [0e1b73496f] Merge in all recent changes from trunk, and especially the automatic index enhancements. (user: drh branch: threads
2014-06-16
22:45
[058940e8a7] part of check-in [fc918f7d33] Fix CSV import issue, reported via the mailing list, in the shell when the file to be imported ends with an empty line. (user: mistachkin branch: trunk
15:01
[d472576bc7] part of check-in [b0b4c776c3] 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). (user: drh branch: trunk
2014-06-05
13:22
[c431e19b27] part of check-in [e4b01676d7] Bring the threads branch up-to-date with the 3.8.5 release. (user: drh branch: threads
2014-05-31
15:43
[98ce7f5244] part of check-in [39fafe0a19] Fix a harmless "scan-build" compiler warning in the command-line shell. (user: drh branch: trunk
2014-05-29
20:39
[d4ec3e1473] part of check-in [a80527f60b] Fix a harmless compiler warning in the command-line shell code. (user: drh branch: trunk
20:24
[3d2cdb8d6a] part of check-in [416cb09126] Merge changes from the trunk into the threads branch. (user: drh branch: threads
20:17
[33f6c0bc0e] part of check-in [8f916ed1e1] Fix to the EXPLAIN indentation logic in the command-line shell. (user: drh branch: trunk
12:36
[a94689054b] part of check-in [48dce821a0] 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. (user: drh branch: trunk
03:17
[f389c2bcae] part of check-in [e58f4bd39d] Only quote the arguments to the ".shell" and ".system" commands if they contain spaces. (user: drh branch: trunk
2014-05-28
20:22
[8a0f8f4cd3] part of check-in [d018a34a05] Add the ".shell" and the ".system" commands (aliases for the same thing) to the command-line shell. (user: drh branch: trunk
2014-05-26
20:15
[4b976f0461] part of check-in [8215202759d] Merge recent trunk changes into the threads branch. (user: drh branch: threads
18:27
[bfac06fb15] part of check-in [856d44a206] 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. (user: dan branch: trunk
2014-05-23
12:03
[86a6aa8417] part of check-in [b5cde57166] 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. (user: drh branch: trunk
2014-04-18
12:38
[6946aea9f2] part of check-in [8729aa3e3e] Merge recent trunk changes into the threads branch. (user: drh branch: threads
00:06
[2afe7a7154] part of check-in [9c6961967a] 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. (user: drh branch: trunk
2014-04-07
18:44
[b44c3f17f0] part of check-in [cbfc0f6d49] Experimental multi-threaded sorting changes to begin merging PMAs before SorterRewind() is called. (user: dan branch: abandoned
2014-04-03
16:42
[afc0b1a5a6] part of check-in [a0910079ad] Merge all recent changes from trunk. (user: drh branch: threads
00:32
[5260f2ada8] part of check-in [9d2ae6342c] In the command-line shell, run set writable_schema before running the ".clone" command. (user: drh branch: trunk
2014-04-01
15:38
[a08060750f] part of check-in [643c86a056] 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. (user: dan branch: threads
2014-03-25
14:12
[f48b63f8e5] part of check-in [1cab83577c] Enable four sorting threads by default in the command-line shell. (user: drh branch: threads
2014-03-20
18:45
[cee9f46f26] part of check-in [01944c53f5] Fix the EXPLAIN indenter in the command-line shell to correctly handle NextIfOpen and PrevIfOpen opcodes. (user: drh branch: trunk
2014-03-06
13:38
[bab4de12b4] part of check-in [0a4200f95c] 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. (user: drh branch: trunk
02:15
[c0cbbbe5ee] part of check-in [c87d8e07ec] Cosmetic change to the shell in-memory database warning to skip coloring the trailing period. (user: mistachkin branch: trunk
2014-02-28
20:47
[7bf07bcacb] part of check-in [e6ecf73376] 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. (user: drh branch: trunk
19:37
[e6d573326f] part of check-in [0a3579d9b9] Provide an #ifdef in shell.c to work around issues when cross-compiling from Ubuntu to windows. (user: drh branch: trunk
2014-02-27
15:11
[bf75ce6bea] part of check-in [51ce713c6e] A better way of handling the USE_SYSTEM_SQLITE #define in shell.c. (user: drh branch: trunk
15:04
[720e79facd] part of check-in [a669040023] 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. (user: drh branch: trunk
2014-02-26
13:53
[ca2b066ab3] part of check-in [9c2e7612cd] 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. (user: drh branch: trunk
2014-02-11
16:22
[3dd86bf73c] part of check-in [f5ad1e1bf2] 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. (user: drh branch: trunk
14:37
[b1f75cfcd0] part of check-in [7989ce5f10] Fixes to the "editline" support in the command-line shell. (user: drh branch: trunk
2014-02-10
19:59
[cb8d195944] part of check-in [fe284afe73] Add the ".save" command as an alias for ".backup". Improvements to the way font changes are implemented on the in-memory database warning. (user: drh branch: memdb-warning
19:36
[8b549f8320] part of check-in [c9eba2f7be] On unix, make the "transient in-memory database" text bold, but not red. Leave the text read on windows. (user: drh branch: memdb-warning
19:27
[7e4d5dcb21] part of check-in [0fbc0fcec1] In the command-line shell, on the banner, warn about the use of a transient in-memory database in bold red text. (user: drh branch: memdb-warning
16:13
[df7d96e504] part of check-in [90e9deae4a] Modify the command-line shell to print a warning when using an in-memory database. (user: drh branch: memdb-warning
2014-02-06
02:46
[7dedf7367e] part of check-in [dd0db3f0ce] Add additional error messages and a progress spinner to the ".clone" command. (user: drh branch: trunk
01:15
[da0a97d984] part of check-in [4f9d95624a] Rename the '.repair' shell command to '.clone'. (user: mistachkin branch: trunk
00:49
[c128bf92b3] part of check-in [d1dfadea87] Add the ".repair" command to the command-line shell. (user: drh branch: trunk
2014-01-21
22:25
[24722d24d4] part of check-in [b2671e1133] 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. (user: drh branch: cte-via-queue
2014-01-13
20:38
[9f3bc02a65] part of check-in [ac15455abc] 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). (user: drh branch: trunk
2013-12-21
15:46
[a3541193d5] part of check-in [96397263f9] 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. (user: drh branch: trunk
2013-12-11
14:00
[18924f6ccf] part of check-in [5e239ecda0] 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. (user: drh branch: trunk
2013-11-27
13:24
[936a72ff78] part of check-in [ceebcdcaf1] Make sure the colWidth array is correctly initialized in the ".explain" command of the shell. (user: drh branch: trunk
2013-11-21
23:37
[c4d06a9238] part of check-in [3d47a556f0] Fix a harmless clang warning in the command-line shell. (user: drh branch: trunk
2013-11-18
08:41
[849ee96c95] part of check-in [9c8d685625] Fix a problem with the shell tool EXPLAIN indentation code and VDBE sub-programs. (user: dan branch: trunk
2013-11-15
03:16
[b98e74123d] part of check-in [cbe85cc2a9] Another adjustment to the EXPLAIN indentation logic, in order to deal with the sorter loop on a CREATE INDEX statement. (user: drh branch: trunk
2013-11-14
23:59
[65a259d538] part of check-in [ea141a9b87] Adjust the command-line shell EXPLAIN indentation logic to handle the second loop of an UPDATE that reads out a RowSet. (user: drh branch: trunk
15:35
[044a79639c] part of check-in [d1fbc6ca18] An experimental virtual tables for showing the content of internal schema objects. (user: drh branch: schema2-vtab
2013-11-13
19:01
[6ccc22b717] part of check-in [f668616a29] 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. (user: drh branch: skip-scan
18:35
[3b23017da7] part of check-in [e7d34ec681] 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. (user: dan branch: trunk
2013-10-30
12:43
[03d8d9b405] part of check-in [908e2c2124] Enhance the timer in the shell to show wall-clock time in addition to user and kernel CPU time. (user: drh branch: trunk
12:30
[43647b08b6] part of check-in [5530cdc485] 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). (user: dan branch: shell-wall-clock
2013-10-24
15:20
[d5eebdc603] part of check-in [21eccb9194] Add the ".open" command to the command-line shell. (user: drh branch: trunk
2013-10-11
16:35
[6f11f0e9de] part of check-in [5f01cd36ee] Additional test cases and requirements marks for the unlikely(), likelihood() and instr() functions. (user: drh branch: trunk
2013-10-01
15:30
[5ee50ca3e3] part of check-in [473234632f] 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. (user: drh branch: trunk
2013-09-04
16:08
[d920a891ca] part of check-in [d8fdc78218] Fix a bug in the command-line shell for ".mode insert" on UTF16 databases with BLOB values. (user: drh branch: trunk
2013-08-29
13:23
[0fb2ce9876] part of check-in [43aa7d2353] 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. (user: drh branch: branch-3.8.0
2013-08-28
18:18
[dbe064d404] part of check-in [12d0a8859d] 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. (user: drh branch: trunk
13:33
[f726500a48] part of check-in [b5617e4fda] 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. (user: drh branch: trunk
01:54
[250e4770af] part of check-in [8917e9f9a0] Fix several harmless compiler warnings. Fix a couple compiler issues with the shell. (user: mistachkin branch: mmapDisabled
2013-08-26
23:18
[00a2331146] part of check-in [a32af0abe5] Merge the STAT4 capability into trunk. (user: drh branch: trunk
2013-08-19
14:23
[1c317a4c96] part of check-in [753a402e90] Remove unused variables from the command-line shell sources. (user: drh branch: trunk
11:15
[909f6c4a52] part of check-in [a0d9ca4f07] Fixes for harmless compiler warnings. (user: drh branch: trunk
2013-08-07
18:42
[128eb16cce] part of check-in [08f74c45ec] Merge latest trunk changes with this branch. (user: dan branch: sqlite_stat4
16:04
[cb075e24f1] part of check-in [1e80c4b12d] Fix the ".dump" command on the command-line shell so that it works for "sqlite_stat4" in addition to "sqlite_stat1". (user: drh branch: sqlite_stat4
2013-08-06
14:36
[927e17b37b] part of check-in [5dcc2d91bd] For the ".import" command of the command-line shell, start a transaction if there is not one active already. (user: drh branch: trunk
14:01
[18be30ad43] part of check-in [2b1743d601] Clean up the input reader in the command-line shell for improved legibility and performance. (user: drh branch: trunk
2013-07-25
17:07
[52f975eae8] part of check-in [8bcbb33fd0] In the command-line shell, work around the fact that popen() and pclose() are not defined in stdio.h. in C89 and later. (user: drh branch: trunk
2013-07-18
20:28
[7da98ff9cb] part of check-in [37abfe0c1e] Remove unused "codec" code from the command-line shell. (user: drh branch: trunk
2013-07-12
21:09
[4c02ec99e4] part of check-in [92adaee5bd] 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. (user: drh branch: trunk
2013-06-30
20:24
[c8cd06e6b6] part of check-in [60b65e5ee3] Fix an issue in the command-line shell with CSV import of rows with empty columns. (user: drh branch: trunk
2013-06-29
15:40
[0587c18fd0] part of check-in [b003b2b2b6] 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. (user: drh branch: trunk
2013-06-27
14:07
[c0f38cee12] part of check-in [4c02b344f5] 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. (user: drh branch: trunk
13:26
[3b8fff51ad] part of check-in [656a1fe5dd] Improved handling of backslash escapes on double-quoted arguments to dot-commands in the command-line shell. (user: drh branch: trunk
13:01
[fab2f606a8] part of check-in [e88fd5b221] 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. (user: drh branch: trunk
2013-06-26
22:46
[92cbe95ead] part of check-in [93f632152e] 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. (user: drh branch: trunk
2013-06-25
22:01
[a02544af66] part of check-in [f1366bab73] Add a new (experimental) sqlite3_stmt_status() verb that returns the number of VM steps. (user: drh branch: status-vm-step
2013-05-31
14:31
[ab6eea968c] part of check-in [b9578c371e] Enhance the shell to provide more flexibility when entering numeric arguments on dot-commands. In particular, allow hex arguments to .wheretrace. (user: drh branch: nextgen-query-plan-exp
2013-05-24
11:57
[9a18124ff2] part of check-in [9e2c17c535] Fix harmless compiler warnings in the shell. (user: drh branch: trunk
2013-05-06
21:01
[2109d54f67] part of check-in [e5b3cd747b] 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. (user: drh branch: trunk
20:28
[115bc2fa3c] part of check-in [b72d365920] 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] (user: drh branch: trunk
2013-04-25
14:59
[5d527e5d08] part of check-in [de556add10] Move the test_spellfix.c module to ext/misc/spellfix.c. (user: drh branch: std-ext
2013-04-17
17:33
[aca9d94653] part of check-in [e2c94ab930] In the command-line shell, allow a dot-command to occur after a multi-line c-style comment. (user: drh branch: trunk
12:19
[a303eb4529] part of check-in [467e218120] Update the command-line shell to give an exit code of 0 when the ".quit" command is run from the command-line. (user: drh branch: trunk
2013-04-15
17:03
[06bca04044] part of check-in [ea1404a10a] 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. (user: drh branch: trunk
2013-04-03
01:26
[319b7791ce] part of check-in [fc30d06c94] Add the -mmap option to the command-line shell, for setting the default mmap_limit. (user: drh branch: experimental-mmap
2013-02-20
00:54
[7c41bfcd9e] part of check-in [9bd9bd9cab] On Minix, disable the ".timer" command in the shell in order to avoid calling getrusage(). (user: drh branch: trunk
2013-01-28
18:18
[266791241d] part of check-in [b4d94947fc] 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. (user: drh branch: trunk
2013-01-25
19:11
[215278ae0c] part of check-in [7813b17d8b] 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. (user: drh branch: trunk
18:33
[db1b04cc1f] part of check-in [8ba951d1b7] 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. (user: drh branch: trunk
2013-01-23
18:53
[af0309c249] part of check-in [f1127e87b9] Improved parsing of the arguments to the ".backup" command in the command-line shell. (user: drh branch: trunk
2012-12-31
20:16
[11c9611580] part of check-in [a611c75061] More test cases for the REGEXP operator. Fix minor bugs uncovered by these test cases. (user: drh branch: trunk
19:18
[e6525781d2] part of check-in [46c8c01b75] Add the test_regexp.c module containing a cross-platform implementation of the REGEXP operator. (user: drh branch: trunk
2012-12-04
00:23
[e392dd1ccb] part of check-in [41fd9dd290] Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (user: mistachkin branch: tclMode
2012-12-01
20:21
[99091f9dcf] part of check-in [2e5e651527] Do not exit the command-line shell if a ".read" command invokes a script that contains two errors. But reported on the mailing list. (user: drh branch: trunk
2012-10-25
15:43
[24cd0aa74a] part of check-in [a6d906cfeb] 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. (user: mistachkin branch: trunk
15:32
[9e9af86453] part of check-in [848f87e22f] Merge the command-line shell enhancements from trunk. Other edits toward trying to get ssdsim to run. (user: drh branch: ssdsim
15:23
[d570e6cb38] part of check-in [317c80cba3] 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). (user: drh branch: trunk
01:50
[623242218008315d] part of check-in [9e6efcf054] 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. (user: drh branch: ssdsim
2012-09-21
22:50
[8ee5a3cb50] part of check-in [1be4b16b9e] 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. (user: drh branch: trunk
13:40
[f41fbf4c21] part of check-in [a1d8269da3] Command-line shell enhancements: Added the ".print" command. Enhanced the ".width" command so that negative widths will right-justify. (user: drh branch: trunk
2012-08-27
21:19
[87953c5d9c] part of check-in [24420d6d20] Add to #undef statements to the command-line shell, go make sure that the macros definitions that follow do not collide with system definitions. (user: drh branch: trunk
2012-06-27
16:41
[076e1c90d5] part of check-in [3b4f5add04] Another changes to the shell in support of SQLITE_OMIT_AUTOINIT. (user: drh branch: trunk
16:12
[88e34bc18c] part of check-in [95c0c995fd] Update the shell so that it works with SQLITE_OMIT_FLOATING_POINT and SQLITE_OMIT_AUTOINIT. (user: drh branch: trunk
2012-06-21
14:05
[74e47ddb99] part of check-in [d3d491a546] Merge several compiler compatibility fixes to trunk. (user: mistachkin branch: trunk
13:00
[d332251457] part of check-in [ff828c67e5] Remove support for OS/2 from the source tree. (user: drh branch: trunk
2012-06-18
08:00
[79cbf565f5] part of check-in [f970a3de61] Fix a few compilation issues that can occur with certain compilers (e.g. GCC 2.95.3, MSVC). (user: mistachkin branch: compiler-compat
2012-05-21
03:15
[c16f72e34f] part of check-in [e092ff69e2] 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]. (user: drh branch: trunk
2012-04-24
12:12
[04399b2f99] part of check-in [282f2a74c2] Fix a sign-extension problem for BLOB output in ".insert" mode of the command-line shell. (user: drh branch: trunk
2012-04-23
12:38
[151a17fe84] part of check-in [ce2d06e253] 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. (user: drh branch: trunk
2012-04-21
11:33
[dec1a1896f] part of check-in [feff1ef0b8] 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. (user: drh branch: trunk
2012-04-17
09:09
[11185a9a45] part of check-in [8e2363ad76] 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. (user: drh branch: trunk
2012-04-16
17:22
[5d2484bea2] part of check-in [020b5e90f9] Fix a bug in the command-line shell logic that attempts to continue with a ".dump" even after encountering database corruption. (user: drh branch: trunk
2012-04-11
11:38
[6fef5d2cd1] part of check-in [93a0f452a7] 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. (user: drh branch: trunk
2012-04-04
16:56
[ce4d415821] part of check-in [b9ac3d7e34] Add the ".trace" option to the command-line shell. (user: drh branch: trunk
2012-03-30
00:05
[abf18d6ee5] part of check-in [fa82062c65] In the ".output" command of the shell, if the first character of the output filename is '|' then use popen() instead of fopen(). (user: drh branch: trunk
2012-03-24
20:09
[3179db5d4f] part of check-in [30b8dd326d] Add SQLITE_DBSTATUS_CACHE_WRITE to the command-line shell. (user: drh branch: trunk
2012-03-22
12:50
[55e09ef712] part of check-in [638b711502] 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. (user: drh branch: trunk
2012-02-07
14:22
[92e96bf5e4] part of check-in [81ce52afb1] Port the command-line shell enhancements including the new --cmd option to the nx-devkit branch. (user: drh branch: nx-devkit
14:13
[aa28f11703] part of check-in [9497893b1b] 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. (user: drh branch: trunk
2012-01-28
21:08
[60d147c241] part of check-in [e6eea8d50d] 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. (user: drh branch: trunk
2012-01-16
16:56
[f492df9fc2] part of check-in [93aa17d866] Enhance the command-lin shell to interpret CSV files as described by the wikipedia article on CSV. (user: drh branch: trunk
2011-12-14
18:33
[aa4183d4a5] part of check-in [da118e02c0] Merge the nx-devkit changes into trunk. This includes the new SQLITE_FCNTL_VFSNAME file-control. (user: drh branch: trunk
17:53
[670644f7bd] part of check-in [cdbfb553af] Add a file-control that will discover the name of the bottom-level VFS and all the shims in between. (user: drh branch: vfsname-filectrl
2011-12-12
20:01
[183c4b6a84] part of check-in [c4e2ce4862] Backport a minimal set of changes needed to get 8+3 filenames and the multiplexor shim playing well together. (user: drh branch: nx-devkit
16:51
[ea9c11ae5d] part of check-in [9b2691aa91] Add magic comments to shell.c to make it easier for scripts to insert additional version information displays for custom builds. (user: drh branch: trunk
2011-12-06
19:44
[a1eadb2fdb] part of check-in [79ae51c5b1] Begin adding the data-structure explaining subsystem. All is contained within (user: drh branch: tree-explain
2011-11-09
16:12
[29812a900a] part of check-in [bc10a75357] Minor changes needed to restore full branch test coverage. (user: drh branch: experimental-pcache
2011-11-04
00:35
[6d2ad7f80a] part of check-in [b06bf3b360] Enhance the shell so that the ".schema" command works with case insensitive LIKE patterns even with PRAGMA cache_sensitive_like=ON. (user: drh branch: trunk
2011-10-14
21:49
[f0ab793261] part of check-in [60fee9574b] 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. (user: drh branch: trunk
2011-10-13
16:36
[e30e20107f] part of check-in [8bf13b036a] Provide a complete prototype for isatty() in the command-line shell sources. (user: drh branch: trunk
16:30
[2a1dc64d30] part of check-in [6df7343b4c] 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. (user: drh branch: trunk
16:02
[faba48cc0e] part of check-in [eeeba4f0d2] Enable large-file support for fopen() and friends in the command-line shell. Ticket [92af7da36b6fbd] (user: drh branch: trunk
13:34
[2a44834246] part of check-in [1c00d5454c] Do the ".dump" command inside of a transaction to prevent other processes from modifying the database while the dump is underway. Ticket [2466653295e65] (user: drh branch: trunk
00:41
[bef48bc4fa] part of check-in [8a8dcd6bd0] 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] (user: drh branch: trunk
2011-10-11
20:41
[a07ce148dc] part of check-in [b94a80a832] Put in code to defend against signed/unsigned character problems in the command-line shell. (user: drh branch: trunk
2011-09-28
01:10
[e8fe1251ae] part of check-in [f4dd32d30e] In the shell, allow arbitrary table names on the ".import" command. Ticket [d1d84037b90a449]. (user: drh branch: trunk
2011-09-23
18:58
[1d3baca339] part of check-in [d279e1a309] Add SQLITE_DBSTATUS_CACHE_HIT and _MISS to the ".stat" command in the shell. (user: drh branch: trunk
2011-09-16
20:16
[13fe2aeddc] part of check-in [690220717f] Silence harmless compiler warning about redefinition of the _CRT_SECURE_NO_WARNINGS macro by shell.c. (user: mistachkin branch: trunk
2011-07-08
17:02
[bbe7818ff5] part of check-in [e305b5a931] 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. (user: drh branch: trunk
2011-06-03
13:28
[0e0173b3e7] part of check-in [049c3c42fd] Include more detailed version information in the command-line shell output. (user: drh branch: trunk
2011-05-18
17:15
[decd04236a] part of check-in [de58cb2838] 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. (user: drh branch: trunk
2011-04-11
15:36
[72e7e176bf] part of check-in [73906b67dc] 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. (user: drh branch: trunk
2011-04-07
03:41
[9c83897967] part of check-in [748c9109c9] Fix a couple of MSVC compiler warnings; (user: shaneh branch: trunk
2011-04-05
22:08
[a73b30067e] part of check-in [3eeb0ff78d] Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. (user: drh branch: trunk
2011-03-23
11:16
[9dc0b4bb59] part of check-in [1ed5e361ca] In the shell, make sure the ".log" command has at least one argument. (user: drh branch: trunk
2011-03-17
16:45
[4a5e0ad845] part of check-in [54bacb95dd] 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. (user: drh branch: trunk
2011-03-16
17:05
[75ec746b96] part of check-in [baca45c549] Add the -vfstrace option to the usage error message in the shell. (user: drh branch: trunk
16:56
[1378c13b8a] part of check-in [f49a9ef338] Add the VFS-trace shim. (user: drh branch: trunk
2011-03-15
18:35
[ea40658271] part of check-in [725708465072f] Fix an out-of-order variable declaration in shell.c. (user: drh branch: trunk
2011-03-12
17:02
[54f8fe0afa] part of check-in [00051c3296] 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. (user: drh branch: unix-excl
2011-02-10
21:08
[649c519798] part of check-in [f85afa0ecc] Add .testctrl option to CLI. (user: shaneh branch: trunk
2010-12-21
21:28
[83c6f0cc5a] part of check-in [b0888047bb] 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. (user: drh branch: trunk
2010-12-17
14:03
[9afa9bdd62] part of check-in [74fff69234] Add the "-heap" option to the command-line shell - to allocate a fixed heap for use with SQLITE_ENABLE_MEMSYS5. (user: drh branch: trunk
2010-12-08
03:28
[ee5905fef7] part of check-in [925332c3d7] The command-line shell ignore errors in sqlite3_close() when shutting down. (user: drh branch: trunk
00:02
[7b429fc744] part of check-in [e474fd9e7f] Changes to the shell which should, in theory, allow it to work with libeditline as an alternative to libreadline. (user: drh branch: trunk
2010-07-28
17:36
[8517fc1f9c] part of check-in [ae89777e7f] Improve the accuracy of the Pager heap usage estimate. (user: drh branch: trunk
17:01
[cc1a4d200a] part of check-in [f9adf66ad5] Record the pcache allocation size statistics even for pcache overflow allocations. Adjust the wording on one of the stat output lines in the shell. (user: drh branch: trunk
16:05
[74c82a4ecf] part of check-in [419ce0ed89] Modify CLI to optionally display "stats". (user: shaneh branch: trunk
2010-05-06
20:19
[fd4ccdb37c] part of check-in [c1762dda00] Make sure to do a clean shutdown of the library upon existing the shell in order to remove WAL files. (user: drh branch: trunk
2010-03-03
14:23
[c40427c724] part of check-in [00e5679047] Modify the command line tool to disable all mutexes. The command line tool is single-threaded. (user: dan branch: trunk
2010-02-25
02:32
[546fe4b6df] part of check-in [46f406b202] 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. (user: drh branch: branch-3.6.22
2010-02-23
01:47
[31cd555125] part of check-in [6d910245ad] Add the ".log" command to the shell. This shows that some errors are logged multiple times and other errors are never logged at all. (user: drh branch: trunk
01:01
[285a9a83be] part of check-in [c4401fc93b] 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. (user: drh branch: trunk
2010-02-15
15:47
[56521a1725] part of check-in [c727601eec] Fix a compiler warning in shell.c. Updates to comments in trigger.c. (user: drh branch: trunk
2010-01-18
18:17
[d7408dbe4d] part of check-in [7080ae3bc3] Fix a problem with the CLI where not all SQL commands were being echoed. Added tests of same to tools/shell2.test. Ticket [eb620916be]. (user: shaneh branch: trunk
2010-01-05
04:59
[b95c5fcfe4] part of check-in [e5d07045fa] 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. (user: dan branch: trunk
2009-12-17
21:07
[b9fae60b0f] part of check-in [b1b48be1cf] 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. (user: shaneh branch: trunk
2009-11-11
04:17
[f4948cb6d3] part of check-in [09b4f19f10] 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]. (user: shaneh branch: trunk
2009-11-10
17:07
[360ed53f86] part of check-in [8097c64acf] Fix for datbase name being ignored with the -batch option in the CLI. Ticket [aeff892c57]. (user: shaneh branch: trunk
01:30
[0167e247de] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (user: drh branch: trunk
2009-11-06
17:20
[07e6265ead] part of check-in [9fb6991933] Improved shell "dot" command argument handling. Ticket [f12a9eeedc]. (user: shaneh branch: trunk
2009-10-24
02:06
[f66531a57f] part of check-in [e3898e25cf] In shell, modified to not print informational messages during startup while in "batch mode". Ticket [2cb66577f6]. (user: shane branch: trunk
02:00
[0e43ac51c4] part of check-in [7201244e67] 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]. (user: shane branch: trunk
2009-10-23
01:27
[19c86a22e3] part of check-in [1ebac9eddd] In shell, ensure that do_meta_command() returns consistent error values. Adjusted the text of some error message to be more consistent. Ticket [beb2dd69ad]. (user: shane branch: trunk
00:37
[4b1d54c6de] part of check-in [009efad0f4] In shell, modified "import" handling to ensure error code returned correctly on exit. Ticket [bd770b2c52]. (user: shane branch: trunk
2009-10-22
21:23
[3a2b064942] part of check-in [790402c150] In shell, reworked .header and .echo handling. Updated shell_exec() to (really) handle multiple statements. Tickets [72adc99de9], [7b61b6c6ce], and [eb620916be]. (user: shane branch: trunk
18:12
[5d875ff501] part of check-in [ab99faca6c] 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]. (user: shane branch: trunk
17:30
[47dc8e7189] part of check-in [a2ad9e6363] Updated shell to output blobs in X'1234' form when in "insert" mode. Ticket [72adc99de9]. (user: shane branch: trunk
2009-10-21
14:11
[9a9fab0d54] part of check-in [c8815fcd88] 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]. (user: shane branch: trunk
13:53
[9b242f44d9] part of check-in [c6f22f3e38] Made detectSchemaProblem function and aSchemaTable array static. Ticket [6f8b0c5855]. (user: shane branch: trunk
03:56
[98ce80c6d9] part of check-in [8a8eeb0c5a] 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]. (user: shane branch: trunk
03:42
[40364daed1] part of check-in [83216fbe90] 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]. (user: shane branch: trunk
2009-10-08
13:42
[270231b3f5] part of check-in [273ccbf18a] Fix a problem in the legacy genfkey code to do with column names that require quoting. (user: dan branch: trunk
2009-09-23
15:51
[d6e64471aa] part of check-in [0755b9b697] Modify the ".dump" command on the CLI so that it always issues a PRAGMA foreign_keys=OFF at the top of the output. (user: drh branch: trunk
2009-09-19
17:00
[d0171721c7] part of check-in [d5d3998118] Check in implementation of foreign key constraints. (user: dan branch: trunk
2009-05-31
17:16
[db2643650b] part of check-in [a028d69c70] Fix the ".genfkey" command of the CLI so that it does not leak memory if sqlite3_realloc() fails. Ticket #3891. (CVS 6696) (user: drh branch: trunk
2009-05-21
15:15
[7eacd0bdaa] part of check-in [bedd5ad194] 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) (user: drh branch: trunk
14:51
[7d20ab57ca] part of check-in [a0028d4808] In the CLI, always "dump" the sqlite_sequence table last. Ticket #3867 (CVS 6663) (user: drh branch: trunk
2009-03-16
10:59
[0a11f83160] part of check-in [324a1aff30] Remove surplus white space from shell.c. Use strlen30() instead of strlen(). (CVS 6346) (user: drh branch: trunk
2009-03-13
15:32
[de2fef6f71] part of check-in [943b11fb18] Do not overrun a buffer in the genfkey code (now part of shell.c). Fix for #3722. (CVS 6344) (user: danielk1977 branch: trunk
2009-03-05
03:48
[0e2ebb9fa5] part of check-in [5477833ec7] Removed compiler warnings from MSVC builds. Ticket #3701. (CVS 6335) (user: shane branch: trunk
2009-02-25
19:07
[0cada72035] part of check-in [48ee0e47e2] Move the new genfkey shell command out from within #ifdef _WIN32_ (CVS 6327) (user: drh branch: trunk
15:43
[6ffbdb812a] part of check-in [36d699660b] Remove genfkey.c. Change genfkey.README to talk about the new shell dot-command, not the old standalone genfkey program. (CVS 6326) (user: danielk1977 branch: trunk
15:22
[95ca116d85] part of check-in [0a59fb28b4] Add the 'genfkey' functionality to the sqlite3 shell. Accessed using a new dot-command - ".genfkey". (CVS 6325) (user: danielk1977 branch: trunk
2009-02-04
22:46
[f109ebbb50] part of check-in [e420a3cedc] Add "backup" and "restore" methods to the TCL interfaces and test cases to exercise those methods. (CVS 6260) (user: drh branch: trunk
20:55
[6c674a4a4c] part of check-in [003e1d6218] Add ".backup" and ".restore" commands to the CLI - implemented using the new backup API. (CVS 6259) (user: drh branch: trunk
2009-01-30
05:40
[8965cf0cd7] part of check-in [c74c78e4eb] Minor changes to remove a few MSVC compiler warnings at /W3. Ticket #3610. (CVS 6215) (user: shane branch: trunk
2009-01-14
23:38
[0d801ef653] part of check-in [7bc08bc719] Make some changes requested by Fedora. (CVS 6181) (user: drh branch: trunk
23:17
[fe2e3d4a83] part of check-in [6f6b638e44] Fix the shell so that the ".schema" command works regardless of the pragma settings. Ticket #3585. (CVS 6180) (user: drh branch: trunk
2008-12-18
22:25
[65d19f8996] part of check-in [dcc8935fa0] Fix the Oracle and MS-Sql command-line terminator logic in the CLI. Ticket #3544. (CVS 6041) (user: drh branch: trunk
2008-12-11
02:58
[60638e2fdf] part of check-in [72fd92bd67] Removed a few more harmless warnings from MSVC. (CVS 6018) (user: shane branch: trunk
2008-12-10
22:30
[255762876786e] part of check-in [715dcd52c1] Work to remove harmless MSVC compiler warnings. (CVS 6013) (user: shane branch: trunk
22:15
[4b9c41beb7] part of check-in [258722b617] Fix an issue with the new sqlite3Strlen30() introduced by check-in (6007). Additional casts for compiler warnings. (CVS 6011) (user: drh branch: trunk
19:26
[793aaebd80] part of check-in [c872d55493] 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) (user: drh branch: trunk
2008-12-08
18:27
[484bddeefa] part of check-in [6c0b2e7579] Fix a bug in win32 command-line client introduced during efforts to reduce the number of harmless compiler warnings (check-in (5982).) (CVS 5992) (user: drh branch: trunk
2008-12-05
17:17
[be9eeb5811] part of check-in [adedd697b4] Fix harmless compiler warnings. Improved comments in the query optimizer. (CVS 5982) (user: drh branch: trunk
2008-12-04
12:26
[838c745e7a] part of check-in [cb9c15431c] Fix a memory leak in the shell that occurs when a ".import" command fails. Ticket #3517 (CVS 5975) (user: drh branch: trunk
2008-11-17
08:05
[650d1a8740] part of check-in [f45a149363] Added support for vxworks >= 6.4; RTP mode tested, kernel mode untested. (CVS 5910) (user: chw branch: trunk
2008-11-11
18:55
[01835f435d] part of check-in [dacae20047] Send the "Incomplete SQL" error message of the CLI to stderr instead of stdout. Ticket #3476. (CVS 5885) (user: drh branch: trunk
00:30
[33ae5c8ce9] part of check-in [68662e3b48] 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) (user: drh branch: trunk
2008-08-11
19:12
[d83b578a8c] part of check-in [860babd841] Make the CLI more tolerant of malformed schemas by setting the writable_schema pragma prior to running the ".dump" command. (CVS 5554) (user: drh branch: trunk
2008-07-11
17:23
[4b835fe734] part of check-in [1041deb6ae] Tweak to the ".timer" command in the CLI to help it work better with GCC. (CVS 5398) (user: drh branch: trunk
2008-06-28
11:29
[484e7297e0] part of check-in [0ab0b030de] Added reminder message to terminate SQL statements with a semicolon on shell startup. This closes #3099. (CVS 5325) (user: mihailim branch: trunk
2008-06-26
10:41
[479807b87f] part of check-in [cdd4cf4ce2] 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) (user: danielk1977 branch: trunk
2008-06-23
21:26
[61fa61932e] part of check-in [bf2e283d6f] Reverted previous checkin (on second thought, changing case could break badly written homegrown parsers such as sometimes encountered in embedded firmware.) (CVS 5289) (user: mihailim branch: trunk
21:18
[3f3c184e2f] part of check-in [e07ed82caf] 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) (user: mihailim branch: trunk
2008-05-19
15:53
[a12ea64527] part of check-in [70793be63c] In the CLI, handle the compilation option -DOS_OS2=0 correctly. (CVS 5141) (user: drh branch: trunk
2008-05-05
16:27
[668ad97671] part of check-in [0bec7ebf41] Do not segfault in the CLI if sqlite3_open() fails to create a database connection object. Ticket #3096. (CVS 5084) (user: drh branch: trunk
2008-04-15
18:50
[be22ec05c8] part of check-in [cafa8ac268] Support UTF-8 filenames on OS/2 by converting them to and from the local codepage. Ticket 3052. (CVS 5014) (user: pweilbacher branch: trunk
2008-03-04
17:45
[22297fffa6] part of check-in [9c6694bb61] Various renames & cleanups to limit exported symbols on amalgamation build (CVS 4819) (user: mlcreech branch: trunk
2008-02-15
17:38
[c1ef4eb787] part of check-in [dedf5f230b] Fix a bug in the ".show" command of the CLI. Ticket #2942. (CVS 4792) (user: drh branch: trunk
2008-01-21
16:22
[ca06cb687c] part of check-in [720bc20a11] Miscellaneous test coverage improvements. (CVS 4734) (user: drh branch: trunk
2008-01-14
15:20
[0691a3d52d] part of check-in [187f41f54d] Fix for ticket #2883. (CVS 4711) (user: drh branch: trunk
2008-01-03
07:09
[5391e88938] part of check-in [b166c33a7b] Fix EXPLAIN and EXPLAIN query plan to work with new opcode format. (CVS 4662) (user: danielk1977 branch: trunk
2007-12-18
15:41
[77895a54c2] part of check-in [493a17c46a] In the CLI, quote strings that contain the separator character. Ticket #2850. (CVS 4638) (user: drh branch: trunk
2007-11-26
22:54
[c97be281cf] part of check-in [d0a4c2a363] Use macro __DARWIN__ rather than __MACOS__ for conditional compilation of MacOSX specific features. Ticket #2780. (CVS 4561) (user: drh branch: trunk
2007-11-12
21:09
[5b950381f6] part of check-in [8ad0ab8cb3] Various changes to enable compilation of SQLite library and command line shell with the Windows CE cross compiler from cegcc.sourceforge.net (CVS 4541) (user: chw branch: trunk
2007-11-02
12:53
[0b9dd90afc] part of check-in [56680360d3] Add the ".timer" command to the CLI. (CVS 4522) (user: drh branch: trunk
2007-09-07
01:12
[82089379833e] part of check-in [f780a17f4b] Modify the CLI so that it will ignore whitespace at the end of lines. Ticket #2631 (CVS 4412) (user: drh branch: trunk
2007-07-30
20:41
[ac29402b53] part of check-in [49a2e85511] Make excess output from the CLI appear inside SQL comments so as not to interfere with generated SQL. Ticket #2544. (CVS 4192) (user: drh branch: trunk
18:24
[d9e727be2c] part of check-in [271e27fd30] Get rid of the following compile-time warning: "src/shell.c:112: warning: 'iotracePrintf' defined but not used" (CVS 4188) (user: rse branch: trunk
2007-07-03
05:31
[e7534cce78] part of check-in [a008905b39] Fix a memory leak in shell.c. Reported on the mailing list. This has only been informally tested. (CVS 4153) (user: danielk1977 branch: trunk
2007-06-20
13:10
[4b0fc3c76a] part of check-in [6eaf29f5e1] Fix a bug in the command-line shell that prevents the reading of the ".sqliterc" file. Ticket #2433. (CVS 4100) (user: drh branch: trunk
2007-05-04
13:15
[d07ae326b3] part of check-in [ba4845b32b] 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) (user: drh branch: trunk
2007-05-03
17:18
[762c81655d] part of check-in [8a43e1676f] 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) (user: drh branch: trunk
2007-02-28
06:14
[3ae4654560] part of check-in [ceb3a07f55] Work around incompatibilities in the windows printf() routine within the new I/O tracing logic. (CVS 3666) (user: drh branch: trunk
04:47
[a7df003f26] part of check-in [007ca28389] 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) (user: drh branch: trunk
2007-01-08
14:31
[d13ca007cd] part of check-in [3a422bb9ee] Updates to the sqlite3 command-line shell documentation. Ticket #2144. (CVS 3573) (user: drh branch: trunk
2006-12-19
18:47
[f270a7996e] part of check-in [6f8a56231c] Fix a typo in shell.c. Ticket #2111. (CVS 3533) (user: drh branch: trunk
2006-11-20
16:21
[934cdcf67e] part of check-in [9fdc249609] Fix the ".dump" command in the shell. Ticket #2072. Also ticket #2065. (CVS 3515) (user: drh branch: trunk
2006-11-08
12:25
[41513f31dc] part of check-in [f39978ef13] Make the .exit and .quit commands work again in the shell. Ticket #2056. (CVS 3505) (user: drh branch: trunk
2006-10-31
18:08
[e5bda30849] part of check-in [ebd44f0b5e] Make the command-line shell ".dump" command more resilient in the face of database corruption. (CVS 3496) (user: drh branch: trunk
2006-10-27
14:21
[3cd7e8460d] part of check-in [58171a41f7] Fix the ".dump" command in the command-line shell so that it shows TRIGGERs and VIEWs. Ticket #2044. (CVS 3493) (user: drh branch: trunk
2006-10-26
18:15
[718c9dc51f] part of check-in [517712d6fb] 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) (user: drh branch: trunk
14:25
[73cbdcb3cd] part of check-in [3baa04cfb9] 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) (user: drh branch: trunk
2006-09-25
13:09
[1c17cd03c9] part of check-in [815d8f84b3] Remove legacy cruft from shell.c. (CVS 3439) (user: drh branch: trunk
2006-09-13
20:22
[672326e8d9] part of check-in [afd40184b7] Modify the ".dump" command in the command-line shell so that it works with virtual tables. (CVS 3416) (user: drh branch: trunk
2006-09-06
21:39
[233f7766e5] part of check-in [b3eb1732bd] Include io.h on Windows to quell a build warning about access() having no prototype. (CVS 3394) (user: adamd branch: trunk
2006-08-29
12:04
[3496a1b0a2] part of check-in [9763b4bfd5] Improved built-in help in the command-line shell. Enable the fulltext search extension in the TCL interface. (CVS 3372) (user: drh branch: trunk
2006-08-19
11:15
[bc41feffb5] part of check-in [10907bb201] Improved method for finding the home directory under windows. Ticket #1926. (CVS 3357) (user: drh branch: trunk
2006-07-28
20:16
[9e95f12ef5] part of check-in [47353f62ca] Report any error which occurs in closing the database at exit. Free a couple of strings which were leaking. (CVS 3340) (user: adamd branch: trunk
2006-06-27
20:39
[359551ab5c] part of check-in [9f13972b93] Better handling of NULL column names. (CVS 3317) (user: drh branch: trunk
15:16
[48d8e65784] part of check-in [4692319ccf] 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) (user: drh branch: trunk
2006-06-13
15:12
[ad73192b30] part of check-in [0bcec95963] Improved comments and documentation of sqlite3_load_extension(). (CVS 3229) (user: drh branch: trunk
2006-06-12
12:57
[55bf6335da] part of check-in [65c6e5e117] Patches to get things working better for OS2. Ticket #1836. (CVS 3217) (user: drh branch: trunk
2006-06-08
16:10
[b9eb3ed4d3] part of check-in [39e3427813] In the shell, make sure the database is opened before trying to do an ".import". Bug reported on the mailing list. (CVS 3209) (user: drh branch: trunk
15:28
[4f1e4a4d3e] part of check-in [4ca932d3ae] 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) (user: drh branch: trunk
2006-06-06
12:32
[087d388b25] part of check-in [fd0fae4835] Command "sqlite3 -version" returns 0 instead of 1. Ticket #1771. (CVS 3204) (user: drh branch: trunk
2006-06-03
17:37
[894d780d43] part of check-in [0eabda82cd] Do not record blank lines in the command-line editing history of the shell. (CVS 3197) (user: drh branch: trunk
2006-05-10
14:39
[1862fab6f7] part of check-in [364031d6e5] Out-of-memory checks added to tclsqlite.c and shell.c. Tickets #1805 and #1806. (CVS 3182) (user: drh branch: trunk
2006-03-19
13:00
[5cce3dabca] part of check-in [8ae6ccc715] Increase test coverage to above 98%. (CVS 3144) (user: drh branch: trunk
2006-03-06
20:55
[7a4b16f85d] part of check-in [e510e6dd9d] 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) (user: drh branch: trunk
2006-01-31
19:31
[738f55ed75] part of check-in [b922c8e45f] Fix some pointless warnings from overly-pedantic compilers. (CVS 3048) (user: drh branch: trunk
19:07
[fc75e0c956] part of check-in [1e68ac590d] 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) (user: drh branch: trunk
2006-01-25
15:55
[ea0e465454] part of check-in [e4e6a205e4] Rename files using for testing only so that their name begins with "test". (CVS 3028) (user: drh branch: trunk
2005-12-29
12:53
[66b073375e] part of check-in [1586921b54] Fix for ticket #1575. (CVS 2844) (user: drh branch: trunk
2005-12-09
14:25
[4872acee1d] part of check-in [601c335463] Many small changes to ensure memory is not leaked after malloc() fails. (CVS 2808) (user: danielk1977 branch: trunk
2005-09-11
02:03
[3596c1e559] part of check-in [3f191cf497] 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) (user: drh branch: trunk
2005-09-10
22:40
[bf574fc9d8] part of check-in [26565b8931] 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) (user: drh branch: trunk
2005-08-30
20:12
[b21daba017] part of check-in [528df777e5] The CSV output mode does not sign-extend bytes where the high-order bit is set. Ticket #1397. (CVS 2644) (user: drh branch: trunk
2005-08-29
23:06
[d2d4ef0473] part of check-in [71a71cef5b] Make the shell aware of SQLITE_OMIT_MEMORYDB. Ticket #1395. (CVS 2640) (user: drh branch: trunk
2005-08-27
01:50
[7fb744da45] part of check-in [dd3b00aa0b] Widen the opcode column of explain output in the shell. (CVS 2625) (user: drh branch: trunk
2005-08-05
18:50
[86c16f0d53] part of check-in [73fafd2148] Make sure the .import command strips newlines off the end of the last field in each line imported. Ticket #1348 (CVS 2578) (user: drh branch: trunk
2005-02-23
12:35
[25b3217d7c] part of check-in [4ae1a9fc2c] Remove strcasecmp from shell.c. Tickets #1108, #1122. (CVS 2359) (user: drh branch: trunk
2005-02-16
03:53
[46a1757c15] part of check-in [b82c06fdd1] 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) (user: drh branch: version_2
2005-02-03
00:42
[3cb0ef124e] part of check-in [76c4a96c5a] Fix the ".dump" command in the shell so that it works with AUTOVACUUM. This is related to ticket #1095. (CVS 2310) (user: drh branch: trunk
2005-01-23
23:43
[1f0da77ef0] part of check-in [0778383b6f] Modification to shell.c to avoid a compiler warning on some compilers. (CVS 2268) (user: danielk1977 branch: trunk
2005-01-13
11:10
[591364a0e9] part of check-in [2c7a1a1698] Fix typo in shell .help. Ticket #1071. (CVS 2206) (user: danielk1977 branch: trunk
2004-11-22
05:26
[e8f4f486cb] part of check-in [9df837c039] Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) (user: danielk1977 branch: trunk
2004-10-26
00:08
[55adda3cf3] part of check-in [507d8e6f5c] Fix a bug in the ".databases" command of the command-line shell. Ticket #973 (CVS 2030) (user: drh branch: trunk
2004-10-07
00:32
[2012beeea6] part of check-in [1376a0bb8d] In the command-line shell in CSV move, put strings in C-style double-quotes. Ticket #911. (CVS 2009) (user: drh branch: trunk
2004-10-06
14:39
[bfd23e7293] part of check-in [dcbf4817a7] 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) (user: drh branch: trunk
2004-09-24
12:50
[0856973c2b] part of check-in [1ee3a787ad] Fix typo in ".help" output from the shell. Ticket #914. (CVS 1978) (user: drh branch: trunk
2004-08-31
23:41
[4f1a2760ce] part of check-in [68a712f372] Changes to support compiling under windows. (CVS 1925) (user: drh branch: trunk
2004-08-30
01:54
[64932b37d7] part of check-in [d3f3acb77f] 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) (user: drh branch: trunk
2004-08-14
18:18
[42f65424a9] part of check-in [6b8178de99] The command-line shell should avoid writing changes into string constants. (CVS 1886) (user: drh branch: trunk
2004-08-08
20:22
[69d8036a88] part of check-in [b065973898] Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) (user: drh branch: trunk
2004-08-04
15:16
[4b40fac1a0] part of check-in [ed489f776a] In the command-line shell: importments to the "help" message and better error checking in the new .import command. (CVS 1877) (user: drh branch: trunk
2004-08-01
00:10
[7371f0a4b1] part of check-in [b56afe640f] Add the ".import" command to the command-line shell. (CVS 1873) (user: drh branch: trunk
2004-07-22
02:40
[93c96c8472] part of check-in [b77bec3574] Changes in support of using a codec. (CVS 1844) (user: drh branch: trunk
2004-06-30
08:20
[ebec5da57e] part of check-in [fa19c77bf0] Fixes for compiler warnings. Also more coverage. (CVS 1775) (user: danielk1977 branch: trunk
2004-06-19
09:08
[24b641700c] part of check-in [c49d8bdc3e] Make sure ATTACH and DETACH fail if a transaction is active. (CVS 1633) (user: danielk1977 branch: trunk
2004-06-08
00:39
[ca519519dc] part of check-in [97aa54bb70] Enhance the built-in function quote() to support blob values. (CVS 1541) (user: danielk1977 branch: trunk
00:02
[a70b41be03] part of check-in [62e31f396c] Remove the third argument from the sqlite3_open() API. (CVS 1540) (user: danielk1977 branch: trunk
2004-06-05
08:04
[79af86d39b] part of check-in [e82eb722b0] Ensure blob values survive the ".dump" command of the shell. (CVS 1531) (user: danielk1977 branch: trunk
2004-05-31
23:56
[a9e2ad8f6c] part of check-in [af8e2006d8] Remove the sqlite3_error_string() API. (CVS 1514) (user: danielk1977 branch: trunk
19:34
[cca774504c] part of check-in [f3b80bbb97] Change the name of the sqlite3_freemem API function to just sqlite3_free. (CVS 1512) (user: drh branch: trunk
18:23
[b71bdc3586] part of check-in [4c37b6d2b7] 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) (user: drh branch: trunk
2004-05-24
07:04
[ed4d237b3e] part of check-in [b7155db2b1] Have the vdbe handle strings in the same encoding as the database. (CVS 1445) (user: danielk1977 branch: trunk
2004-05-22
09:21
[657623c2a3] part of check-in [b449217318] Use the new form of the sqlite3_open() API everywhere. (CVS 1437) (user: danielk1977 branch: trunk
2004-05-14
11:00
[0c4662e13b] part of check-in [dbfe6e9316] Implement type affinity for table and index records (CVS 1375) (user: danielk1977 branch: trunk
2004-05-10
10:34
[255b8b9023] part of check-in [2242423e31] Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1338) (user: danielk1977 branch: trunk
2004-05-08
08:23
[9a242ad03c] part of check-in [8af6474c49] 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) (user: danielk1977 branch: trunk
2004-03-17
23:42
[920af040d3] part of check-in [85238f0690] Change the ".database" command in the shell to allocate more characters to the database name and filename. (CVS 1300) (user: drh branch: trunk
2004-03-09
13:37
[01fdfff666] part of check-in [b6817e99bd] The shell program now ignores extra whitespace at the end of dot-commands. (CVS 1288) (user: drh branch: trunk
2004-02-25
02:25
[b19e750ffc] part of check-in [114b72f860] Shell program saves command-line history on a ".quit". Ticket #614. (CVS 1270) (user: drh branch: trunk
2004-02-14
16:31
[c3d3404fa8] part of check-in [9771ad1e81] 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) (user: drh branch: trunk
2004-02-13
20:09
[60b33fe4b3] part of check-in [5a56090dde] Fix an uninitialized variable in shell.c that would cause a crash if you specified SQL on the command-line. (CVS 1238) (user: drh branch: trunk
2004-02-12
20:49
[f6975f8726] part of check-in [5fe8f02306] Add a new parameter to the (unimplemented) encryption API. (CVS 1234) (user: drh branch: trunk
2004-02-11
10:37
[c1c7242ede] part of check-in [95989717e1] Fix the shells so that they always enable the codec if it is available, even if no key is supplied. (CVS 1226) (user: drh branch: trunk
02:18
[514056d548] part of check-in [5200e9edc5] Pass all (relevant) regression tests when using the codec. (CVS 1223) (user: drh branch: trunk
2004-02-10
02:57
[77b1d34a21] part of check-in [9c6b4758a4] Make the pager accessible from the btree structure always, not just during debugging. (CVS 1219) (user: drh branch: trunk
2004-02-01
01:22
[a069d35277] part of check-in [3c796de8d1] Fix the handling of -init option to the sqlite shell. Ticket #568. Also add hooks for encrypting the database. (CVS 1206) (user: drh branch: trunk
2003-12-04
20:51
[3b067edc09] part of check-in [e5e6a8481b] Use sqlite_freemem() instead of free() in the shell. Windows needs this. (Unix does not care.) Ticket #444. (CVS 1125) (user: drh branch: trunk
2003-07-18
01:30
[c2ba26c850] part of check-in [558969ee86] 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) (user: drh branch: trunk
2003-06-16
00:16
[3ed268908f] part of check-in [bcf5eeecdf] Preserve blank lines in the middle of SQL statements in the shell. Ticket #352 (CVS 1026) (user: drh branch: trunk
2003-05-19
23:55
[b63089a91d] part of check-in [e8566cf5a3] Fix segfault that occurs when opening a non-existing database in the shell then immediately doing ".q". (CVS 986) (user: drh branch: trunk
2003-05-13
00:24
[2565cb32cd] part of check-in [6e5c497a42] Remove unnecessary "#include <sqliteInt.h>" from the shell code. (CVS 971) (user: drh branch: trunk
2003-05-11
20:07
[88305ca3d0] part of check-in [bad2065337] Changed ".databases" command to use PRAGMA database_list. (CVS 967) (user: jplyon branch: trunk
2003-05-04
18:30
[89a14538b4] part of check-in [5656fe48b1] Shell command-line parsing enhancements suggested by Mike Hall. (CVS 956) (user: drh branch: trunk
07:25
[c53ff46878] part of check-in [741a5a8d39] added shell command ".databases" to list name and file of open ones. (CVS 953) (user: jplyon branch: trunk
2003-04-30
11:38
[6f59240f69] part of check-in [20fcead42b] 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) (user: drh branch: trunk
2003-04-29
18:01
[4dc33c49cc] part of check-in [8211f57b38] 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) (user: drh branch: trunk
2003-04-26
03:03
[6557e37e6c] part of check-in [639957e9f7] Fix the shell tool to do a better job of ignoring whitespace. Ticket #234. (CVS 940) (user: drh branch: trunk
02:50
[137f4a1e3a] part of check-in [92ded93376] Only print the "Loading resources from..." line when the output is a TTY. Ticket #168. (CVS 939) (user: drh branch: trunk
2003-04-24
01:45
[e0b3da1f44] part of check-in [206b17397b] Fix some issues with INSTEAD OF triggers. (CVS 930) (user: drh branch: trunk
2003-04-17
22:57
[a0b7043713] part of check-in [1e5e00fb73] Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) (user: drh branch: trunk
02:54
[6980eadda7] part of check-in [35caefe317] 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) (user: drh branch: trunk
2003-04-03
19:35
[97f397c0c1] part of check-in [452128c6fd] Fix for ticket #276. (CVS 897) (user: drh branch: trunk
2003-03-30
19:17
[c13ff46e90] part of check-in [b6d6e07f3a] Remove the experimental sqlite_open_aux_file() API. It will soon be replaced by ATTACH and DETACH SQL commands. (CVS 889) (user: drh branch: trunk
2003-02-05
14:06
[0d260a007e] part of check-in [e21afb82b5] 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) (user: drh branch: trunk
2003-01-18
17:05
[cbb29252f0] part of check-in [32a8e6e977] Do not report an error if the input to the sqlite shell ends in a comment. Ticket #211. (CVS 838) (user: drh branch: trunk
2003-01-08
13:02
[c9946847b8] part of check-in [13f82d67f6] Port ot MacOS Classic. Ticket #218. (CVS 820) (user: drh branch: trunk
2002-11-11
13:56
[53185af128] part of check-in [dc5d9c129c] Remove extra from HTML output. Ticket #189. (CVS 786) (user: drh branch: trunk
2002-08-21
11:26
[9e9a6eb6bc] part of check-in [ea011990c5] Fix for ticket #137: Use getpwuid() instead of getpwent(). (CVS 723) (user: drh branch: trunk
2002-07-13
17:33
[37a8405aec] part of check-in [e1842e04c4] Fix for ticket #64: Better error reporting in the shell. (CVS 676) (user: drh branch: trunk
2002-07-10
21:26
[16cb2db27f] part of check-in [ff8b6f4ee8] 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) (user: drh branch: trunk
2002-06-25
19:31
[0b06e4421d] part of check-in [332164d645] Add the sqlite_open_aux_file() API. (CVS 646) (user: drh branch: trunk
01:09
[7b9d98ef39] part of check-in [9c1432bf74] Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) (user: drh branch: trunk
2002-05-21
13:02
[1d22fe870e] part of check-in [f795afd63f] 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) (user: drh branch: trunk
2002-04-21
19:06
[5acbe59e13] part of check-in [8a50c57cc3] 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) (user: drh branch: trunk
2002-04-19
12:34
[c0800304c9] part of check-in [ca4abf3fe1] Add support for saving the sqlite shell command-line history across sessions. (CVS 536) (user: drh branch: trunk
01:00
[56ed7250b2] part of check-in [6c32c07e82] Added rights release for Matthew O. Persico (CVS 535) (user: persicom branch: trunk
2002-04-18
12:39
[4a225aa846] part of check-in [0582168b8b] 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) (user: drh branch: trunk
02:53
[e473e19509] part of check-in [4bdd040e48] Mistake in help text. Spurious trailing whitespace removed. (CVS 532) (user: persicom branch: trunk
02:46
[33e2574f36] part of check-in [e751338c46] 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) (user: persicom branch: trunk
2002-04-13
23:42
[66bf0478c3] part of check-in [7edd13468e] When doing a ".dump" command in the command-line shell, make sure VIEWs are created after TABLEs. (CVS 529) (user: drh branch: trunk
2002-04-08
02:42
[994ca7c8c4] part of check-in [760bf568c8] Add a -column option to the sqlite command-line utility. Patch from Matthew O. Persico. (CVS 522) (user: drh branch: trunk
2002-04-04
15:10
[cf57c66e6c] part of check-in [932274187e] 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) (user: drh branch: trunk
2002-03-03
23:06
[b345422959] part of check-in [813077623087f] More bugs fixed for views. (CVS 416) (user: drh branch: trunk
2002-02-26
23:24
[9f8249ca5b] part of check-in [f2310f36d5] Fix a bug in the quoting of .dump output. By Rajit Singh. (CVS 394) (user: drh branch: trunk
2002-02-21
02:25
[cbf48bf0ca] part of check-in [ffb00bf36a] Do not allow dot-commands to occur in the middle of a real SQL command. (CVS 385) (user: drh branch: trunk
2002-01-24
00:00
[c102dfe388] part of check-in [5f8c097ebe] Do not escape the backslash character in shell output. (CVS 353) (user: drh branch: trunk
2002-01-22
12:39
[a77f9f1fad] part of check-in [593c986f69] Fix a bug in the -separator command-line option. (CVS 351) (user: drh branch: trunk
2002-01-15
18:39
[539a41d412] part of check-in [f8a026a3ca] Added implementations for sqliteOsEnterMutex() and sqliteOsLeaveMutex(). (CVS 348) (user: drh branch: trunk
2002-01-06
17:07
[f8008f0607] part of check-in [9b0be4fcc1] Comment updates most. Also some small changes to the VDBE. (CVS 339) (user: drh branch: trunk
2001-11-25
13:18
[407095aaee] part of check-in [653f37c365] Add the ability to do a single .command as the second argument to the command-line shell. (CVS 321) (user: drh branch: trunk
2001-11-24
00:31
[175f4e9422] part of check-in [fc2aae0457] Fix comparison functions so that they are consistent with the order of elements in indices. Fix the handling of large integers. (CVS 317) (user: drh branch: trunk
2001-11-09
22:41
[18e9f1cac7] part of check-in [6e7e7dbf8e] Minor bugs fixed. (CVS 307) (user: drh branch: trunk
2001-10-19
16:44
[71597951753b] part of check-in [8467d84fc6] Version 2.0.6 (CVS 291) (user: drh branch: trunk
2001-10-06
16:33
[cb8c41f1b2] part of check-in [b63b3f3684] Adding table column query capability to support ODBC. (CVS 278) (user: drh branch: trunk
2001-10-01
14:29
[cd2ae9f22d] part of check-in [20382325c7] The .dump output uses INSERT instead of COPY now. Expression syntax of the form "expr NOT NULL" is now supported. (CVS 276) (user: drh branch: trunk
2001-09-27
15:11
[977ec6b647] part of check-in [116fdad068] Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) (user: drh branch: trunk
2001-09-16
00:13
[8e57313807] part of check-in [4e926efe2b] Disclaimed copyright. Preparing for release 2.0. (CVS 250) (user: drh branch: trunk
2001-09-13
13:46
[1fcdf8c418] part of check-in [6ecc8b20d4] 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) (user: drh branch: trunk
2001-04-11
14:28
[d9c6441876] part of check-in [86b30cd097] better handling of out-of-memory errors (CVS 207) (user: drh branch: trunk
2001-04-04
21:22
[c1785b4af1] part of check-in [490d08a8c1] Clean up some compiler warnings (CVS 200) (user: drh branch: trunk
2001-01-04
14:27
[441e20913c] part of check-in [5ddeeb4771] :-) (CVS 174) (user: drh branch: trunk
14:20
[2188df591e] part of check-in [d49e10fb5e] :-) (CVS 171) (user: drh branch: trunk
2000-10-16
22:06
[146149928c] part of check-in [f7ea08b931] Added an interrupt capability (CVS 153) (user: drh branch: trunk
2000-10-08
22:20
[ef5d12129c] part of check-in [f9372072a6] Added the _printf() interface. (CVS 150) (user: drh branch: trunk
2000-09-29
13:30
[3d25f6709c] part of check-in [e11f7527f9] :-) (CVS 147) (user: drh branch: trunk
2000-08-28
16:21
[f1ef4268c6] part of check-in [b8cec9b938] adding length() and substr() tests. fix shell.c bug (CVS 144) (user: drh branch: trunk
2000-08-22
13:40
[061186b1a4] part of check-in [c6b71d9b4b] :-) (CVS 138) (user: drh branch: trunk
13:27
[9bbb37f344] part of check-in [5f6559ee7b] :-) (CVS 137) (user: drh branch: trunk
2000-08-17
09:50
[0aabf9e5e8] part of check-in [897b4bc0e9] allow readonly access when write permission denied (CVS 131) (user: drh branch: trunk
2000-08-08
20:19
[cd560887be] part of check-in [2b3511eca7] Add pattern matching to the .table command (CVS 129) (user: drh branch: trunk
2000-08-02
13:47
[2fd3708387] part of check-in [b7b9023794] file format change (CVS 122) (user: drh branch: trunk
2000-07-31
11:57
[a5eb8ee9d5] part of check-in [69b73ea3a0] fix a configuration problem on TAC-4 (CVS 113) (user: drh branch: trunk
2000-07-29
13:20
[3fd7424c80] part of check-in [57022a9d50] better column names in the shell (CVS 111) (user: drh branch: trunk
2000-07-28
14:32
[ffcb11569f] part of check-in [4fe8e51c24] added the sqlite_busy_handler() interface (CVS 109) (user: drh branch: trunk
2000-06-21
13:59
[8387580e44] part of check-in [e1bf96a467] :-) (CVS 104) (user: drh branch: trunk
2000-06-15
16:49
[78a35607a8] part of check-in [ac38f460c8] :-) (CVS 99) (user: drh branch: trunk
15:57
[082feaeb88] part of check-in [f26d0cdf45] :-) (CVS 98) (user: drh branch: trunk
2000-06-07
02:04
[3f4afc39a3] part of check-in [fc8d25ea1f] :-) (CVS 68) (user: drh branch: trunk
01:33
[9c9813926f] part of check-in [8bff1bee63] :-) (CVS 67) (user: drh branch: trunk
01:27
[23d9700d08] part of check-in [5d2e72e4bd] :-) (CVS 66) (user: drh branch: trunk
00:12
[a2a2c5c6d9] part of check-in [80ee166ed1] :-) (CVS 65) (user: drh branch: trunk
2000-06-05
02:07
[5fa24c0bb6] part of check-in [1cf2873d55] :-) (CVS 50) (user: drh branch: trunk
2000-06-04
12:58
[d184aeae4b] part of check-in [6ea5cebf05] rework the VDBE engine. NULL is now distinct from "" (CVS 49) (user: drh branch: trunk
2000-06-02
13:27
[bd658f9208] part of check-in [2b55f9b790] :-) (CVS 37) (user: drh branch: trunk
2000-05-31
23:33
[9a42923e9c] part of check-in [9b8458bbce] :-) (CVS 30) (user: drh branch: trunk
02:27
[c5752d32cd] part of check-in [01d85b35e9] :-) (CVS 20) (user: drh branch: trunk
2000-05-30
18:45
[3ffa905951] part of check-in [97a0fb780e] loads the complete ACD database! (CVS 17) (user: drh branch: trunk
2000-05-29
17:44
[125f84ea5f] part of check-in [53841c66c6] :-) (CVS 2) (user: drh branch: trunk
14:26
Added [de770d16aa] part of check-in [6f3655f79f] initial check-in of the new version (CVS 1) (user: drh branch: trunk