Lines Matching refs:t1

19 # Assume there are two tables being joined - t1 and t2. Each has a cost
22 #   t1(outer) - cost of scanning t1 as the outer loop.
23 #   t1(inner) - cost of scanning t1 as the inner loop.
30 #   t1(outer) * t2(inner)
31 #   t2(outer) * t1(inner)
36 #   + (t1(outer) * t2(inner)) > (t1(inner) * t2(outer)
37 #   +  t1(outer) < t2(outer)
40 # but when the outer loop is considered independent of the inner, t1 is the
53   CREATE TABLE t1(a, b, c);
55   CREATE UNIQUE INDEX i1 ON t1(a);
60   1 "SELECT * FROM t1,           t2 WHERE t1.a=t2.e AND t2.d<t1.b AND t1.c!=10"
61   2 "SELECT * FROM t2,           t1 WHERE t1.a=t2.e AND t2.d<t1.b AND t1.c!=10"
62   3 "SELECT * FROM t2 CROSS JOIN t1 WHERE t1.a=t2.e AND t2.d<t1.b AND t1.c!=10"
66    } {/.*SCAN t2\y.*SEARCH t1\y.*/}
70   DROP TABLE t1;
72   CREATE TABLE t1(a, b, c);
75   CREATE UNIQUE INDEX i1 ON t1(a);
76   CREATE UNIQUE INDEX i2 ON t1(b);
81   1 "SELECT * FROM t1,           t2 WHERE t1.a>? AND t2.d>t1.c AND t1.b=t2.e"
82   2 "SELECT * FROM t2,           t1 WHERE t1.a>? AND t2.d>t1.c AND t1.b=t2.e"
83   3 "SELECT * FROM t2 CROSS JOIN t1 WHERE t1.a>? AND t2.d>t1.c AND t1.b=t2.e"
87    } {/.*SCAN t2\y.*SEARCH t1\y.*/}
91   DROP TABLE t1;
93   CREATE TABLE t1(a, b, c);
96   CREATE UNIQUE INDEX i1 ON t1(a, b);
101   1 {SELECT t1.a, t1.b, t2.d, t2.e FROM t1, t2 
102      WHERE t2.d=t1.b AND t1.a=(t2.d+1) AND t1.b = (t2.e+1)}
104   2 {SELECT t1.a, t1.b, t2.d, t2.e FROM t2, t1 
105      WHERE t2.d=t1.b AND t1.a=(t2.d+1) AND t1.b = (t2.e+1)}
107   3 {SELECT t1.a, t1.b, t2.d, t2.e FROM t2 CROSS JOIN t1 
108      WHERE t2.d=t1.b AND t1.a=(t2.d+1) AND t1.b = (t2.e+1)}
112    } {/.*SCAN t2\y.*SEARCH t1\y.*/}
125 #   ... FROM t1, t2 WHERE (
126 #     t2.rowid = +t1.rowid OR (t2.f2 = t1.f1 AND t1.f1!=-1)
129 # where there is an index on t2(f2). The planner should use "t1" as the
145   CREATE TABLE t1(f1);
149   INSERT INTO t1 VALUES(-1);
150   INSERT INTO t1 VALUES(-1);
151   INSERT INTO t1 VALUES(-1);
152   INSERT INTO t1 VALUES(-1);
161   SELECT count(*) FROM t1, t2 WHERE t2.rowid = +t1.rowid
166   SELECT count(*) FROM t1, t2 WHERE (
167     t2.rowid = +t1.rowid OR t2.f2 = t1.f1
173   SELECT count(*) FROM t1, t2 WHERE (
174     t2.rowid = +t1.rowid OR (t2.f2 = t1.f1 AND t1.f1!=-1)
268   DROP TABLE IF EXISTS t1;
270   CREATE TABLE t1(a INTEGER PRIMARY KEY, b);
271   INSERT INTO t1(a,b) VALUES(1,1);
276      WHERE ( t1.b IS NOT NULL AND t2.bb IS NULL )
277         OR ( t2.bb < t1.b )
278         OR ( t1.b IS t2.bb AND t2.aa > t1.a )
280     FROM t1;
296   DROP TABLE IF EXISTS t1;
298   CREATE TABLE t1(a INTEGER PRIMARY KEY, b TEXT);
299   INSERT INTO t1(a,b) VALUES(1,'abcxyz');
305      WHERE ( t1.b GLOB 'a*z' AND t2.bb='xyz' )
306         OR ( t2.bb = t1.b )
307         OR ( t2.aa = t1.a )
309     FROM t1;