Don't remove characters from expression

M393 · M393 · commit f719f5e907e2 · 2026-03-19T19:36:17.000+01:00
Signed-off-by: Maximilian Krög &lt;maximilian.kroeg@geocept.com&gt;
diff --git a/libraries/classes/Table/ColumnsDefinition.php b/libraries/classes/Table/ColumnsDefinition.php
@@ -24,7 +24,9 @@
 use function in_array;
 use function intval;
 use function is_array;
+use function mb_strlen;
 use function mb_strtoupper;
+use function mb_substr;
 use function preg_quote;
 use function preg_replace;
 use function rtrim;
@@ -514,8 +516,6 @@ public static function decorateColumnMetaDefault(array $columnMeta): array
                 // Could be null or empty string here
                 if ($columnMeta['Default'] === null) {
                     $metaDefault['DefaultType'] = $columnMeta['Null'] === 'YES' ? 'NULL' : 'NONE';
-                } else {
-                    $columnMeta['DefaultValue'] = $columnMeta['Default'];
                 }
 
                 break;
@@ -531,8 +531,16 @@ public static function decorateColumnMetaDefault(array $columnMeta): array
                 break;
             default:
                 if (substr((string) $columnMeta['Type'], -4) === 'text') {
-                    $textDefault = substr($columnMeta['Default'], 1, -1);
-                    $metaDefault['DefaultValue'] = stripcslashes($textDefault);
+                    if (
+                        mb_strlen($columnMeta['Default']) >= 2 &&
+                        mb_substr($columnMeta['Default'], 0, 1) === "'" &&
+                        mb_substr($columnMeta['Default'], -1) === "'"
+                    ) {
+                        $textDefault = substr($columnMeta['Default'], 1, -1);
+                        $metaDefault['DefaultValue'] = stripcslashes($textDefault);
+                    } else {
+                        $metaDefault['DefaultValue'] = $columnMeta['Default'];
+                    }
                 } else {
                     $metaDefault['DefaultValue'] = $columnMeta['Default'];
                 }
