Lines Matching refs:b1

314   CREATE TABLE b1(a, b, c);
319   CREATE VIEW vvv AS SELECT c+c || coalesce(c, c) FROM b1, b2 WHERE x=c GROUP BY c HAVING c>0;
320   ALTER TABLE b1 RENAME c TO "a;b";
322 } {{CREATE VIEW vvv AS SELECT "a;b"+"a;b" || coalesce("a;b", "a;b") FROM b1, b2 WHERE x="a;b" GROUP…
325   CREATE VIEW www AS SELECT b FROM b1 UNION ALL SELECT y FROM b2;
326   ALTER TABLE b1 RENAME b TO bbb;
328 } {{CREATE VIEW www AS SELECT bbb FROM b1 UNION ALL SELECT y FROM b2}}
333   CREATE VIEW xxx AS SELECT a FROM b1 UNION SELECT x FROM b2 ORDER BY 1 COLLATE nocase;
339 } {{CREATE VIEW xxx AS SELECT a FROM b1 UNION SELECT hello FROM b2 ORDER BY 1 COLLATE nocase}}
342   CREATE VIEW zzz AS SELECT george, ringo FROM b1;
343   ALTER TABLE b1 RENAME a TO aaa;