| 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 |