MariaDB column defaults may or may not be quoted

[asmecher]

Laravel Version

11.44.1 (also in newer branches)

PHP Version

8.4.6 (PHP version is not a factor)

Database Driver & Version

MariaDB 10.11.13 on Ubuntu

Description

Because of MDEV-13132, releases of MariaDB since 10.2.7 quote string literal column defaults in the information_schema. (MySQL does not currently do this.)

Therefore, depending on what version of MariaDB you're using, calls to Schema::getColumns to determine column details might give you a quoted string, or not, depending on the version of the DBMS.

Steps To Reproduce

Test script:

<?php

require_once('vendor/autoload.php');

use Illuminate\Database\Capsule\Manager as Capsule;
use Illuminate\Database\Schema\Blueprint;

$capsule = new Capsule;

$capsule->addConnection([
    'driver' => 'mariadb',
    'host' => '127.0.0.1',
    'database' => 'DATABASE_NAME_HERE',
    'username' => 'USERNAME_HERE',
    'password' => 'PASSWORD_HERE',
    'charset' => 'utf8',
    'collation' => 'utf8_unicode_ci',
    'prefix' => '',
]);

$capsule->setAsGlobal();
$schema = $capsule->schema();

// Clean up from a previous run if necessary, and create a table for testing purposes.
if ($schema->hasTable('test_table')) $schema->drop('test_table');
$schema->create('test_table', function (Blueprint $table) {
    $table->string('test_string')->default('Some default');
});

$columns = $schema->getColumns('test_table');
$column = $columns[0];
echo "The column default is: {$column['default']}\n";

Results with MariaDB 10.2.7 or newer:

The column default is: 'Some default'

Results with MariaDB older than 10.2.7, or any MySQL:

The column default is: Some default

While this is a behavioural change to MariaDB, it would be nice for Laravel to hide this quirk from the caller -- probably by overriding the MySQL schema grammar's implementation of compileColumns to account for it.

[github-actions]

Thank you for reporting this issue!

As Laravel is an open source project, we rely on the community to help us diagnose and fix issues as it is not possible to research and fix every issue reported to us via GitHub.

If possible, please make a pull request fixing the issue you have described, along with corresponding tests. All pull requests are promptly reviewed by the Laravel team.

Thank you!

[hafezdivandari]

• This is how MariaDB prior 10.2.7 works and it is not easy to normalize the default expression when inpspecting the column, lot of edge cases!
• Laravel supports MariaDB 10.3+

[asmecher]

Laravel supports MariaDB 10.3+

Thanks, this is good enough for me -- Laravel 11 is currently the oldest supported version and it requires at least MariaDB 10.3.

Closing as a WONTFIX since anything older is either unmaintained or out of spec.