Lines Matching refs:t1
3304 ** CREATE TABLE t1(c1 VARIANT);
3308 ** SELECT c1 + 1, c1 FROM t1;
50063 static const u64 t1 = ((u64)0x3ff00000)<<32;
50065 u64 t2 = t1;
60420 ** SELECT a+b AS x, c+d AS y FROM t1 ORDER BY x;
60424 ** SELECT a+b AS x, c+d AS y FROM t1 ORDER BY a+b;
60530 ** CREATE TABLE t1(a);
60531 ** SELECT * FROM t1 WHERE a;
60532 ** SELECT a AS b FROM t1 WHERE b;
60533 ** SELECT * FROM t1 WHERE (select a from t1);
63225 ** CREATE TABLE t1(a, b);
64338 ** sqlite_rename_parent('CREATE TABLE t1(a REFERENCES t2)', 't2', 't3')
64339 ** -> 'CREATE TABLE t1(a REFERENCES t3)'
72924 ** CREATE TABLE t1(a, b INTEGER PRIMARY KEY, c);
72925 ** INSERT INTO t1 VALUES(1, 2, 3.1);
73363 ** CREATE TABLE t1(a PRIMARY KEY);
73364 ** CREATE TABLE t2(b REFERENCES t1(a);
73366 ** Calling this function with table "t1" as an argument returns a pointer
79515 ** SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.b AND t1.x=5
79517 ** The where clause needs to defer the handling of the t1.x=5
79519 ** NULL t2 row will be inserted whenever t1.x!=5. If we do not
79520 ** defer the handling of t1.x=5, it will be processed immediately
79521 ** after the t1 loop and rows with t1.x!=5 will never appear in
80169 ** CREATE TABLE t1(col INTEGER);
80170 ** SELECT (SELECT t1.col) FROM FROM t1;
80172 ** when columnType() is called on the expression "t1.col" in the
80176 ** This is not a problem, as the column type of "t1.col" is never
80178 ** "(SELECT t1.col)", the correct type is returned (see the TK_SELECT
80677 ** SELECT a FROM t1 UNION SELECT b FROM t2 UNION SELECT c FROM t3
80685 ** `------> SELECT a FROM t1
81702 ** SELECT a FROM (SELECT x+y AS a FROM t1 WHERE z<100) WHERE a>5
81714 ** SELECT x+y AS a FROM t1 WHERE z<100 AND a>5
81718 ** exist on the table t1, a complete scan of the data might be
81864 ** t1 LEFT OUTER JOIN (t2 JOIN t3)
81868 ** (t1 LEFT OUTER JOIN t2) JOIN t3
81877 ** t1 LEFT OUTER JOIN (SELECT * FROM t2 WHERE t2.x>0)
81881 ** (t1 LEFT OUTER JOIN t2) WHERE t2.x>0
82096 ** SELECT a+5, b*10 FROM (SELECT x*3 AS a, y+10 AS b FROM t1) WHERE a>b;
84406 ** CREATE TRIGGER AFTER INSERT ON t1 BEGIN;
84410 ** INSERT INTO t1 ... ; -- insert into t2 uses REPLACE policy
84411 ** INSERT OR IGNORE INTO t1 ... ; -- insert into t2 uses IGNORE policy
86808 ** (t1.X <op> <expr>) OR (t1.Y <op> <expr>) OR ....
87524 ** (A) t1.x=t2.y OR t1.x=t2.z OR t1.y=15 OR t1.z=t3.a+5
87526 ** (C) t1.x=t2.y OR (t1.x=t2.z AND t1.y=15)
87722 /* This term must be of the form t1.a==t2.b where t2 is in the
87723 ** chngToIN set but t1 is not. This term will be either preceeded
87724 ** or follwed by an inverted copy (t2.b==t1.a). Skip this term
88811 ** example, assuming that index p is on t1(a):
88813 ** ... FROM t1 WHERE a > ? AND a < ? ...
88824 ** on t1(a, b), and the SQL query is:
88826 ** ... FROM t1 WHERE a = ? AND b > ? AND b < ? ...
88831 ** ... FROM t1 WHERE a > ? AND a < ? ...
89303 ** (1) SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.x WHERE t2.z='ok'
89304 ** (2) SELECT * FROM t1 LEFT JOIN t2 ON t1.a=t2.x AND t2.z='ok'
89305 ** (3) SELECT * FROM t1, t2 WHERE t1.a=t2.x AND t2.z='ok'
89443 ** For example, consider table t1(a,b,c,d,e,f) with index i1(a,b,c).
89469 ** CREATE TABLE t1(a TEXT PRIMARY KEY, b);
89470 ** SELECT ... FROM t1 AS t2, t1 WHERE t1.a = t2.b;
89472 ** In the example above, the index on t1(a) has TEXT affinity. But since
89972 ** CREATE TABLE t1(a,b,c,d);
89973 ** CREATE INDEX i1 ON t1(a);
89974 ** CREATE INDEX i2 ON t1(b);
89975 ** CREATE INDEX i3 ON t1(c);
89977 ** SELECT * FROM t1 WHERE a=5 OR b=7 OR (c=11 AND d=13)
90223 ** SELECT * FROM t1, t2, t3 WHERE ...;
90227 ** foreach row1 in t1 do \ Code generated
90241 ** There are Btree cursors associated with each table. t1 uses cursor
90267 ** An outer join of tables t1 and t2 is conceptally coded as follows:
90269 ** foreach row1 in t1 do
90477 ** CREATE TABLE t1(a, b);
90479 ** SELECT * FROM t2, t1 WHERE t2.rowid = t1.a;
90481 ** The best strategy is to iterate through table t1 first. However it
90484 ** as the cost of a linear scan through table t1, a simple greedy
