Index Names Not Applied to Database When Using Annotations

[lotyp]

No duplicates 🥲.

• I have searched for a similar issue in our bug tracker and didn't find any solutions.

What happened?

Problem Description

When defining annotations and using the name parameter for indexes, the names defined in the annotation are not applied to the database. Instead, random names are generated and used.

Example Entity:

<?php

declare(strict_types=1);

namespace WayOfDev\Cycle\Bridge\Telescope\Entities;

use Cycle\Annotated\Annotation\Column;
use Cycle\Annotated\Annotation\Entity;
use Cycle\Annotated\Annotation\ForeignKey;
use Cycle\Annotated\Annotation\Table\Index;
use DateTimeImmutable;

#[Index(columns: ['uuid'], unique: true, name: 'telescope_entries_uuid_unique')]
#[Index(columns: ['batch_id'], name: 'telescope_entries_batch_id_index')]
#[Index(columns: ['family_hash'], name: 'telescope_entries_family_hash_index')]
#[Index(columns: ['created_at'], name: 'telescope_entries_created_at_index')]
#[Index(columns: ['type', 'should_display_on_index'], name: 'telescope_entries_type_should_display_on_index_index')]
#[Entity(table: 'telescope_entries')]
class TelescopeEntry
{
    #[Column(type: 'primary')]
    public int $sequence;

    #[Column(type: 'uuid')]
    public string $uuid;

    #[Column(type: 'uuid')]
    public string $batchId;

    #[Column(type: 'string', nullable: true)]
    public string $familyHash;

    #[Column(type: 'boolean', default: true)]
    public bool $shouldDisplayOnIndex;

    #[Column(type: 'string', size: 20)]
    public string $type;

    #[Column(type: 'longText')]
    public string $content;

    #[Column(type: 'datetime', nullable: true)]
    public ?DateTimeImmutable $createdAt;
}

Expected Result

In the database, I expect to see the names that I have used in annotations, as shown below:

Current Result

Instead of the defined names, random names are generated and used, as shown below:

Also, composite key, instead of name, has hash number.

Version

ORM 2.7.1
PHP 8.2
Database: SQLite

[lotyp]

Can't reproduce anymore on my side. Could be problem with sqlite database caching.