Loading PostGIS layers with no specified geometry loads all features in the attribute table.

[SrNetoChan]

Describe the bug

I have a table where the geometry field is not restricted to a Geometry type. I can save polygons, points or lines.

When I load it in QGIS, I need to load in 3 different layers for specific geometry type. So far so good

In the current LTR (3.10) if you open the attribute table of the polygons layer, you will see the full list of features, including the features in which geometries are lines or points. Besides, If you label the features, it will also label invisible features (from points or lines.

I believe this was not the way it worked in the past. In 3.14 it seems to be fixed.

How to Reproduce

1. In postgis, create a table with a generic geometry column

CREATE TABLE test as (
gid serial primary key,
geom geometry(Geometry, 4326));

2. In QGIS, using data source manager, load the table 3 times for, points, lines, and polygons
3. Edit each layer adding at leas one feature and save
4. Open one of the layers attribute table, and confirm that all the features from all layers appear.

QGIS and OS versions

QGIS version	3.10.9-A Coruña	QGIS code revision	bf47e9d
Compiled against Qt	5.9.5	Running against Qt	5.9.5
Compiled against GDAL/OGR	2.2.3	Running against GDAL/OGR	2.2.3
Compiled against GEOS	3.6.2-CAPI-1.10.2	Running against GEOS	3.7.1-CAPI-1.11.1 27a5e771
Compiled against SQLite	3.22.0	Running against SQLite	3.22.0
PostgreSQL Client Version	10.12 (Ubuntu 10.12-0ubuntu0.18.04.1)	SpatiaLite Version	4.3.0a
QWT Version	6.1.3	QScintilla2 Version	2.10.2
PROJ.4 Version	493
OS Version	Ubuntu 18.04.5 LTS
Active python plugins	Mergin; socarto_recart_tools; db_manager; processing

Additional context

[elpaso]

Is this a regression? (just for tagging it correctly).

[elpaso]

I'm wondering what should happen for NULL geometries. I guess they should appear in all three layers, what do you think?

[SrNetoChan]

Is this a regression? (just for tagging it correctly).

I think it's a regression. I don't remember to have this problems in the past. But I can't say for sure.

[SrNetoChan]

I'm wondering what should happen for NULL geometries. I guess they should appear in all three layers, what do you think?

Yes, that makes sense.

[elpaso]

Duplicates #34629 (that was not backported)