Lines Matching refs:x

42   WITH RECURSIVE closure(x) AS (
45      SELECT aa FROM closure, link WHERE link.bb=closure.x
47      SELECT bb FROM closure, link WHERE link.aa=closure.x
49   SELECT x FROM closure ORDER BY x;
52   WITH RECURSIVE closure(x) AS (
55      SELECT aa FROM link, closure WHERE link.bb=closure.x
57      SELECT bb FROM closure, link WHERE link.aa=closure.x
59   SELECT x FROM closure ORDER BY x;
62   WITH RECURSIVE closure(x) AS (
65      SELECT bb FROM closure, link WHERE link.aa=closure.x
67      SELECT aa FROM link, closure WHERE link.bb=closure.x
69   SELECT x FROM closure ORDER BY x;
72   WITH RECURSIVE closure(x) AS (
77      SELECT bb FROM closure, link WHERE link.aa=closure.x
79      SELECT aa FROM link, closure WHERE link.bb=closure.x
81   SELECT x FROM closure ORDER BY x;
84   WITH RECURSIVE closure(x) AS (
89      SELECT bb FROM closure, link WHERE link.aa=closure.x
91      SELECT aa FROM link, closure WHERE link.bb=closure.x
93   SELECT x FROM closure ORDER BY x;
97   WITH RECURSIVE closure(x) AS (
102      SELECT bb FROM closure, link WHERE link.aa=closure.x
104      SELECT aa FROM link, closure WHERE link.bb=closure.x
106   SELECT x FROM closure ORDER BY x;
109   WITH RECURSIVE closure(x) AS (
114      SELECT bb FROM closure, link WHERE link.aa=closure.x
116      SELECT aa FROM link, closure WHERE link.bb=closure.x
118   SELECT x FROM closure ORDER BY x;
122   WITH RECURSIVE closure(x) AS (
123     SELECT 1 AS x
125     SELECT aa FROM link JOIN closure ON bb=x
127     SELECT bb FROM link JOIN closure on aa=x
128     ORDER BY x LIMIT 4
133   WITH RECURSIVE closure(x) AS (
134     SELECT 1 AS x
138     SELECT aa FROM link JOIN closure ON bb=x
140     SELECT bb FROM link JOIN closure on aa=x
141     ORDER BY x LIMIT 4
157   WITH RECURSIVE closure(x) AS (
160     SELECT aa2 FROM linkA JOIN closure ON x=aa1
162     SELECT bb2 FROM linkB JOIN closure ON x=bb1
164     SELECT cc2 FROM linkC JOIN closure ON x=cc1
166     SELECT dd2 FROM linkD JOIN closure ON x=dd1
168   SELECT x FROM closure ORDER BY +x;
179   WITH RECURSIVE closure(x) AS (
182     SELECT aa2 FROM linkA_ipk JOIN closure ON x=aa1
184     SELECT bb2 FROM linkB_ipk JOIN closure ON x=bb1
186     SELECT cc2 FROM linkC_ipk JOIN closure ON x=cc1
188     SELECT dd2 FROM linkD_ipk JOIN closure ON x=dd1
190   SELECT x FROM closure ORDER BY +x;