Lines Matching refs:link

26   CREATE TABLE link(aa INT, bb INT);
27   CREATE INDEX link_f ON link(aa,bb);
28   CREATE INDEX link_t ON link(bb,aa);
29   INSERT INTO link(aa,bb) VALUES
45      SELECT aa FROM closure, link WHERE link.bb=closure.x
47      SELECT bb FROM closure, link WHERE link.aa=closure.x
55      SELECT aa FROM link, closure WHERE link.bb=closure.x
57      SELECT bb FROM closure, link WHERE link.aa=closure.x
65      SELECT bb FROM closure, link WHERE link.aa=closure.x
67      SELECT aa FROM link, closure WHERE link.bb=closure.x
77      SELECT bb FROM closure, link WHERE link.aa=closure.x
79      SELECT aa FROM link, closure WHERE link.bb=closure.x
89      SELECT bb FROM closure, link WHERE link.aa=closure.x
91      SELECT aa FROM link, closure WHERE link.bb=closure.x
102      SELECT bb FROM closure, link WHERE link.aa=closure.x
104      SELECT aa FROM link, closure WHERE link.bb=closure.x
114      SELECT bb FROM closure, link WHERE link.aa=closure.x
116      SELECT aa FROM link, closure WHERE link.bb=closure.x
125     SELECT aa FROM link JOIN closure ON bb=x
127     SELECT bb FROM link JOIN closure on aa=x
138     SELECT aa FROM link JOIN closure ON bb=x
140     SELECT bb FROM link JOIN closure on aa=x