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

parser does not allow non-reserved word as identifier for domain type name

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 13.1, 13.0.2
    • 13.0.1
    • Grammar
    • None
    • DV Sprint 58
    • 0.5
    • Hide

      Create a VDB with

        <property name="domain-ddl" value="CREATE DOMAIN text AS VARCHAR;" />

      See the error

      Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "CREATE DOMAIN [*]text[*] AS VARCHAR" at line 1, column 15.
Was expecting: id
        at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:231) ~[teiid-engine-13.0.1.jar:13.0.1]
      Show
      Create a VDB with <property name= "domain-ddl" value= "CREATE DOMAIN text AS VARCHAR;" /> See the error Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "CREATE DOMAIN [*]text[*] AS VARCHAR" at line 1, column 15. Was expecting: id at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:231) ~[teiid-engine-13.0.1.jar:13.0.1]

      I am trying to upgrade from 12.2.1 to 13.0.1. have a VDB where I aliased VARCHAR as TEXT (a non-reserved keyword, according to the docs) in order to improve PostgreSQL compatibility. The VDB works on 12.2.1 and fails to load on 13.0.1.

              rhn-engineering-shawkins Steven Hawkins
              kgeis Ken Geis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved:

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Time Spent - 3 hours Remaining Estimate - 1 hour
                  1h
                  Logged:
                  Time Spent - 3 hours Remaining Estimate - 1 hour
                  3h