Lines Matching refs:insert

66 # On an ON CONFLICT DO UPDATE, the before-insert, before-update, and
75         VALUES('before-insert',format('%d,%d,%d',new.a,new.b,new.c));
79         VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
96 } {before-insert 1,2,0 before-update 1,2,0/1,2,1 after-update 1,2,0/1,2,1}
98 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
104 } {before-insert 1,2,0}
106 # With ON CONFLICT DO UPDATE and a failed WHERE, only the before-insert
114 } {before-insert 1,2,0}
126         VALUES('before-insert',format('%d,%d,%d',new.a,new.b,new.c));
130         VALUES('after-insert',printf('%d,%d,%d',new.a,new.b,new.c));
147 } {before-insert 1,2,0 before-update 1,2,0/1,2,1 after-update 1,2,0/1,2,1}
149 # On an ON CONFLICT DO NOTHING, only the before-insert trigger fires.
155 } {before-insert 1,2,0}
157 # With ON CONFLICT DO UPDATE and a failed WHERE, only the before-insert
165 } {before-insert 1,2,0}