Fix #11979 DECLARE not accepted as valid SQL

Signed-off-by: Madhura Jayaratne <madhura.cj@gmail.com>

1 files changed, 12 insertions, 0 deletions

diff --git a/lint.php b/lint.php
index 3aee35ba96..0ee1e28e7b 100644
--- a/lint.php
+++ b/lint.php
@@ -35,4 +35,16 @@ PMA_Response::getInstance()->disable();
 
 PMA_headerJSON();
 
+if (! empty($_POST['options'])) {
+    $options = $_POST['options'];
+
+    if (! empty($options['routine_editor'])) {
+        $sql_query = 'CREATE PROCEDURE `a`() ' . $sql_query;
+    } elseif (! empty($options['trigger_editor'])) {
+        $sql_query = 'CREATE TRIGGER `a` AFTER INSERT ON `b` FOR EACH ROW ' . $sql_query;
+    } elseif (! empty($options['event_editor'])) {
+        $sql_query = 'CREATE EVENT `a` ON SCHEDULE EVERY MINUTE DO ' . $sql_query;
+    }
+}
+
 echo json_encode(PMA_Linter::lint($sql_query));