/ All files named "test/shell1.test"
Login

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

History for test/shell1.test

2020-10-12
14:56
[161353b1] part of check-in [b72ee694] Add the --nosys option to the .schema command in the CLI. (check-in: [b72ee694] user: drh branch: trunk, size: 36404)
2020-08-11
18:17
[1305efc9] part of check-in [bc1590f3] New test cases for the use of the ieee754 and decimal extensions in the CLI. (check-in: [bc1590f3] user: drh branch: trunk, size: 36394)
2020-06-05
00:54
[a1cf47c5] part of check-in [2827c0a1] Always use ?...? to indicate optional arguments in the output of ".help" in the CLI. Change ".mode column" so that it automatically activates ".headers on" if headers have not been previously turned on or off. (check-in: [2827c0a1] user: drh branch: trunk, size: 34409)
2020-06-04
18:05
[fabf21ee] part of check-in [6da784c9] Add support for "box" mode in the CLI: Like "table" except that it uses unicode box-drawing characters instead of ascii-art. (check-in: [6da784c9] user: drh branch: trunk, size: 34383)
2020-05-28
23:49
[1c4713cc] part of check-in [14f55faf] Progress toward adding new output modes to the CLI: json, table, and markdown. (check-in: [14f55faf] user: drh branch: trunk, size: 34359)
2020-04-20
16:21
[5bd10014] part of check-in [698d40db] Enhance the ".filectrl" command in the CLI to support the --schema option. (check-in: [698d40db] user: drh branch: trunk, size: 34239)
2020-03-25
12:50
[1796b7f7] part of check-in [45fba3d7] Enhance the ".dump" command in the CLI so that it accepts multiple LIKE pattern arguments and shows the union of all matching tables. (check-in: [45fba3d7] user: drh branch: trunk, size: 33485)
2020-03-09
15:39
[43e12c7d] part of check-in [cab1834c] Enhancements to the ".import" command of the CLI. (check-in: [cab1834c] user: drh branch: trunk, size: 33430)
2019-04-12
16:25
[3c9707dc] part of check-in [7b771405] Test case changes so that they work with both Tcl8.6 and Tcl8.7. (check-in: [7b771405] user: drh branch: trunk, size: 33510)
2018-12-10
00:41
[0378c4e9] part of check-in [9748d799] Fix the shell1.test test for the new format of the .backup command. (check-in: [9748d799] user: drh branch: vacuum-into, size: 33395)
2018-09-26
16:53
[d2bf5dae] part of check-in [209afb8d] Begin revamping the ".help" command in the command-line shell so that it can accept an argument and will do a search for commands that match that argument. (check-in: [209afb8d] user: drh branch: trunk, size: 33396)
2018-06-07
15:23
[707c03fb] part of check-in [bb87c054] Avoid using a prepared statement for ".stats on" after it has been closed by the ".eqp full" logic. Fix for ticket [7be932dfa60a8a6b3b26bcf76]. (check-in: [bb87c054] user: drh branch: trunk, size: 33398)
2018-05-14
00:23
[50154b0c] part of check-in [0dfdbdee] Add the --append option to the ".backup" command in the CLI. (check-in: [0dfdbdee] user: drh branch: trunk, size: 33081)
2018-03-24
15:08
[e2f7d375] part of check-in [2e06906e] Fix a test script problem causing shell1.test to fail with -DSQLITE_OMIT_VIRTUAL_TABLE builds. (check-in: [2e06906e] user: dan branch: trunk, size: 33071)
2018-03-23
14:24
[7c55993f] part of check-in [98e3f524] Enhance .schema in shell to enable matching patterns with literal underscores. (check-in: [98e3f524] user: mistachkin branch: trunk, size: 32971)
2018-01-10
23:27
[9f8b8da0] part of check-in [fbf5e43c] Update test cases for the new "usage" for .output. (check-in: [fbf5e43c] user: drh branch: excel-shell-cmd, size: 31841)
2018-01-01
21:49
[6d69e080] part of check-in [d64b14e3] Improved name quoting and escaping in the auxiliary column info section of the ".schema" output for views and virtual tables. (check-in: [d64b14e3] user: drh branch: trunk, size: 31825)
21:28
[3f23fe26] part of check-in [2234a87f] In the output of ".schema", show the column names of virtual tables and views in a separate comment. (check-in: [2234a87f] user: drh branch: trunk, size: 31833)
2017-07-10
18:04
[f78ea0e2] part of check-in [bde431b1] Add the "--newlines" option to the ".dump" command in the shell to disable the newline escaping mechanism. (check-in: [bde431b1] user: drh branch: trunk, size: 31797)
2017-06-29
21:33
[76ae80ab] part of check-in [5e3f9ea5] In the command-line shell, add the -quote option to start up in quote mode. Enhance the ".mode" command so that it reports the current output mode if given no arguments. (check-in: [5e3f9ea5] user: drh branch: trunk, size: 31784)
2017-06-24
19:21
[65f55c12] part of check-in [c8186874] Disable shell tests for the .schema command if virtual tables are not available. (check-in: [c8186874] user: drh branch: trunk, size: 31842)
2017-03-25
18:31
[50226a3a] part of check-in [55df410b] Do not run tests for ".dump --preserve-rowids" when testing SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [55df410b] user: dan branch: trunk, size: 31823)
2017-03-08
12:25
[bc1ca416] part of check-in [de65f907] In the CLI, avoid unnecessary identifier quoting in the ".dump" output. Also add new ".dump" test cases. (check-in: [de65f907] user: drh branch: trunk, size: 31405)
11:44
[5df739ee] part of check-in [c60aee24] Add the --preserve-rowids option to the ".dump" command in the CLI. (check-in: [c60aee24] user: drh branch: trunk, size: 29159)
2016-12-27
02:43
[52ac23a3] part of check-in [382eea36] Minor changes to make some newer test cases work under more compile-time options. (check-in: [382eea36] user: drh branch: trunk, size: 27799)
2016-11-23
23:18
[8ff47a48] part of check-in [9a603a18] Fix the error message for invalid ".mode" arguments in the command-line shell, so that it mentions the new "quote" mode. (check-in: [9a603a18] user: drh branch: trunk, size: 27780)
2016-07-29
04:12
[65b10cd8] part of check-in [544c990a] For test 'shell1-5.0', disable round-trip testing for characters in the range 0xE0 to 0xEF on Linux, due to intermittent shell portability issues. (check-in: [544c990a] user: mistachkin branch: trunk, size: 27738)
2016-07-25
14:20
[77896b65] part of check-in [9e7bedee] Changes to test scripts to get them all running on OpenBSD. (check-in: [9e7bedee] user: drh branch: trunk, size: 27668)
2016-05-16
11:55
[c90b0415] part of check-in [386bcbba] Disable shell.exe test cases for UTF8 filenames as they do not work on MinGW. (check-in: [386bcbba] user: drh branch: trunk, size: 27608)
2016-04-13
15:33
[023657b3] part of check-in [83cfe82c] Add the --indent option to the .schema and .fullschema commands in the shell, to enable simple but effective pretty-printing. (check-in: [83cfe82c] user: drh branch: trunk, size: 27558)
2016-04-04
17:59
[b3df199c] part of check-in [cefd36ff] Improve error messages from the 'shell1-5.0' test. (check-in: [cefd36ff] user: mistachkin branch: trunk, size: 27547)
15:47
[a216486c] part of check-in [f4cbd18d] Add and enhance the new tests. (check-in: [f4cbd18d] user: mistachkin branch: altShellFix, size: 27413)
02:33
[b110f092] part of check-in [b36dfdff] Refinements to the previous check-in. (check-in: [b36dfdff] user: mistachkin branch: altShellFix, size: 26978)
02:16
[95b172b3] part of check-in [74183a5f] Experimental changes to the command line shell to make it work better with Unicode on Windows. (check-in: [74183a5f] user: mistachkin branch: altShellFix, size: 26970)
2016-03-26
15:36
[dff5b20a] part of check-in [8213c2f5] More changes to the shellN.test scripts to get them working on all variations of Windows. (check-in: [8213c2f5] user: drh branch: trunk, size: 26411)
14:41
[d36a68f0] part of check-in [3bd499d3] Remove the catchcmd_collapse_space procedure in tester.tcl - no longer needed. (check-in: [3bd499d3] user: drh branch: trunk, size: 26411)
13:26
[25de3bf7] part of check-in [219a251e] Update shell1.test tests to deal with backslash escaping in TCL on Windows-style pathnames. (check-in: [219a251e] user: drh branch: trunk, size: 26441)
2016-03-25
17:09
[12d17749] part of check-in [93caabb6] Add the catchcmd_collapse_space command and use it to help make shell testing more robust against TCL space escapes. (check-in: [93caabb6] user: drh branch: trunk, size: 26427)
2016-03-24
20:55
[94538224] part of check-in [817e93f4] Make test cases in shell1.test robust against TCL deciding to quote strings using lots of backslashes. (check-in: [817e93f4] user: drh branch: trunk, size: 26501)
2016-03-15
09:55
[e7dac983] part of check-in [051c61eb] Fix the shellN.test test scripts so that they work with the --testdir option. (check-in: [051c61eb] user: dan branch: trunk, size: 26401)
2016-02-27
17:12
[a45b424e] part of check-in [3c36948f] Enhance the ".stats" command in sqlite3.exe to show one-time stats information if invoked with one argument. Also show /proc/PID/io information if run on Linux. (check-in: [3c36948f] user: drh branch: trunk, size: 26532)
2015-04-07
21:17
[ce5e7448] part of check-in [d176c9fa] Correct typo in new test numbering. (check-in: [d176c9fa] user: mistachkin branch: expShell, size: 26527)
21:16
[9520d19c] part of check-in [6e504cd0] Enhance the shell export to support emitting column names in 'insert' mode when headers are enabled. (check-in: [6e504cd0] user: mistachkin branch: expShell, size: 26527)
2015-02-27
19:40
[0860b923] part of check-in [acf76843] Merge updates from trunk. (check-in: [acf76843] user: mistachkin branch: expShell, size: 25140)
2015-02-06
14:51
[ca88b14a] part of check-in [0f65a7e2] Change the name of ".info" to ".dbinfo" and add an optional second argument which is the ATTACH-ed DB about which information is provided. Provide ".indexes" as an alternative name to the legacy ".indices" command. (check-in: [0f65a7e2] user: drh branch: trunk, size: 23030)
2015-01-19
21:27
[a80eda27] part of check-in [913c41b2] Improve precision of the new test case by removing a superfluous carriage-return from the shell command input. (check-in: [913c41b2] user: mistachkin branch: expShell, size: 25064)
21:11
[b6fb0b96] part of check-in [4ec2aead] Add comments and improve the new test case. (check-in: [4ec2aead] user: mistachkin branch: expShell, size: 25066)
2015-01-18
09:02
[6f7613e9] part of check-in [f362c5d9] Modify the new shell test case to work on non-Windows platforms as well. (check-in: [f362c5d9] user: mistachkin branch: expShell, size: 24051)
05:35
[4c16272b] part of check-in [25e99f3f] Some experimental command line shell input/output enhancements. (check-in: [25e99f3f] user: mistachkin branch: expShell, size: 24027)
2014-12-11
03:12
[cdeb849a] part of check-in [66a28f7a] Simplify and cleanup the implementation of the new ASCII mode for the shell. (check-in: [66a28f7a] user: mistachkin branch: asciiMode, size: 22954)
02:28
[0d2cece6] part of check-in [5b5d3e4d] Merge updates from trunk. (check-in: [5b5d3e4d] user: mistachkin branch: asciiMode, size: 23752)
2014-11-28
13:35
[ab6025d9] part of check-in [24fa2e98] Remove the ill-designed "-end" option from the command-line shell. Instead, allow multiple SQL or dot-commands as command-line arguments. Any -cmd commands are processed first, followed by other command-line arguments, for backwards compatibility. (check-in: [24fa2e98] user: drh branch: trunk, size: 22813)
2014-07-24
22:33
[1c0b7a79] part of check-in [b84008cb] Update a shell test case. (check-in: [b84008cb] user: mistachkin branch: asciiMode, size: 23761)
22:13
[d13ff516] part of check-in [8dc0cdf6] Merge updates from trunk. (check-in: [8dc0cdf6] user: mistachkin branch: asciiMode, size: 23725)
12:09
[d60946b5] part of check-in [16c8ce10] In the command-line shell, in CSV output mode, terminate rows with CRNL but do not expand NL characters in data into CRNL. Provide the extra -newline command-line option and the extra argument to .separator to designate an alternative newline character sequence for CSV output. (check-in: [16c8ce10] user: drh branch: trunk, size: 22822)
2014-07-19
20:15
[4e4f8e6b] part of check-in [7fe601ea] Add new ASCII mode to the shell capable of importing and exporting using the official unit and record separators (i.e. 0x1F and 0x1E, respectively). (check-in: [7fe601ea] user: mistachkin branch: asciiMode, size: 23619)
2014-05-29
12:36
[fb080d67] part of check-in [48dce821] Improvements to error messages for errors in the dot-commands of the command-line shell. Add the ".once" command. The output of ".help" now goes to the designated output channel. (check-in: [48dce821] user: drh branch: trunk, size: 22716)
2014-02-11
16:22
[f2a1d471] part of check-in [f5ad1e1b] Updates to the command-line shell. Simplify the banner message. Add the ".save" command as an alias for ".backup". When starting with no arguments, include a banner message warning that the database is transient and in-memory and mention the ".open" command. (check-in: [f5ad1e1b] user: drh branch: trunk, size: 25181)
2013-09-13
23:26
[e7c0b9eb] part of check-in [650b3282] Fix test issues for Windows portability. (check-in: [650b3282] user: mistachkin branch: trunk, size: 25172)
2013-09-04
16:08
[474ed53b] part of check-in [d8fdc782] Fix a bug in the command-line shell for ".mode insert" on UTF16 databases with BLOB values. (check-in: [d8fdc782] user: drh branch: trunk, size: 25179)
2013-06-27
13:26
[92854727] part of check-in [656a1fe5] Improved handling of backslash escapes on double-quoted arguments to dot-commands in the command-line shell. (check-in: [656a1fe5] user: drh branch: trunk, size: 24904)
2013-06-26
22:46
[338f51e6] part of check-in [93f63215] Update the ".import" command of the command-line shell so that it can accept field values that span multiple lines and so that it issues error messages if the input text does not strictly conform to RFC4180. (check-in: [93f63215] user: drh branch: trunk, size: 24584)
2013-01-28
18:18
[4a2f5795] part of check-in [b4d94947] Cause the command-line shell to issue an error message if you give something that does not look like a boolean value to a dot-command that wants a boolean argument. (check-in: [b4d94947] user: drh branch: trunk, size: 24581)
2013-01-25
18:33
[b9b45c35] part of check-in [8ba951d1] Enhance the command-line shell so that adding a non-zero numeric argument to the ".exit" command causes an immediate exit without cleaning up. This can be used (for example) to cause journal files to be left behind. (check-in: [8ba951d1] user: drh branch: trunk, size: 24530)
2013-01-23
18:53
[392a2658] part of check-in [f1127e87] Improved parsing of the arguments to the ".backup" command in the command-line shell. (check-in: [f1127e87] user: drh branch: trunk, size: 24694)
2012-12-04
00:23
[b7896eb8] part of check-in [41fd9dd2] Improvements to the 'tcl' shell output mode. Escape double quotes, set separator to space when mode is set, and skip separator after final column. (check-in: [41fd9dd2] user: mistachkin branch: tclMode, size: 24785)
2012-10-25
15:23
[34012522] part of check-in [317c80cb] Improvements to the command-line argument parsing in the command-line shell. Command-line options can now occur either before or after the database name and first command and are still accepted and processed. Command-line options are processed even if no database name is given (and :memory: is assumed). (check-in: [317c80cb] user: drh branch: trunk, size: 23751)
2012-09-21
13:40
[27238416] part of check-in [a1d8269d] Command-line shell enhancements: Added the ".print" command. Enhanced the ".width" command so that negative widths will right-justify. (check-in: [a1d8269d] user: drh branch: trunk, size: 23769)
2012-05-22
19:25
[9895ee30] part of check-in [1dd01e40] Use the new test suite helper procedure 'get_pwd' to query the current directory from tests. (check-in: [1dd01e40] user: mistachkin branch: winrt, size: 23275)
2012-05-21
22:45
[6e3013bc] part of check-in [5519cc5e] Increase the version number to 3.7.12.1. Minor changes to test scripts. (check-in: [5519cc5e] user: drh branch: trunk, size: 23271)
03:15
[cb78ef32] part of check-in [e092ff69] Change the ".schema" command of the shell to output VIEWs in declared order, rather than alphabetical order, so that nested views will appear in the correct order. Fix for ticket [cfe84e86839e59e8]. (check-in: [e092ff69] user: drh branch: trunk, size: 23289)
2012-05-20
20:14
[e3228ec9] part of check-in [0c0a0398] Check-in included unrelated debugging code by mistake. Was: Fix a test case in the shell1.test script so that it works even for very long pathnames. (check-in: [0c0a0398] user: drh branch: mistake, size: 22928)
2012-05-12
01:14
[cd9f8467] part of check-in [93061c6e] Use the regexp result option for a test case in shell1.test. (check-in: [93061c6e] user: drh branch: trunk, size: 22893)
2012-04-24
13:14
[7dcd612b] part of check-in [dfce8569] New test cases for the ".dump" and ".mode insert" commands of the shell. (check-in: [dfce8569] user: drh branch: trunk, size: 22909)
12:46
Renamed tool/shell1.test → test/shell1.test. [6d5a3317] part of check-in [9fb7da69] Move the shell test scripts into the test/ subfolder so that they are run automatically by "make test". (check-in: [9fb7da69] user: drh branch: trunk, size: 22198)