X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F48xml-to-sqlite.t;fp=t%2F48xml-to-sqlite.t;h=427f0d2d3ac3b87590a70d492a5b1643bcae0019;hb=410d4a4252243e6679a9303fbcb7a94e5e1588d1;hp=4dd1da7debb70d0e9345d83cd0c4f9f699390e1d;hpb=9768b204bf349afdbcf278f5fc06eb5077eb4aef;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/48xml-to-sqlite.t b/t/48xml-to-sqlite.t
index 4dd1da7..427f0d2 100644
--- a/t/48xml-to-sqlite.t
+++ b/t/48xml-to-sqlite.t
@@ -71,6 +71,14 @@ DROP TRIGGER IF EXISTS foo_trigger;
 
 CREATE TRIGGER foo_trigger after insert on Basic BEGIN update modified=timestamp(); END;
 
+DROP TRIGGER IF EXISTS bar_trigger_insert;
+
+CREATE TRIGGER bar_trigger_insert before insert on Basic BEGIN update modified2=timestamp(); END;
+
+DROP TRIGGER IF EXISTS bar_trigger_update;
+
+CREATE TRIGGER bar_trigger_update before update on Basic BEGIN update modified2=timestamp(); END;
+
 COMMIT;
 SQL
 
@@ -108,7 +116,12 @@ CREATE VIEW email_list AS
     SELECT email FROM Basic WHERE email IS NOT NULL',
           'DROP TRIGGER IF EXISTS foo_trigger',
           'CREATE TRIGGER foo_trigger after insert on Basic BEGIN update modified=timestamp(); END',
-          'COMMIT'
+          'DROP TRIGGER IF EXISTS bar_trigger_insert',
+          'CREATE TRIGGER bar_trigger_insert before insert on Basic BEGIN update modified2=timestamp(); END',
+          'DROP TRIGGER IF EXISTS bar_trigger_update',
+          'CREATE TRIGGER bar_trigger_update before update on Basic BEGIN update modified2=timestamp(); END',
+          'COMMIT',
+
           ], 'SQLite translate in list context matches');