Home
last modified time | relevance | path

Searched refs:TRIGGER (Results 1 – 18 of 18) sorted by relevance

/illumos-gate/usr/src/lib/libsqlite/test/
H A Dtrigger1.test14 # 1. CREATE and DROP TRIGGER tests
18 # trig-1.4: DROP TRIGGER removes trigger
36 CREATE TRIGGER trig UPDATE ON no_such_table BEGIN
43 CREATE TEMP TRIGGER trig UPDATE ON no_such_table BEGIN
53 CREATE TRIGGER tr1 INSERT ON t1 BEGIN
59 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
68 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
71 CREATE TRIGGER tr2 INSERT ON t1 BEGIN
78 DROP TRIGGER tr1;
79 CREATE TRIGGER tr1 DELETE ON t1 BEGIN
[all …]
H A Dmain.test81 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr;
86 CREATE TRIGGER xyz AFTER DELETE abc BEGIN UPDATE pqr; END;
91 CREATE TRIGGER xyz AFTER DELETE abc BEGIN
98 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
104 CREATE TRIGGER xyz AFTER DELETE end BEGIN
110 CREATE TRIGGER xyz AFTER DELETE end BEGIN
117 CREATE TRIGGER xyz AFTER DELETE end BEGIN
125 CREATE TRIGGER xyz AFTER DELETE [;end;] BEGIN
131 CREATE TRIGGER xyz AFTER DELETE backend BEGIN
138 TRIGGER xyz AFTER DELETE backend BEGIN
[all …]
H A Dtrigger2.test83 CREATE TRIGGER before_update_row BEFORE UPDATE ON tbl FOR EACH ROW
91 CREATE TRIGGER after_update_row AFTER UPDATE ON tbl FOR EACH ROW
99 CREATE TRIGGER conditional_update_row AFTER UPDATE ON tbl FOR EACH ROW
126 CREATE TRIGGER delete_before_row BEFORE DELETE ON tbl FOR EACH ROW
134 CREATE TRIGGER delete_after_row AFTER DELETE ON tbl FOR EACH ROW
154 CREATE TRIGGER insert_before_row BEFORE INSERT ON tbl FOR EACH ROW
162 CREATE TRIGGER insert_after_row AFTER INSERT ON tbl FOR EACH ROW
289 execsql "CREATE TRIGGER the_trigger BEFORE [string range $statement 0 6]\
294 execsql "DROP TRIGGER the_trigger;"
301 execsql "CREATE TRIGGER the_trigger AFTER [string range $statement 0 6]\
[all …]
H A Dtrigger3.test22 CREATE TRIGGER before_tbl_insert BEFORE INSERT ON tbl BEGIN SELECT CASE
26 CREATE TRIGGER after_tbl_insert AFTER INSERT ON tbl BEGIN SELECT CASE
98 CREATE TRIGGER before_tbl_update BEFORE UPDATE ON tbl BEGIN
102 CREATE TRIGGER before_tbl_delete BEFORE DELETE ON tbl BEGIN
122 CREATE TRIGGER after_tbl2_insert AFTER INSERT ON tbl2 BEGIN
138 CREATE TRIGGER tbl_view_insert INSTEAD OF INSERT ON tbl_view BEGIN
H A Dattach.test211 CREATE TRIGGER r1 AFTER UPDATE ON t2 FOR EACH ROW BEGIN
420 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
430 CREATE TRIGGER t3r3 AFTER INSERT ON t3 BEGIN
487 CREATE TRIGGER r1 AFTER INSERT ON orig.t1 BEGIN;
495 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
502 DROP TRIGGER r5;
503 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
511 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
518 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
525 CREATE TRIGGER r5 AFTER INSERT ON t5 BEGIN
[all …]
H A Dversion.test103 CREATE TRIGGER r1 AFTER INSERT ON t1 FOR EACH ROW BEGIN
106 CREATE TRIGGER r2 AFTER DELETE ON t1 FOR EACH ROW BEGIN
109 CREATE TRIGGER r3 AFTER INSERT ON t2 FOR EACH ROW BEGIN
112 CREATE TRIGGER r4 AFTER DELETE ON t2 FOR EACH ROW BEGIN
H A Dauth.test849 CREATE TRIGGER r2 DELETE on t2 BEGIN
868 CREATE TRIGGER r2 DELETE on t2 BEGIN
885 CREATE TRIGGER r2 DELETE on t2 BEGIN
904 CREATE TRIGGER r2 DELETE on t2 BEGIN
922 CREATE TRIGGER r2 AFTER INSERT ON t2 BEGIN
963 CREATE TRIGGER r1 DELETE on t1 BEGIN
982 CREATE TRIGGER r1 DELETE on t1 BEGIN
999 CREATE TRIGGER r1 DELETE on t1 BEGIN
1018 CREATE TRIGGER r1 DELETE on t1 BEGIN
1035 CREATE TRIGGER r1 DELETE on t1 BEGIN
[all …]
H A Dvacuum.test69 CREATE TRIGGER r1 AFTER DELETE ON t2 BEGIN
H A Dmisc2.test27 CREATE TRIGGER foo_insert BEFORE INSERT ON foo BEGIN
H A Ddelete.test216 CREATE TRIGGER r1 AFTER DELETE ON t3 FOR EACH ROW BEGIN
H A Dmalloc.test206 CREATE TRIGGER r1 AFTER INSERT ON t1 BEGIN
H A Dmisc3.test264 CREATE TRIGGER r1 AFTER DELETE ON y1 FOR EACH ROW BEGIN
H A Dmisc1.test529 CREATE TEMP TRIGGER trigTest_1 AFTER UPDATE ON TempTable BEGIN
H A Drowid.test377 CREATE TRIGGER r3 AFTER INSERT on t3 FOR EACH ROW BEGIN
/illumos-gate/usr/src/uts/sparc/ml/
H A Dfd_asm.S57 #define TRIGGER 0x33 macro
/illumos-gate/usr/src/uts/common/io/bnx/570x/driver/common/lmdev/
H A Dbnx_lm_recv.c323 TRIGGER(pdev, TEST_MODE_VERIFY_RX_CRC); in get_packets_rcvd()
802 TRIGGER(pdev, TEST_MODE_VERIFY_RX_CRC); in get_packets_rcvd()
H A Dlm5706.h1695 #define TRIGGER(_pdev, _val) REG_WR(_pdev, misc.misc_id, _val) macro
/illumos-gate/usr/src/lib/libsqlite/src/
H A Dparse.y129 TEMP TRIGGER VACUUM VIEW.
800 trigger_decl ::= temp(T) TRIGGER nm(B) trigger_time(C) trigger_event(D)
880 cmd ::= DROP TRIGGER nm(X) dbnm(D). {