OLD | NEW |
1 | 1 |
2 set testdir [file dirname $argv0] | 2 set testdir [file dirname $argv0] |
3 source $testdir/tester.tcl | 3 source $testdir/tester.tcl |
4 | 4 |
5 ifcapable !vtab { | 5 ifcapable !vtab { |
6 finish_test | 6 finish_test |
7 return | 7 return |
8 } | 8 } |
9 | 9 |
10 register_echo_module [sqlite3_connection_pointer db] | 10 register_echo_module [sqlite3_connection_pointer db] |
(...skipping 14 matching lines...) Expand all Loading... |
25 } {500} | 25 } {500} |
26 | 26 |
27 do_test tkt3871-1.2 { | 27 do_test tkt3871-1.2 { |
28 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 } | 28 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 } |
29 } {1 1 2 4} | 29 } {1 1 2 4} |
30 do_test tkt3871-1.3 { | 30 do_test tkt3871-1.3 { |
31 set echo_module "" | 31 set echo_module "" |
32 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 } | 32 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 } |
33 set echo_module | 33 set echo_module |
34 } [list \ | 34 } [list \ |
35 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 1 \ | 35 xFilter {SELECT rowid, a, b FROM 't1' WHERE a = ?} 1 \ |
36 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 2 \ | 36 xFilter {SELECT rowid, a, b FROM 't1' WHERE a = ?} 2 \ |
37 ] | 37 ] |
38 | 38 |
39 do_test tkt3871-1.4 { | 39 do_test tkt3871-1.4 { |
40 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 OR b = 9 } | 40 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 OR b = 9 } |
41 } {1 1 2 4 3 9} | 41 } {1 1 2 4 3 9} |
42 do_test tkt3871-1.5 { | 42 do_test tkt3871-1.5 { |
43 set echo_module "" | 43 set echo_module "" |
44 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 OR b = 9 } | 44 execsql { SELECT * FROM e WHERE a = 1 OR a = 2 OR b = 9 } |
45 set echo_module | 45 set echo_module |
46 } [list \ | 46 } [list \ |
47 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 1 \ | 47 xFilter {SELECT rowid, a, b FROM 't1' WHERE a = ?} 1 \ |
48 xFilter {SELECT rowid, * FROM 't1' WHERE a = ?} 2 \ | 48 xFilter {SELECT rowid, a, b FROM 't1' WHERE a = ?} 2 \ |
49 xFilter {SELECT rowid, * FROM 't1' WHERE b = ?} 9 | 49 xFilter {SELECT rowid, a, b FROM 't1' WHERE b = ?} 9 |
50 ] | 50 ] |
51 | 51 |
52 | 52 |
53 finish_test | 53 finish_test |
OLD | NEW |