Laravel `unsignedFloat` creates unsigned DOUBLE (8, 2) column #bug

[raimondsL]

• Laravel Version: 8.83.11
• PHP Version: 8.0
• Database Driver & Version: MariaDB latest

Description:

Laravel unsignedFloat creates unsigned DOUBLE (8, 2) column #bug

Steps To Reproduce:

        Schema::create('test_table', function (Blueprint $table) {
            $table->unsignedFloat('quantity')->default(1);
        });

[rodrigopedra]

Changing from DOUBLE to FLOAT is, in my opinion, very unlikely to happen, as this was changed 8 years ago in Laravel 5.0, and changing it back to FLOAT might break people apps.

If you want to change the precision, e.g. the (8,2) part to be added, you can either:

• specify custom values: $table->unsignedFloat('quantity', 10, 4)->default(1);
• use zero on either parameter to remove the precision altogether: $table->unsignedFloat('quantity', 0)->default(1);

Hope this helps:

reference: 0c0a717

related closed PR: #33245

[driesvints]

Please see previous issues around this subject why we can't change this.

Thanks @rodrigopedra