diff options
Diffstat (limited to 'test/vtabE.test')
| -rw-r--r-- | test/vtabE.test | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/test/vtabE.test b/test/vtabE.test index aeb478e3e..cbb6a1e30 100644 --- a/test/vtabE.test +++ b/test/vtabE.test @@ -39,7 +39,9 @@ do_test vtabE-1 { CREATE VIRTUAL TABLE t1 USING tclvar; CREATE VIRTUAL TABLE t2 USING tclvar; CREATE TABLE t3(a INTEGER PRIMARY KEY, b); - SELECT t1.*, t2.*, abs(t3.b + abs(t2.value + abs(t1.value))) + SELECT t1.name, t1.arrayname, t1.value, + t2.name, t2.arrayname, t2.value, + abs(t3.b + abs(t2.value + abs(t1.value))) FROM t1 LEFT JOIN t2 ON t2.name = t1.arrayname LEFT JOIN t3 ON t3.a=t2.value WHERE t1.name = 'vtabE' |