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

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4830?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-4830.
-----------------------------------
    Resolution: Done


Added the geometry token as an identifier.

> 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, Query Engine
>    Affects Versions: 9.3, 8.12.9.6_3
>            Reporter: Andrej Šmigala
>            Assignee: Steven Hawkins
>             Fix For: 9.3, 9.2.2
>
>
> 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)