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

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, 8.12.x-6.4, 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.