Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Correct typo in new test numbering. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | expShell |
| Files: | files | file ages | folders |
| SHA1: |
d176c9fa4c65ff2f3952dd3dee46da14 |
| User & Date: | mistachkin 2015-04-07 21:17:53 |
Context
|
2015-04-07
| ||
| 21:18 | Merge updates from trunk. check-in: c458db41 user: mistachkin tags: expShell | |
| 21:17 | Correct typo in new test numbering. check-in: d176c9fa user: mistachkin tags: expShell | |
| 21:16 | Enhance the shell export to support emitting column names in 'insert' mode when headers are enabled. check-in: 6e504cd0 user: mistachkin tags: expShell | |
Changes
Changes to test/shell1.test.
792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 |
INSERT INTO t3 VALUES(3,1);
INSERT INTO t3 VALUES(4,2.25);
INSERT INTO t3 VALUES(5,'hello');
INSERT INTO t3 VALUES(6,X'807f');}}
# Test the output of ".mode insert" with headers
#
do_test shell1-4.2.3 {
catchcmd test.db ".mode insert t3\n.headers on\nselect * from t3;"
} {0 {INSERT INTO t3(x,y) VALUES(1,NULL);
INSERT INTO t3(x,y) VALUES(2,'');
INSERT INTO t3(x,y) VALUES(3,1);
INSERT INTO t3(x,y) VALUES(4,2.25);
INSERT INTO t3(x,y) VALUES(5,'hello');
INSERT INTO t3(x,y) VALUES(6,X'807f');}}
|
| |
792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 |
INSERT INTO t3 VALUES(3,1);
INSERT INTO t3 VALUES(4,2.25);
INSERT INTO t3 VALUES(5,'hello');
INSERT INTO t3 VALUES(6,X'807f');}}
# Test the output of ".mode insert" with headers
#
do_test shell1-4.2.4 {
catchcmd test.db ".mode insert t3\n.headers on\nselect * from t3;"
} {0 {INSERT INTO t3(x,y) VALUES(1,NULL);
INSERT INTO t3(x,y) VALUES(2,'');
INSERT INTO t3(x,y) VALUES(3,1);
INSERT INTO t3(x,y) VALUES(4,2.25);
INSERT INTO t3(x,y) VALUES(5,'hello');
INSERT INTO t3(x,y) VALUES(6,X'807f');}}
|