Fulltext-search with SearchableText() not working for mariadb

[chbister]

• Laravel Version: Laravel Framework 11.41.3
• Nova Version: v5.1.10 (Silver Surfer)
• PHP Version: 8.3.15
• Database Driver & Version: mariadb, 11.5.2-MariaDB-ubu2404
• Operating System and Version: Linux foobar 6.1.0-30-amd64 Unable to compile laravel-nova JS #1 SMP PREEMPT_DYNAMIC Debian 6.1.124-1 (2025-01-12) x86_64 GNU/Linux

Description:

When using "mariadb" database driver the usage of SearchableText() in searchableColumns() in a Resource class does not add the fulltext query part thus returning no search results.

public static function searchableColumns(): array
{
    return [new SearchableText('name')];
}

I guess issue lies within vendor/laravel/nova/src/Query/Search/SearchableText.php in following line, as $connectionType='mariadb' is not handled.

if (in_array($connectionType, ['mysql', 'pgsql'])) {

Should be like this:

if (in_array($connectionType, ['mariadb', 'mysql', 'pgsql'])) {

Detailed steps to reproduce the issue on a fresh Nova installation:

1. create a new migration and model, set $table->fullText('<column_name>') in the migration for the desired text column
2. create a new Resource for a model
3. remove the static $search variable
4. create the searchableColumns() function as described here: https://nova.laravel.com/docs/v5/search/the-basics#full-text-indexes
5. set DB_CONNECTION=mysql in .env to see it working
6. set DB_CONNECTION=mariadb in .env to see it failing

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.