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 |