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

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

    XMLWordPrintable

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.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: