[Scanner] CHD files wrongly named in playlist

Description

I recently got CHD files for my games. When scanning, some games are wrongly named in the playlist.

Examples with Sega Dreamcast games:

Crazy Taxi (Europe).chd becomes Crazy Taxi (USA) in the playlist
Skies of Arcadia (Europe) (En,Fr,De,Es) (Disc 1).chd becomes Skies of Arcadia (USA) (Disc 1) in the playlist

I checked by extracting the CHD by using chdman extractcd --input infile.chd --output outfile.gdi:

The GDI file is correctly recognized by the scanner
The bin/raw sha1 sums correspond to the European version, according to redump.org

I don't know if this happens for other consoles or if this is limited to Dreamcast games.

The issue seems related to searching Serial vs CRC in the database (cf the playlist contents). According to redump.org:

Skies of Arcadia (Europe) (Disc 1) has serial MK-51052-50
Skies of Arcadia (USA) (Disc 1) has serial 51052
Crazy Taxi (Europe) has serial MK-51035-50
Crazy Taxi (USA) has serial 51035

Expected behavior

The playlist should contain

    {
      "path": "/path/Skies of Arcadia (Europe) (En,Fr,De,Es) (Disc 1)03.bin",
      "label": "Skies of Arcadia (Europe) (En,Fr,De,Es) (Disc 1)",
      "core_path": "DETECT",
      "core_name": "DETECT",
      "crc32": "495F4A18|crc",
      "db_name": "Sega - Dreamcast.lpl"
    },
    {
      "path": "/path/Crazy Taxi (Europe)03.bin",
      "label": "Crazy Taxi (Europe)",
      "core_path": "DETECT",
      "core_name": "DETECT",
      "crc32": "0F6CF69C|crc",
      "db_name": "Sega - Dreamcast.lpl"
    },

Actual behavior

The playlist contains

    {
      "path": "/path/Skies of Arcadia (Europe) (En,Fr,De,Es) (Disc 1).chd",
      "label": "Skies of Arcadia (USA) (Disc 1)",
      "core_path": "DETECT",
      "core_name": "DETECT",
      "crc32": "51052-0|serial",
      "db_name": "Sega - Dreamcast.lpl"
    },
    {
      "path": "/path/Crazy Taxi (Europe).chd",
      "label": "Crazy Taxi (USA)",
      "core_path": "DETECT",
      "core_name": "DETECT",
      "crc32": "51035|serial",
      "db_name": "Sega - Dreamcast.lpl"
    },

Steps to reproduce the bug

Get some CHD games (or convert using chdman from GDI)
Scan the directory from RetroArch
Check the created playlist

Bisect Results

I tried with the AppImage version 1.14.0 and 1.16.0, the results are the same.

Version/Commit

RetroArch: 1.14.0 (e3c92b0) and 1.16.0 (14cb373)

Environment information

OS: Debian 12

libretro / RetroArch