Lines Matching refs:tx

541   execsql {CREATE TABLE tx AS SELECT * FROM t1}
545        WHERE x IN (SELECT x FROM tx WHERE rowid<0)
546          AND +y IN (SELECT y FROM tx WHERE rowid=1)
552        WHERE x IN (SELECT x FROM tx WHERE rowid=1)
553          AND y IN (SELECT y FROM tx WHERE rowid<0)
559       CREATE INDEX tx_xyz ON tx(x, y, z, w);
560       SELECT w FROM tx
568       SELECT w FROM tx
576       SELECT w FROM tx
584       SELECT w FROM tx
592       SELECT w FROM tx
600       SELECT w FROM tx
608       SELECT w FROM tx
616       SELECT w FROM tx
624       SELECT w FROM tx
632       SELECT w FROM tx
640       SELECT w FROM tx
648       SELECT w FROM tx
656       SELECT w FROM tx
664       SELECT w FROM tx
672       SELECT w FROM tx
680       SELECT w FROM tx