]
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.