Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-4830

Parsing Error when deploying VDB with "geometry" as column name

    Details

      Description

      The following query works correctly if run against a deployed VDB:

      SELECT 'a' as "geometry";
      

      However, the following VDB fails to deploy:

      <?xml version="1.0" encoding="UTF-8"?>
      <vdb name="test-vdb" version="1">
       
          <model name="Test" type="VIRTUAL">
              <metadata type="DDL"><![CDATA[
                  CREATE VIEW test(c1 string) AS
                  SELECT 'a' as "geometry";
                  
              ]]></metadata>
          </model>
      </vdb>
      

      with the error

      TEIID31080 Test.test validation error: TEIID31100 Parsing error: Encountered "SELECT 'a' AS [*]geometry[*]" at line 1, column 15.
      Was expecting: id
      

      This seems to only happen when the name is "geometry", I could not find any other reserved word that would cause the same error.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                asmigala Andrej Šmigala
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: