Cascade drop pg tables to overcome key constraints when dropping

[dbsrgits/SQL-Translator.git] / t / 02mysql-parser.t

diff --git a/t/02mysql-parser.t b/t/02mysql-parser.t
index 378e73e..980fa7f 100644 (file)
--- a/t/02mysql-parser.t
+++ b/t/02mysql-parser.t
@@ -427,7 +427,7 @@ BEGIN {
 
             ALTER TABLE one ADD FOREIGN KEY (two_id) REFERENCES two (id);
 
-            INSERT absolutely *#! any old $£ ? rubbish ;
+            INSERT absolutely *#! any old $£ ? rubbish, even "quoted; semi-what""sits";
         ]
     ) or die $tr->error;
 
@@ -479,8 +479,11 @@ BEGIN {
     my $tr = SQL::Translator->new;
     my $data = parse($tr, 
         q[
-            /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
+               DELIMITER ;;
+            /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;;
+                       /*!50003 CREATE */ /*!50017 DEFINER=`cmdomain`@`localhost` */ /*!50003 TRIGGER `acl_entry_insert` BEFORE INSERT ON `acl_entry` FOR EACH ROW SET NEW.dateCreated = CONVERT_TZ(SYSDATE(),'SYSTEM','+0:00'), NEW.dateModified = CONVERT_TZ(SYSDATE(),'SYSTEM','+0:00') */;;
 
+                       DELIMITER ;
             CREATE TABLE one (
               `op` varchar(255) character set latin1 collate latin1_bin default NULL,
               `last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,