Data Source Manager: Z and ZM geometries missing in dropdown list

[kristianrl]

What is the bug or the crash?

it is not possible to set the Z and ZM variants of the geometries because they are missing from the dropdown list.

Steps to reproduce the issue

Go to Data Source Manager, make a connection to a database (e.g. MSSQL), and find the table. Due to #53614, autodetection of geometries is not working, so manual selection is necessary.

It is not possible to select the Z and ZM variants of the geometries because they are missing from the dropdown list.

Workaround for the bug: I saved the QGIS project in .QGS format and manually edited the XML file, changing Polygon to PolygonZ.

Versions

Verified in QGIS 3.32.0

QGIS version
3.32.0-Lima
QGIS code revision
311a8cb8a6
Qt version
5.15.3
Python version
3.9.5
GDAL/OGR version
3.7.0
PROJ version
9.2.1
EPSG Registry database version
v10.088 (2023-05-13)
GEOS version
3.11.2-CAPI-1.17.2
SQLite version
3.41.1
PDAL version
2.5.3
PostgreSQL client version
15.2
SpatiaLite version
5.0.1
QWT version
6.1.6
QScintilla2 version
2.13.1
OS version
Windows 10 Version 2009




Active Python plugins
AddressToolsDK
0.1
Datafordeler
1.3
Dataforsyningen
0.4
DigitizingTools
1.5.2
geosearch_dk
1.4.0
ImportPhotos
3.0.5
db_manager
0.1.20
MetaSearch
0.3.6
processing
2.12.99

Supported QGIS version

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

New profile

• [X] I tried with a new QGIS profile

Additional context

Discovered by @elpaso - https://github.com/qgis/QGIS/issues/52660#issuecomment-1610917779