wasCSharpSQLite – Blame information for rev 4

Subversion Repositories:
Rev:
Rev Author Line No. Line
1 office 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