Return to tkt3871.test CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / sqlite3 / test

sqlite3

    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