Wrong unique index from migration

[jirapetr]

Wrong unique index

this update
#600
46e6f7b
made unique index with lower() PHP function in migration laravel script
for example: create unique index card_types_id_card_type_uk on card_types (lower(id_card_type))
problem:
if I want add make foring key to this master table/colum (id_card_type)
it emit error: that no primary kye or unique index exist

Code snippet of problem

public function compileUnique(Blueprint $blueprint, Fluent $command)
{
$columns = array_map(function ($column) {
$column = $this->wrap($column);
return "lower({$column})";
}, $command->columns);

    $columns = implode(', ', $columns);

    return sprintf('create unique index %s on %s (%s)', $command->index, $this->wrapTable($blueprint), $columns);
}

Please remove lower function in compileUnique()

System details

• Linux
• PHP 8n
• Laravel Version 8
• Laravel-OCI8 Version: 8

[yajra]

Can you please provide a working script to replicates the issue?

[jirapetr]

On Laravel migration script:
TABLE MASTER:
$table->unsignedBigInteger('id_card_type')->unique();

TABLE SLAVE:
$table->foreign('id_card_type')->references('id_card_type')->on('table_master')->onDelete('CASCADE');
// this emit error: that no primary kye or unique index exist

[jirapetr]

migration, resp. function compileUnique it should use "lower()" function only for var/text type of DB colums (not for int)

[github-actions]

This issue is stale because it has been open for 30 days with no activity.

[github-actions]

This issue was closed because it has been inactive for 7 days since being marked as stale.