Excluding packages with a range excludes more packages than intended

[etnguyen03]

Affected Version

yay v12.3.0 - libalpm v13.0.2

The same also happens with the latest yay-git: yay v12.3.0.r1.gf7f2169 - libalpm v13.0.2

Describe the bug

Excluding packages with a range appears to exclude one more package than intended.

Reproduction Steps

1. Run yay with >1 AUR package to upgrade
2. Type a range, i.e. 1-n, to exclude the packages 1...n

Expected behavior

The packages 1...n are not upgraded, but the packages (n + 1)... are upgraded.

Output

$ yay
:: Synchronizing package databases...
 core is up to date
 extra is up to date
 multilib is up to date
:: Searching AUR for updates...
:: Searching databases for updates...
:: 9 packages to upgrade/install.
9  aur/opera                  107.0.5045.15-1   -> 107.0.5045.21-1
8  aur/ttf-ms-win11           10.0.22631.2506-1 -> 10.0.22631.3155-1
7  aur/ttf-ms-win11-japanese  10.0.22631.2506-1 -> 10.0.22631.3155-1
6  aur/ttf-ms-win11-korean    10.0.22631.2506-1 -> 10.0.22631.3155-1
5  aur/ttf-ms-win11-other     10.0.22631.2506-1 -> 10.0.22631.3155-1
4  aur/ttf-ms-win11-sea       10.0.22631.2506-1 -> 10.0.22631.3155-1
3  aur/ttf-ms-win11-thai      10.0.22631.2506-1 -> 10.0.22631.3155-1
2  aur/ttf-ms-win11-zh_cn     10.0.22631.2506-1 -> 10.0.22631.3155-1
1  aur/ttf-ms-win11-zh_tw     10.0.22631.2506-1 -> 10.0.22631.3155-1
==> Packages to exclude: (eg: "1 2 3", "1-3", "^4" or repo name)
 -> Excluding packages may cause partial upgrades and break systems
==> 1-8
 there is nothing to do

Yet opera should have been upgraded.

[Jguer]

Couldn't reproduce on repo packages, will check if there's anything specific regarding aur.

From my first glance, opera doesn't depend on these ttf packages (otherwise could be a case of cascading excludes)

[etnguyen03]

As another example -- it's not just opera and it's not just packages that are above the range...

:: Synchronizing package databases...
 core is up to date
 extra is up to date
 multilib is up to date
:: Searching AUR for updates...
:: Searching databases for updates...
 -> Flagged Out Of Date AUR Packages: teamviewer
:: 11 packages to upgrade/install.
11  aur/opera                  107.0.5045.15-1   -> 107.0.5045.21-1
10  aur/pycharm-professional   2023.3.3-1        -> 2023.3.4-1
 9  aur/ttf-ms-win11           10.0.22631.2506-1 -> 10.0.22631.3155-1
 8  aur/ttf-ms-win11-japanese  10.0.22631.2506-1 -> 10.0.22631.3155-1
 7  aur/ttf-ms-win11-korean    10.0.22631.2506-1 -> 10.0.22631.3155-1
 6  aur/ttf-ms-win11-other     10.0.22631.2506-1 -> 10.0.22631.3155-1
 5  aur/ttf-ms-win11-sea       10.0.22631.2506-1 -> 10.0.22631.3155-1
 4  aur/ttf-ms-win11-thai      10.0.22631.2506-1 -> 10.0.22631.3155-1
 3  aur/ttf-ms-win11-zh_cn     10.0.22631.2506-1 -> 10.0.22631.3155-1
 2  aur/ttf-ms-win11-zh_tw     10.0.22631.2506-1 -> 10.0.22631.3155-1
 1  aur/zoom                   5.17.5-1          -> 5.17.10-1
==> Packages to exclude: (eg: "1 2 3", "1-3", "^4" or repo name)
 -> Excluding packages may cause partial upgrades and break systems
==> 2-9
 there is nothing to do