Error when using foreignIdFor with bigInt primary key without auto increment

[rhandrade]

• Laravel Version: 10.0.3
• PHP Version: 8.2.3
• Database Driver & Version: MySQL 8.0.32

Description:

The foreignIdFor method when used with a bigInt primary key that is not AUTO INCREMENT produces a column of type char in the database, so the constraint does not work correctly.

Probably the error happens due to validation of the value of incrementing inside the method:

Steps To Reproduce:

1. Creates a main migration and sets unsignedBigInteger and primary:

Schema::create('my_tables', function (Blueprint $table) {
    $table->unsignedBigInteger('id')->primary();
    $table->string('some_another_field');        
    $table->timestamps();        
});

2. Create a second migration and adds foreignIdFor.

Schema::create('your_tables', function (Blueprint $table) {
    $table->foreignIdFor(MyTable::class)->constrained();
    $table->string('another_field');        
    $table->timestamps();
});

4. Define public $incrementing = false; in MyTable model class.

5. Runs php artisan migrate or php artisan migrate:fresh to verify error:

Referencing column 'my_table_id' and referenced column 'id' in foreign key constraint 
'your_tables_my_table_id_foreign' are incompatible.

[driesvints]

I think you're correct about this. However, at the same time I don't think we can change this on the current major release because it would be breaking for anyone expecting the current behavior.

One solution would be to send in a fix for 11.x to master. Another one to try adding a new method with the behavior you want. I'll leave it up to you to decide which PR you want to send in. Thanks!

[Safuji]

Will this ever get Fixed?

[driesvints]

Nobody has sent in a PR yet I believe.