Merge pull request #19628 from kamil-tekiela/Fix-mysql-default-value-insert

MauricioFauth · web-flow · commit b2cc10a4b323 · 2025-03-17T07:29:12.000-03:00
Fix mysql default value insert
diff --git a/src/InsertEdit.php b/src/InsertEdit.php
@@ -1865,7 +1865,11 @@ public function getHtmlForInsertEditRow(
     /** @return array<string|null> */
     public function getColumnDefaultValues(string $database, string $table): array
     {
-        $sql = 'SELECT COLUMN_NAME, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '
+        $sql = 'SELECT COLUMN_NAME, CASE WHEN INSTR(EXTRA, \'DEFAULT_GENERATED\')'
+            . ' THEN COLUMN_DEFAULT '
+            . ' ELSE CONCAT(\'\'\'\', COLUMN_DEFAULT, \'\'\'\')'
+            . ' END AS COLUMN_DEFAULT'
+            . ' FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '
             . $this->dbi->quoteString($table)
             . ' AND TABLE_SCHEMA = ' . $this->dbi->quoteString($database);
 
diff --git a/tests/unit/Controllers/Table/ReplaceControllerTest.php b/tests/unit/Controllers/Table/ReplaceControllerTest.php
@@ -133,7 +133,8 @@ public function testReplace(): void
         $dummyDbi->addSelectDb('my_db');
         $dummyDbi->addSelectDb('my_db');
         $dummyDbi->addResult(
-            'SELECT COLUMN_NAME, COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS '
+            "SELECT COLUMN_NAME, CASE WHEN INSTR(EXTRA, 'DEFAULT_GENERATED') THEN COLUMN_DEFAULT "
+                . "ELSE CONCAT('''', COLUMN_DEFAULT, '''') END AS COLUMN_DEFAULT FROM INFORMATION_SCHEMA.COLUMNS "
                 . "WHERE TABLE_NAME = 'test_tbl' AND TABLE_SCHEMA = 'my_db'",
             [],
         );
