Testing Create procedure with modifies option

iifawzi · iifawzi · commit 084ca3d80cb1 · 2023-01-17T18:14:35.000+02:00
Signed-off-by: Fawzi Abdulfattah &lt;iifawzie@gmail.com&gt;
diff --git a/tests/Builder/CreateStatementTest.php b/tests/Builder/CreateStatementTest.php
@@ -443,6 +443,23 @@ public function testBuilderViewComplex(): void
 
     public function testBuilderCreateProcedure(): void
     {
+
+        $parser = new Parser(
+            'CREATE DEFINER=`root`@`%`'
+            . ' PROCEDURE `test2`(IN `_var` INT) DETERMINISTIC'
+            . ' MODIFIES SQL DATA SELECT _var'
+        );
+
+        /** @var CreateStatement $stmt */
+        $stmt = $parser->statements[0];
+
+        $this->assertSame(
+            'CREATE DEFINER=`root`@`%`'
+            . ' PROCEDURE `test2` (IN `_var` INT)  DETERMINISTIC'
+            . ' MODIFIES SQL DATA SELECT _var',
+            $stmt->build()
+        );
+
         $parser = new Parser(
             'CREATE DEFINER=`root`@`%`'
             . ' PROCEDURE `test2`(IN `_var` INT) NOT DETERMINISTIC NO SQL'
