Lines Matching refs:o1

134     CREATE TABLE o1(w, x, y, z UNIQUE, PRIMARY KEY(w, x)) %WO%;
137     INSERT INTO o1 VALUES(0, 0, 'i', 'one');
138     INSERT INTO o1 VALUES(0, 1, 'ii', 'two');
139     INSERT INTO o1 VALUES(1, 0, 'iii', 'three');
140     INSERT INTO o1 VALUES(1, 1, 'iv', 'four');
142     CREATE TRIGGER tro1 BEFORE UPDATE ON o1 BEGIN
145     CREATE TRIGGER tro2 AFTER UPDATE ON o1 BEGIN
155     UPDATE o1 SET z=v FROM data WHERE (1+x+w*2)=k;
157     SELECT * FROM o1;
167     UPDATE o1 SET y=v FROM t2, t3 WHERE (1+o1.w*2+o1.x)=t2.a AND t3.k=t2.b;
169     SELECT * FROM o1;
182     UPDATE o1 SET z=v FROM data WHERE (1+w*2+x)=k;
184     SELECT * FROM o1;
195     CREATE VIEW w1 AS SELECT * FROM o1;
197       UPDATE o1 SET y=new.y, z=new.z WHERE w=new.w AND x=new.x;