stackrender
diff --git a/‎test/mysql-mariadb.spec.js‎
Lines changed: 7 additions & 0 deletions b/‎test/mysql-mariadb.spec.js‎
Lines changed: 7 additions & 0 deletions
@@ -629,6 +629,13 @@ describe('mysql', () => {
           'CREATE TRIGGER `trigger1` BEFORE UPDATE ON `merge` FOR EACH ROW SET `NEW`.`updated_at` = current_timestamp()'
         ]
       },
+      {
+        title: 'create trigger with trigger order',
+        sql: [
+          'create trigger trigger1 before update on merge for each row  follows trigger2 set NEW.updated_at = current_timestamp()',
+          'CREATE TRIGGER `trigger1` BEFORE UPDATE ON `merge` FOR EACH ROW FOLLOWS `trigger2` SET `NEW`.`updated_at` = current_timestamp()'
+        ]
+      },
     ]
     SQL_LIST.forEach(sqlInfo => {
       const { title, sql } = sqlInfo
Original file line number	Diff line number	Diff line change
`@@ -629,6 +629,13 @@ describe('mysql', () => {`
`629`	`629`	'CREATE TRIGGER `trigger1` BEFORE UPDATE ON `merge` FOR EACH ROW SET `NEW`.`updated_at` = current_timestamp()'
`630`	`630`	`]`
`631`	`631`	`},`
	`632`	`+ {`
	`633`	`+ title: 'create trigger with trigger order',`
	`634`	`+ sql: [`
	`635`	`+ 'create trigger trigger1 before update on merge for each row follows trigger2 set NEW.updated_at = current_timestamp()',`
	`636`	+ 'CREATE TRIGGER `trigger1` BEFORE UPDATE ON `merge` FOR EACH ROW FOLLOWS `trigger2` SET `NEW`.`updated_at` = current_timestamp()'
	`637`	`+ ]`
	`638`	`+ },`
`632`	`639`	`]`
`633`	`640`	`SQL_LIST.forEach(sqlInfo => {`
`634`	`641`	`const { title, sql } = sqlInfo`