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

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

XMLWordPrintable

      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.

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

                Created:
                Updated:
                Resolved: