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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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]

    Description

      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.

      Attachments

        Issue Links

          is caused by

          Sub-task - The sub-task of the issue TEIID-5740 Add support for EXPLAIN

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Bug - A problem that impairs or prevents the functions of the product. TEIID-5177 Enforce stricter naming in SQL/DDL

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Resolved

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  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