aboutsummaryrefslogtreecommitdiff
path: root/test/vtab2.test
diff options
context:
space:
mode:
authordrh <drh@noemail.net>2017-08-10 17:53:11 +0000
committerdrh <drh@noemail.net>2017-08-10 17:53:11 +0000
commit4dd176eaabd42f2bc06a49f8119da7960308f9df (patch)
tree6989378f919d6579fc30727a8f72e916b18d0d0e /test/vtab2.test
parente3740f272bf8fc7439d64e211c3093ff55a8c21c (diff)
downloadsqlite-4dd176eaabd42f2bc06a49f8119da7960308f9df.tar.gz
sqlite-4dd176eaabd42f2bc06a49f8119da7960308f9df.zip
Test case for writing to a WITHOUT ROWID virtual table. The TCLVAR virtual
table is modified to add a "fullname" column which is the primary key, and to accept update operations against the primary key. FossilOrigin-Name: 6997e00c3221f266f4d9187501d8a9e5bafb85551e88a744cdc8ffe3b75ec2a4
Diffstat (limited to 'test/vtab2.test')
-rw-r--r--test/vtab2.test4
1 files changed, 2 insertions, 2 deletions
diff --git a/test/vtab2.test b/test/vtab2.test
index f0616513b..7bd27a5fd 100644
--- a/test/vtab2.test
+++ b/test/vtab2.test
@@ -60,7 +60,7 @@ do_test vtab2-2.1 {
set ::abc 123
execsql {
CREATE VIRTUAL TABLE vars USING tclvar;
- SELECT * FROM vars WHERE name='abc';
+ SELECT name, arrayname, value FROM vars WHERE name='abc';
}
} [list abc "" 123]
do_test vtab2-2.2 {
@@ -68,7 +68,7 @@ do_test vtab2-2.2 {
set A(2) 4
set A(3) 9
execsql {
- SELECT * FROM vars WHERE name='A';
+ SELECT name, arrayname, value FROM vars WHERE name='A';
}
} [list A 1 1 A 2 4 A 3 9]
unset -nocomplain result