OLD | NEW |
| (Empty) |
1 | |
2 set testdir [file dirname $argv0] | |
3 source $testdir/tester.tcl | |
4 | |
5 ifcapable !vtab { | |
6 finish_test | |
7 return | |
8 } | |
9 | |
10 register_echo_module [sqlite3_connection_pointer db] | |
11 | |
12 do_test tkt3871-1.1 { | |
13 execsql { | |
14 BEGIN; | |
15 CREATE TABLE t1(a PRIMARY KEY, b UNIQUE); | |
16 } | |
17 for {set i 0} {$i < 500} {incr i} { | |
18 execsql { INSERT INTO t1 VALUES($i, $i*$i) } | |
19 } | |
20 execsql COMMIT | |
21 execsql { | |
22 CREATE VIRTUAL TABLE e USING echo(t1); | |
23 SELECT count(*) FROM e; | |
24 } | |
25 } {500} | |
26 | |
27 do_test tkt3871-1.2 { | |
28 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 } | |
29 } {1 1 2 4} | |
30 do_test tkt3871-1.3 { | |
31 set echo_module "" | |
32 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 } | |
33 set echo_module | |
34 } [list \ | |
35 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 1 \ | |
36 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 2 \ | |
37 ] | |
38 | |
39 do_test tkt3871-1.4 { | |
40 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 OR b = 9 } | |
41 } {1 1 2 4 3 9} | |
42 do_test tkt3871-1.5 { | |
43 set echo_module "" | |
44 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 OR b = 9 } | |
45 set echo_module | |
46 } [list \ | |
47 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 1 \ | |
48 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 2 \ | |
49 xFilter {SELECT rowid, * FROM 't1' WHERE b = ?} 9 | |
50 ] | |
51 | |
52 | |
53 finish_test | |
OLD | NEW |