SQLite
File History
Not logged in

History of files named src/shell.c

2014-10-01
01:52
[801af09adf] part of check-in [2695772c98] Merge the latest enhancements from trunk. (user: drh branch: sessions)
01:46
[38f627b088] part of check-in [2078454ac9] Merge the latest enhancements from trunk. (user: drh branch: apple-osx)
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
23:08
[dad23987c3] part of check-in [3967ebe83e] Merge in all recent changes from trunk. (user: drh branch: apple-osx)
22:49
[85aae71dcc] part of check-in [6406b77f2c] Merge all recent trunk changes into the sessions branch. (user: drh branch: sessions)
22:31
[dad23987c3] part of check-in [d5880abd63] Correctly handle an ORDER BY clause on an outer query when applying the compound-subquery flattening optimization. Ticket [d11a6e908f]. Also add the SQLITE_ENABLE_SELECTTRACE option for additional debugging and analysis information about select statement processing. (user: drh branch: trunk)
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-15
15:34
[c00220cdd7] part of check-in [55b8011d5b] Merge latest trunk changes with this branch. (user: dan branch: experimental-bulk-update)
2014-09-11
17:27
[c00220cdd7] part of check-in [65884d4f81] Add the SQLITE_USER_AUTHENTICATION extension to the trunk. This extension is disabled by default. Special compilation procedures are need to enable it. (user: drh branch: trunk)
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:57
[713cef4d73] part of check-in [696dc935f7] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
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-26
02:02
[728d222659] part of check-in [5c27311105] Merge recent performance enhancements and the CAST operator enhancements into the apple-osx branch. (user: drh branch: apple-osx)
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:08
[1761e117dd] part of check-in [31addb627f] Add the "changeset" command-line tool for analyzing and manipulating changesets in files on disk. Add the ".session" command to the command-line tool. (user: drh branch: sessions)
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:48
[41df110361] part of check-in [419d286a2f] Merge the latest trunk changes, and in particular the refactoring of the object names in the command-line shell. (user: drh branch: sessions)
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)
13:39
[75bb7bd2c8] part of check-in [08058df3af] Merge the pre-3.8.6 changes from trunk into the apple-osx branch. (user: drh branch: apple-osx)
2014-08-13
14:43
[75bb7bd2c8] part of check-in [d49455d9a9] Merge the trunk changes for 3.8.6 beta3 into the sessions branch. (user: drh branch: sessions)
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)
16:43
[191129c3f7] part of check-in [3810dc62d2] Merge recent trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
16:23
[191129c3f7] part of check-in [a9db017eab] Merge recent trunk changes into the sessions branch. (user: drh branch: sessions)
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)
20:02
[56de2dfa3f] part of check-in [a5d94eaba6] Merge the latest trunk enhancements into the sessions branch. (user: drh branch: sessions)
19:57
[56de2dfa3f] part of check-in [f426876fe1] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
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)
12:53
[98ce7f5244] part of check-in [2dbdfa5170] Merge in the 3.8.5 release changes and the FTS integrity-check fix. (user: drh branch: apple-osx)
2014-06-03
20:09
[98ce7f5244] part of check-in [09e75d82d0] Merge the 3.8.5 release candidate changes into the sessions branch. (user: drh branch: sessions)
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:36
[33f6c0bc0e] part of check-in [b9fad4490c] Merge trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
20:29
[33f6c0bc0e] part of check-in [9f18e78f03] Merge trunk changes into the sessions branch. (user: drh branch: sessions)
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)
20:08
[bfac06fb15] part of check-in [54b5fa77e9] Merge recent trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
20:00
[bfac06fb15] part of check-in [a769c7e03e] Merge recent trunk changes into the sessions branch. (user: drh branch: sessions)
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-05-08
23:01
[2afe7a7154] part of check-in [9411d7dc6f] Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. (user: drh branch: apple-osx)
2014-05-02
21:42
[2afe7a7154] part of check-in [598a3875ce] Merge updates from trunk. (user: mistachkin branch: winIoRetry)
21:38
[2afe7a7154] part of check-in [c4d1d8a0db] Merge updates from trunk. (user: mistachkin branch: winHdr)
2014-04-24
15:06
[2afe7a7154] part of check-in [6077ddcd93] Reopen the orderby-planning branch and merge in the latest trunk enhancements and fixes. (user: drh branch: orderby-planning)
2014-04-18
12:38
[6946aea9f2] part of check-in [8729aa3e3e] Merge recent trunk changes into the threads branch. (user: drh branch: threads)
01:14
[2afe7a7154] part of check-in [d9eef5b03c] Merge the latest changes from sessions. (user: drh branch: rtree-enhancements)
01:10
[2afe7a7154] part of check-in [95e77efe07] Merge recent trunk changes into sessions. (user: drh branch: sessions)
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-14
19:23
[b44c3f17f0] part of check-in [cb0ab20c48] Allow the sorter to begin returning data to the VDBE as soon as it is available, instead of waiting until all keys have been sorted. (user: dan branch: threads)
2014-04-11
19:43
[b44c3f17f0] part of check-in [98bf0307b1] Avoid having the sorter merge too many PMAs at a time when incrementally merging data following a SorterRewind(). (user: dan branch: threads-experimental)
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)
16:35
[5260f2ada8] part of check-in [9515c8344a] Merge all recent changes from trunk, including the fix for the OP_SCopy-vs-OP_Copy problem. (user: drh branch: sessions)
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-31
22:03
[cee9f46f26] part of check-in [f6211540c9] Merge in the latest changes and fixes from trunk. (user: drh branch: overflow-pgno-cache)
2014-03-26
19:43
[cee9f46f26] part of check-in [fc8ca1a87e] Merge in fixes (including the corrupt-database crash fix) and performance enhancements from trunk. (user: drh branch: sessions)
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)
13:17
[cee9f46f26] part of check-in [b415dfb6cb] Merge all fixes and enhancements from trunk. (user: drh branch: threads)
2014-03-20
20:56
[cee9f46f26] part of check-in [eca35871c3] Merge trunk fixes for "x IN (?)" handling. (user: drh branch: orderby-planning)
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-13
15:41
[bab4de12b4] part of check-in [d17231b63d] Merge latest trunk changes into this branch. (user: dan branch: threads)
2014-03-06
13:48
[bab4de12b4] part of check-in [1ed463d918] Merge the latest 3.8.4 tweaks from trunk. (user: drh branch: sessions)
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-03-04
14:34
[7bf07bcacb] part of check-in [7f51ad97f0] Merge the performance enhancements of trunk (and some obscure bug fixes) into the sessions branch. (user: drh branch: sessions)
2014-03-01
19:45
[7bf07bcacb] part of check-in [9c1747b5de] Merge trunk changes. (user: dan branch: experimental)
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
20:52
[bf75ce6bea] part of check-in [8f30b09518] Merge in latest trunk changes. (user: dan branch: experimental)
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)
05:47
[ca2b066ab3] part of check-in [ed0bfcfadc] Merge updates from trunk. (user: mistachkin branch: winIoRetry)
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-21
10:48
[3dd86bf73c] part of check-in [09cf240a7f] Merge updates from trunk. (user: mistachkin branch: winHdr)
2014-02-12
14:43
[3dd86bf73c] part of check-in [4d7057c494] Merge latest trunk changes. (user: dan branch: deferred-open)
2014-02-11
16:31
[3dd86bf73c] part of check-in [2cd35ff651] Sync with trunk. Bring in the command-line shell updates and the new 3.8.4 version number. (user: drh branch: sessions)
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)
04:30
[7dedf7367e] part of check-in [b006792695] Sync the latest trunk changes, and in particular the STAT4 IS NOT NULL fix. (user: drh branch: sessions)
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-24
14:05
[24722d24d4] part of check-in [9b43e55919] Bring in all the latest trunk changes, including the Common Table Expressions implementation. (user: drh branch: sessions)
2014-01-22
18:16
[24722d24d4] part of check-in [b6cea42006] Change the WITH RECURSIVE implementation to use a queue instead of a pair of tables. Add support for ORDER BY, LIMIT, and OFFSET on recursive queries. (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-16
04:37
[9f3bc02a65] part of check-in [7f953b568b] Merge trunk changes. Fix a possible NULL-pointer deference in WITH clause name resolution. (user: drh branch: common-table-expr)
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-24
12:09
[a3541193d5] part of check-in [cfd110bf5d] Merge the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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-14
18:24
[18924f6ccf] part of check-in [32477642d7] Merge in all recent preformance enhancements from trunk. (user: drh branch: sessions)
2013-12-11
14:17
[18924f6ccf] part of check-in [9ff4dfe1e3] Merge in the latest trunk changes. (user: drh branch: zipvfs-multifile-commit)
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
21:53
[936a72ff78] part of check-in [3a2a1bd478] Merge all recent trunk changes. (user: drh branch: sessions)
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-26
18:00
[c4d06a9238] part of check-in [fc9ae83956] Merge in performance enhancements from trunk. (user: drh branch: sessions)
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:30
[b98e74123d] part of check-in [cd579727b1] Merge EXPLAIN fixes from trunk. (user: drh branch: expr-codegen-enhancement)
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)
19:18
[6ccc22b717] part of check-in [7596d1bf80] Merge the skip-scan optimization into the sessions branch. (user: drh branch: sessions)
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
20:46
[6ccc22b717] part of check-in [b0bb975c09] Merge the skip-scan enhancement into trunk. (user: drh branch: trunk)
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-11-11
22:55
[03d8d9b405] part of check-in [5addd1234d] Merge in the WITHOUT ROWID changes. A few tests are failing now. They will be fixed in a follow-on check-in. (user: drh branch: sessions)
2013-11-01
17:21
[03d8d9b405] part of check-in [dd5d57b9a1] Merge all changes from trunk, and disable a pair of corruption tests that are no longer valid since sqlite_master.rootpage can now be NULL for tables. (user: drh branch: omit-rowid)
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-28
22:47
[d5eebdc603] part of check-in [aa72ea8a00] Merge all trunk changes since 3.8.1 into the sessions branch. (user: drh branch: sessions)
22:39
[d5eebdc603] part of check-in [9f8191d1d8] Merge recent fixes from trunk. (user: drh branch: omit-rowid)
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-15
14:10
[6f11f0e9de] part of check-in [e111e4edf9] Merge the latest trunk changes into the sessions branch. This merge should fix the build for WinRT. (user: drh branch: sessions)
2013-10-12
23:39
[6f11f0e9de] part of check-in [a88b5be01e] Merge updates from trunk. (user: mistachkin branch: toTypeFuncs)
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-10
20:13
[5ee50ca3e3] part of check-in [136445ba02] Synchronize with the trunk. (user: drh branch: sessions)
2013-10-01
20:10
[5ee50ca3e3] part of check-in [65d9c6fafb] Merge trunk changes with this branch. (user: dan branch: fts4-docid-range-constraints)
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-12
00:40
[d920a891ca] part of check-in [fca799f03a] Merge updates from trunk. (user: mistachkin branch: vsix2013)
2013-09-06
22:27
[d920a891ca] part of check-in [8922be1a3e] Merge updates from trunk. (user: mistachkin branch: toTypeFuncs)
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
15:08
[dbe064d404] part of check-in [e7ebc8f74f] Merge from trunk: (1) Recent bug fixes (2) STAT4 support (3) win32-longpath support. (user: drh branch: sessions)
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:56
[dbe064d404] part of check-in [ffc6e68283] Merge updates from trunk. (user: mistachkin branch: toTypeFuncs)
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-20
13:02
[1c317a4c96] part of check-in [3e4033285d] Merge performance enhancements and compiler warning fixes from trunk. (user: drh branch: sessions)
2013-08-19
14:23
[1c317a4c96] part of check-in [753a402e90] Remove unused variables from the command-line shell sources. (user: drh branch: trunk)
12:49
[909f6c4a52] part of check-in [67587a3348] Merge in all the latest updates and enhancements from trunk. (user: drh branch: sessions)
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)
18:07
[927e17b37b] part of check-in [c78b0d302c] Merge in the latest changes from trunk. (user: drh branch: uri-enhancement)
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:52
[927e17b37b] part of check-in [69d5bed017] Merge in the latest changes from trunk. (user: drh branch: sessions)
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-08-02
20:44
[52f975eae8] part of check-in [7e1acb3907] Merge in the latest trunk changes, including partial indexes, the MAX_PATH fix in os_win.c, and the sqlite3_cancel_auto_extension() API. (user: drh branch: sessions)
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-20
00:39
[7da98ff9cb] part of check-in [dd4b77c82a] Merge updates from trunk. (user: mistachkin branch: toTypeFuncs)
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-07-09
13:05
[c8cd06e6b6] part of check-in [af3ca4c6e5] Pull in all the latest changes from trunk. (user: drh branch: sessions)
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)
13:31
[a02544af66] part of check-in [086a127236] Bring the sessions branch up-to-date with all the latest trunk changes. (user: drh branch: sessions)
13:22
[a02544af66] part of check-in [bd4267f17b] Add the SQLITE_STMTSTATUS_VM_STEPS option for sqlite3_stmt_status(). (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-06-21
18:32
[ab6eea968c] part of check-in [fa2a91e6c6] Merge updates from trunk. (user: mistachkin branch: toTypeFuncs)
2013-06-03
12:47
[ab6eea968c] part of check-in [3bd5ad095b] Enhance the shell to provide more flexibility when entering numeric arguments on dot-commands. In particular, allow hexadecimal arguments to .wheretrace and .testctrl commands. Cherrypick from b9578c371ee5. (user: drh branch: trunk)
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
13:55
[9a18124ff2] part of check-in [7c8f992c04] Merge the latest trunk changes into the NGQP branch. (user: drh branch: nextgen-query-plan-exp)
11:57
[9a18124ff2] part of check-in [9e2c17c535] Fix harmless compiler warnings in the shell. (user: drh branch: trunk)
2013-05-15
08:00
[2109d54f67] part of check-in [6fbad95725] Merge updates from trunk. (user: mistachkin branch: toTypeFuncs)
2013-05-10
02:11
[2109d54f67] part of check-in [5ed31c8279] Merge in the latest trunk changes. (user: drh branch: nextgen-query-plan-exp)
2013-05-08
18:50
[2109d54f67] part of check-in [ae6c4a0906] Merge all recent trunk changes into the sessions branch. (user: drh branch: sessions)
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-05-03
18:29
[5d527e5d08] part of check-in [3879ab1b53] Merge all recent trunk changes into the sessions branch. (user: drh branch: sessions)
2013-04-26
06:58
[5d527e5d08] part of check-in [4d08e74d34] Merge latest trunk changes. (user: dan branch: fts3-expr-rebalance)
2013-04-25
16:52
[5d527e5d08] part of check-in [bbe607c7d1] Merge the std-ext branch into trunk. This merge adds several new extensions to the ext/misc folder, including transitive_closure, ieee754, and amatch, and it converts some older src/test_*.c file into extensions in the ext/misc folder. (user: drh branch: trunk)
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-22
23:59
[aca9d94653] part of check-in [6994826c07] Merge the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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-04
00:40
[319b7791ce] part of check-in [fff2be6077] Try to use mmap() to speed access to the database file on windows, linux, and mac. (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-03-06
02:12
[7c41bfcd9e] part of check-in [d69d21903b] Merge all the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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-02-13
13:42
[266791241d] part of check-in [7e14dc734d] Enhancements to the query planner to make use of indices for ORDER BY even when IN constraints are in the WHERE clause. Add extended error codes for all SQLITE_CONSTRAINT errors. (user: drh branch: sessions)
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)
02:10
[af0309c249] part of check-in [82d3d1ae82] Enhancements to the query planner to exploit transitive relationships in the WHERE clause, and other minor changes to bring the sessions branch into alignment with the trunk. (user: drh branch: sessions)
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)
2013-01-07
17:31
[11c9611580] part of check-in [bf90f1fbf8] Merge updates from trunk. (user: mistachkin branch: configReadOnly)
2013-01-03
22:22
[11c9611580] part of check-in [7e068e39b3] Merge recent trunk changes into the sessions branch. (user: drh branch: sessions)
2013-01-02
12:29
[11c9611580] part of check-in [a5f4d2b641] Merge all the latest trunk changes into the name-resolution enhancement branch. (user: drh branch: name-resolution-fix)
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-14
15:54
[e392dd1ccb] part of check-in [6d507e4de9] Merge in all the trunk changes that have occurred since this branch was opened. (user: drh branch: vtab-IN-opt)
2012-12-08
23:37
[e392dd1ccb] part of check-in [4f6d69ae94] Pull the latest trunk changes into the sessions branch, and in particular the collating-sequence refactorization. (user: drh branch: sessions)
06:46
[e392dd1ccb] part of check-in [e65db42c9f] Merge updates from trunk. (user: mistachkin branch: configReadOnly)
2012-12-04
00:59
[e392dd1ccb] part of check-in [487ba75313] Improvements to the 'tcl' shell output mode. Escape doublequotes, set separator to space when mode is set, and skip separator after final column. (user: drh branch: trunk)
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-30
21:03
[24cd0aa74a] part of check-in [fce667f2d9] Pull all the latest trunk enhancements into the sessions branch. (user: drh branch: sessions)
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-28
13:05
[8ee5a3cb50] part of check-in [6ca8eae1f8] Merge the latest trunk changes (especially "PRAGMA busy_timeout" and the ORDER BY query planner optimizations) into the sessions branch. (user: drh branch: sessions)
10:57
[8ee5a3cb50] part of check-in [6a5c59dd7e] Merge the latest trunk changes (PRAGMA busy_timeout and the ORDER BY query planner enhancements) into the apple-osx branch. (user: drh branch: apple-osx)
2012-09-25
12:45
[8ee5a3cb50] part of check-in [4a470741b6] Merge updates from trunk. (user: mistachkin branch: configReadOnly)
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-31
14:23
[87953c5d9c] part of check-in [87995dc940] Update with latest trunk changes. (user: dan branch: sessions)
14:10
[87953c5d9c] part of check-in [bc9b9cd058] Merge in latest trunk changes. (user: dan branch: apple-osx)
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-08-25
01:38
[076e1c90d5] part of check-in [6723add4f4] Merge all the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
2012-08-15
16:21
[076e1c90d5] part of check-in [fc07a4795e] Merge all the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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-06-05
19:20
[c16f72e34f] part of check-in [42338e9e69] Merge the latest trunk changes into shared-schema branch. Also fix a C99-ism in that branch. (user: drh branch: shared-schema)
2012-05-22
17:39
[c16f72e34f] part of check-in [b9ed0b26de] Merge the 3.7.12.1 trunk changes into the WinRT branch. (user: drh branch: winrt)
13:11
[c16f72e34f] part of check-in [972e75bb5d] Version 3.7.12.1 (user: drh branch: apple-osx)
13:01
[c16f72e34f] part of check-in [d07b7b67d1] Version 3.7.12.1 (user: drh branch: sessions)
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-05-05
01:03
[04399b2f99] part of check-in [2a99c0074a] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
2012-05-04
23:31
[04399b2f99] part of check-in [0f347fbfc7] Update the sessions branch with all the latest changes from trunk. (user: drh branch: sessions)
23:11
[04399b2f99] part of check-in [be4ab188cf] Sync the latest trunk changes into the winRT branch. (user: drh branch: winrt)
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-19
20:43
[11185a9a45] part of check-in [b72f07b4a2] Update the apple-osx branch so that it includes all of the latest trunk changes. (user: drh branch: apple-osx)
2012-04-18
05:57
[11185a9a45] part of check-in [ad5cd15f49] Import all the latest trunk changes into the WinRT branch. Refactor and/or remove WinCE-specific macros and functions used for file locking to improve clarity of presentation. (user: mistachkin branch: winrt)
01:41
[11185a9a45] part of check-in [87a0eab5d9] Import all the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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-31
02:46
[abf18d6ee5] part of check-in [18ec60cacd] Merge all the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
2012-03-30
17:30
[abf18d6ee5] part of check-in [fb9b9987de] Merge all recent trunk changes into the sessions branch. (user: drh branch: sessions)
14:01
[abf18d6ee5] part of check-in [a1a85b846a] Merge the latest trunk changes into the winrt branch. (user: drh branch: winrt)
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-28
16:44
[3179db5d4f] part of check-in [66c4aaadda] Merge in the latest changes from trunk. (user: drh branch: fts4-incr-merge)
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-10
18:18
[aa28f11703] part of check-in [e248598649] Pull the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
17:54
[aa28f11703] part of check-in [361fb66a79] Pull all the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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)
2012-01-05
13:02
[aa4183d4a5] part of check-in [a9bcb432f5] Merge all of the latest trunk changes into the sessions branch. (user: drh branch: sessions)
2012-01-03
21:54
[aa4183d4a5] part of check-in [8a048423f0] Pull all the latest trunk changes over into the apple-osx branch. (user: drh branch: apple-osx)
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)
18:28
[670644f7bd] part of check-in [08c1dc517c] Merge the VFSNAME file-control addition into the nx-devkit branch. (user: drh branch: nx-devkit)
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-10
15:55
[a1eadb2fdb] part of check-in [bcbc7152d4] Import the experimental parse-tree explainer, with fixes, from the tree-explain branch. Disabled by default. Use SQLITE_ENABLE_TREE_EXPLAIN to turn it on. (user: drh branch: trunk)
2011-12-08
21:08
[29812a900a] part of check-in [59e0d4f3d9] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
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-16
18:08
[29812a900a] part of check-in [457513f21f] Merge the PCACHE2 changes into trunk. (user: drh branch: trunk)
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-21
17:18
[f0ab793261] part of check-in [be62ef058b] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
17:08
[f0ab793261] part of check-in [8baef58170] Merge the latest trunk enhancements into the sessions branch. (user: drh branch: sessions)
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)
14:19
[e8fe1251ae] part of check-in [7e2c489822] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
12:58
[e8fe1251ae] part of check-in [403431cac6] Merge all the latest trunk changes into the sessions branch - especially the SQLITE_ENABLE_STAT3 enhancements. (user: drh branch: sessions)
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-19
20:36
[13fe2aeddc] part of check-in [9607600b6c] Merge in all changes through the 3.7.8 release. (user: drh branch: stat3-trunk)
20:32
[13fe2aeddc] part of check-in [ade72b1874] Merge in all trunk changes through the 3.7.8 release. (user: drh branch: apple-osx)
20:28
[13fe2aeddc] part of check-in [98619a23fd] Merge in all trunk changes through the version 3.7.8 release. (user: drh branch: sessions)
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-08-02
18:25
[bbe7818ff5] part of check-in [77376b332b] Merge all the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
2011-07-22
12:49
[bbe7818ff5] part of check-in [110cfd6920] Merge the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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-20
11:57
[0e0173b3e7] part of check-in [4c69e827f4] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
10:44
[0e0173b3e7] part of check-in [4c5e276c90] Merge the latest trunk changes into the sessions branch. (user: drh branch: sessions)
2011-06-06
18:14
[0e0173b3e7] part of check-in [567dd84359] Merge the latest trunk changes into the fts3-prefix-search branch. (user: drh branch: fts3-prefix-search)
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-31
17:08
[decd04236a] part of check-in [2c6b5a28e3] Merge the latest trunk changes into the wal-readonly branch. (user: drh branch: wal-readonly)
2011-05-19
02:48
[decd04236a] part of check-in [5b1b536cf8] Merge all the latest trunk changes into the sessions branch, especially the disappearing WAL transaction fix. (user: drh branch: sessions)
02:34
[decd04236a] part of check-in [5791232778c] Bring the apple-wal-readonly branch up to date with the latest changes in apple-osx, and especially the fix for disappearing WAL transactions. (user: drh branch: apple-wal-readonly)
01:51
[decd04236a] part of check-in [8d1a6bb002] Pull all the latest trunk changes, and especially the fix for WAL cache spills causing transactions to disappear, into the apple-osx branch. (user: drh branch: apple-osx)
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-18
17:30
[72e7e176bf] part of check-in [b91b4c31fe] Merge trunk changes into sessions branch. (user: dan branch: sessions)
2011-04-13
15:42
[72e7e176bf] part of check-in [289194d68e] Update the apple-osx branch to version 3.7.6.1. (user: drh branch: apple-osx)
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-09
18:13
[9c83897967] part of check-in [4eaef4ad4c] Pull all the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
18:07
[9c83897967] part of check-in [83705e90a5] Merge the latest trunk changes into the sessions branch. (user: drh branch: sessions)
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:13
[a73b30067e] part of check-in [45f2026172] Merge the latest trunk changes into the sessions branch. (user: drh branch: sessions)
22:10
[a73b30067e] part of check-in [c77a767cbd] Merge the latest trunk changes into the apple-osx branch. (user: drh branch: apple-osx)
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-04-04
13:11
[9dc0b4bb59] part of check-in [6d78a25ddc] Merge in the latest changes from trunk. (user: drh branch: apple-osx)
2011-03-23
22:48
[9dc0b4bb59] part of check-in [9c3a6e4799] Merge in all the latest changes from the trunk, and especially the interface changes to the SystemCall methods of the VFS. (user: drh branch: sessions)
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-18
12:35
[4a5e0ad845] part of check-in [94fd5bb6da] Merge all the latest trunk enhancements into the sessions branch. (user: drh branch: sessions)
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-14
13:54
[54f8fe0afa] part of check-in [3934b004e9] Merge the unix-excl VFS into the trunk. This merge also adds the -vfs option to the command-line shell. (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)
2011-01-27
18:48
[83c6f0cc5a] part of check-in [09d6c91dcf] Pull in all the changes from trunk up through the version 3.7.5 release candidate 1. (user: drh branch: apple-osx)
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-08-18
00:24
[8517fc1f9c] part of check-in [866e9286ae] Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. (user: drh branch: apple-osx)
2010-08-07
11:46
[fd4ccdb37c] part of check-in [f88c6367d2] Merge in all changes up to the 3.7.0.1 release. (user: drh branch: apple-osx)
2010-07-28
18:35
[8517fc1f9c] part of check-in [aa81900153] Merge trunk changes into experimental branch. (user: dan branch: experimental)
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-06-16
19:48
[c40427c724] part of check-in [21ca87f691] Merge in changes up to and including the 3.6.23.1 release. (user: drh branch: apple-osx)
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
16:54
[c40427c724] part of check-in [88b466bae4] Merged trunk to lemon-update-2010 branch. (user: icculus branch: lemon-update-2010)
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-17
19:34
[56521a1725] part of check-in [4b72e39bd0] Merge latest changes from the trunk into the apple-osx branch. (user: drh branch: apple-osx)
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-20
01:26
[d7408dbe4d] part of check-in [96499b1dd6] Update the Apple OS-X branch to include all of the latest changes in trunk. (user: drh branch: apple-osx)
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-06
13:12
[b95c5fcfe4] part of check-in [541e2b488e] Update the OS-X branch to include all trunk changes through version 3.6.22. (user: drh branch: apple-osx)
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-12-07
23:53
[f4948cb6d3] part of check-in [ad08794d72] Merge all changes associated with the version 3.6.21 release into the OS-X branch. (user: drh branch: apple-osx)
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-11-04
18:51
Added [f66531a57f] part of check-in [590d4ac1ee] Fix documentation typos. (user: drh branch: shunning-error)
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)