Fixing the alter operation table options

Signed-off-by: Fawzi Abdulfattah <iifawzie@gmail.com>
phpmyadmin · Jan 15, 2023 · b4a2e3f · b4a2e3f
1 parent e6320e9
commit b4a2e3f
Show file tree

Hide file tree

Showing 3 changed files with 758 additions and 2 deletions.
diff --git a/src/Components/AlterOperation.php b/src/Components/AlterOperation.php
@@ -116,7 +116,6 @@ class AlterOperation extends Component
         'COLUMN' => 2,
         'CONSTRAINT' => 2,
         'DEFAULT' => 2,
-        'TO' => 2,
         'BY' => 2,
         'FOREIGN' => 2,
         'FULLTEXT' => 2,
@@ -128,9 +127,16 @@ class AlterOperation extends Component
         'PRIMARY KEY' => 2,
         'SPATIAL' => 2,
         'TABLESPACE' => 2,
-        'INDEX' => 2,
+        'INDEX' => [
+            2,
+            'var',
+        ],
 
         'CHARACTER SET' => 3,
+        'TO' => [
+            3,
+            'var',
+        ],
     ];
 
     /**

diff --git a/tests/data/parser/parseAlterTableRenameIndex.in b/tests/data/parser/parseAlterTableRenameIndex.in
@@ -0,0 +1 @@
+ALTER TABLE `transactions` RENAME INDEX `fk_transactions_catalog_entries1_idx` TO `fk_transactions_catalog_entries2_idx`