X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F44-xml-to-db2-array.t;h=065fc35954d0db5fcdca68e7db9339680f0976bc;hb=bc2ed06a8bade37c1bfdc8a918c41b6cab49474d;hp=fa73159eea55a4ff238fa956027497d29e3d2de6;hpb=410d4a4252243e6679a9303fbcb7a94e5e1588d1;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/44-xml-to-db2-array.t b/t/44-xml-to-db2-array.t
index fa73159..065fc35 100644
--- a/t/44-xml-to-db2-array.t
+++ b/t/44-xml-to-db2-array.t
@@ -61,7 +61,9 @@ q|CREATE TABLE Another (
 'CREATE VIEW email_list AS
 SELECT email FROM Basic WHERE email IS NOT NULL;',
 
-'CREATE TRIGGER foo_trigger after insert ON Basic REFERENCING OLD AS oldrow NEW AS newrow FOR EACH ROW MODE DB2SQL update modified=timestamp();'
+'CREATE TRIGGER foo_trigger after insert ON Basic REFERENCING OLD AS oldrow NEW AS newrow FOR EACH ROW MODE DB2SQL update modified=timestamp();',
+
+'CREATE TRIGGER bar_trigger before insert, update ON Basic REFERENCING OLD AS oldrow NEW AS newrow FOR EACH ROW MODE DB2SQL update modified2=timestamp();',
 ];
 
 is_deeply(\@sql, $want, 'Got correct DB2 statements in list context');