In the Maria DB I create tables with contain geometry type.
Each table contains one of type(POINT, LINESTRING, POLYGON, MULTIPOINT, MULTILINESTRING, MULTIPOLYGON, GEOMETRYCOLLECTION, GEOMETRY)).
When I generated source model from their, only geometry has been set geometry type (screenshot 1). The others have been set object type.
I generate VDB and execute it. This query

SELECT ST_AsText(g) FROM gis_geometry

works only geometry type (screenshot 1). However when I set geometry type manually for all columns in source model, query works for all tables (screenshot 2).
I think that Teiid Designer will should set geometry type for all this types when it import tables from JDBC source.