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