Lines Matching refs:a

4 # a legal notice, here is a blessing:
29       CREATE TABLE t1(a,b); INSERT INTO t1 VALUES(111,'x1');
30       CREATE TABLE t2(a,b); INSERT INTO t2 VALUES(222,'x2');
31       CREATE TEMP TABLE t3(a,b); INSERT INTO t3 VALUES(333,'x3');
32       CREATE TABLE main.t4(a,b); INSERT INTO main.t4 VALUES(444,'x4');
33       CREATE TABLE aux1.t4(a,b); INSERT INTO aux1.t4 VALUES(555,'x5');
40        WHERE t4.a=t3.a+111 
41          AND t3.a=t2.a+111
42          AND t2.a=t1.a+111;
48         FROM t1 JOIN (t2 JOIN (t3 JOIN t4 ON t4.a=t3.a+111)
49                               ON t3.a=t2.a+111)
50                      ON t2.a=t1.a+111;
55       SELECT t3.a
56         FROM t1 JOIN (t2 JOIN (t3 JOIN t4 ON t4.a=t3.a+111)
57                               ON t3.a=t2.a+111)
58                      ON t2.a=t1.a+111;
64         FROM t1 JOIN (t2 JOIN (t3 JOIN t4 ON t4.a=t3.a+111)
65                               ON t3.a=t2.a+111)
66                      ON t2.a=t1.a+111;
72         FROM t1 JOIN (t2 JOIN (t3 JOIN t4 ON t4.a=t3.a+111)
73                               ON t3.a=t2.a+111)
74                      ON t2.a=t1.a+111;
80         FROM t1 JOIN (t2 JOIN (main.t4 JOIN aux1.t4 ON aux1.t4.a=main.t4.a+111)
81                               ON main.t4.a=t2.a+222)
82                      ON t2.a=t1.a+111;
88         FROM t1 JOIN (t2 JOIN (main.t4 AS x JOIN aux1.t4 ON aux1.t4.a=x.a+111)
89                               ON x.a=t2.a+222)
90                      ON t2.a=t1.a+111;
96         FROM t1 JOIN (t2 JOIN (main.t4 JOIN aux.t4 ON aux.t4.a=main.t4.a+111)
97                               ON main.t4.a=t2.a+222)
98                      ON t2.a=t1.a+111;
103       SELECT x.a, y.b
104         FROM t1 JOIN (t2 JOIN (main.t4 x JOIN aux1.t4 y ON y.a=x.a+111)
105                               ON x.a=t2.a+222)
106                      ON t2.a=t1.a+111;
111       UPDATE t2 SET a=111;
112       UPDATE t3 SET a=111;
113       UPDATE t4 SET a=111;
115         FROM t1 JOIN (t2 JOIN (t3 JOIN t4 USING(a)) USING (a)) USING (a);
120       UPDATE t2 SET a=111;
121       UPDATE t3 SET a=111;
122       UPDATE t4 SET a=111;
124         FROM t1 LEFT JOIN (t2 LEFT JOIN (t3 LEFT JOIN t4 USING(a))
125                                         USING (a))
126                            USING (a);
131       UPDATE t3 SET a=222;
132       UPDATE t4 SET a=222;
134         FROM (t1 LEFT JOIN t2 USING(a)) JOIN (t3 LEFT JOIN t4 USING(a))
135              ON t1.a=t3.a-111;
140       UPDATE t4 SET a=333;
142         FROM (t1 LEFT JOIN t2 USING(a)) JOIN (t3 LEFT JOIN t4 USING(a))
143              ON t1.a=t3.a-111;
149         FROM (t1 LEFT JOIN t2 USING(a)) JOIN (t3 LEFT JOIN t4 USING(a))
150              ON t1.a=t3.a-111;
161   CREATE TABLE t41(a INTEGER PRIMARY KEY, b INTEGER);