Lines Matching refs:u1

135   CREATE TABLE u1(a, b, c, PRIMARY KEY(b, c)) WITHOUT ROWID;
136   INSERT INTO u1 VALUES(0, 0, 0);
137   INSERT INTO u1 VALUES(1, 0, 1);
138   INSERT INTO u1 VALUES(2, 1, 0);
139   INSERT INTO u1 VALUES(3, 1, 1);
146   UPDATE u1 SET c=t FROM map WHERE c=f;
147   SELECT * FROM u1 ORDER BY a;
156   UPDATE u1 SET b=t FROM map WHERE b=f;
157   SELECT * FROM u1 ORDER BY a;
170   UPDATE u1 SET b=n1, c=n2 FROM map2 WHERE b=o1 AND c=o2;
171   SELECT * FROM u1 ORDER BY a;