[teiid-issues] [JBoss JIRA] (TEIID-4830) Parsing Error when deploying VDB with "geometry" as column name

[Andrej Šmigala (JIRA)]

Andrej Šmigala created TEIID-4830:
-------------------------------------

             Summary: Parsing Error when deploying VDB with "geometry" as column name
                 Key: TEIID-4830
                 URL: https://issues.jboss.org/browse/TEIID-4830
             Project: Teiid
          Issue Type: Bug
          Components: Grammar, VDB
    Affects Versions: 9.3, 8.12.9.6_3
            Reporter: Andrej Šmigala
            Assignee: Barry LaFond


The following query works correctly if run against a deployed VDB:
{code:sql}
SELECT 'a' as "geometry";
{code}

However, the following VDB fails to deploy:
{code:xml}
<?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>
{code}

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

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



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)