Virtual layer with JOIN on PostGIS layers not working anymore

[maltaesousa]

What is the bug or the crash?

Virtual layer with a LEFT JOIN on two PostGIS layers don't work anymore.

Steps to reproduce the issue

1. Download and restore this pg_dump pg_restore --create -U postgres -d postgres signalo_db.backup
2. Download and open this simple projet
3. Right click on virtual_layer -> open attribute table -> Problem, table is empty but it should not

Versions

Version de QGIS	3.40.1-Bratislava
Révision du code	989853a7
Libraries
Version de Qt	5.15.13
Version de Python	3.12.7
Version de GDAL/OGR	3.9.3
Version de Proj	9.5.0
Version de la base de données du registre EPSG	v11.016 (2024-08-31)
Version de GEOS	3.13.0-CAPI-1.19.0
Version de SQLite	3.46.1
Version de PDAL	2.8.1
Version du client PostgreSQL	16.2
Version de SpatiaLite	5.1.0
Version de QWT	6.3.0
Version de QScintilla2	2.14.1
Version de l'OS	Windows 10 Version 2009
Extensions Python actives
changeDataSource	3.1
geomapfish_locator	1.3.8
mask	1.10.4
vmDeportWSI	3.20
db_manager	0.1.20
grassprovider	2.12.99
MetaSearch	0.3.6
processing	2.12.99

Supported QGIS version

• I'm running a supported QGIS version according to the roadmap.

New profile

• I tried with a new QGIS profile

Additional context

Reproduce this steps on 3.30.0, 3.28.15 and both will work. Reproduce this virtual layer but with Geopackage on 3.40.1, it will also work