Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2799

Import Geometry types

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Major
    • 11.2.2
    • 10.0.1
    • Import/Export
    • None

    Description

      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.

      Attachments

        1. screenshot1.png
          screenshot1.png
          342 kB
        2. screenshot2.png
          screenshot2.png
          346 kB

        Activity

          People

            Unassigned Unassigned
            mkralik@redhat.com Matej Kralik
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: