Parsing error on Preview in Teiid Designer if the source column has a default value

Solution Verified - Updated -

Issue

  • Receive a parsing error when trying to Preview a table that has a default value set in the database

Environment

  • Red Hat JBoss Data Virtualization (DV) 6.3
  • Red Hat JBoss Developer Studio (JBDS) 10.3
  • Teiid Designer for JBDS 11.0.1
  • Parsing error on Preview:
WARN [org.teiid.RUNTIME] (teiid-async-threads - 4) TEIID50036 VDB PREVIEW-32405570-21e1-4a40-ace7-21b408420884.1 model "example" metadata failed to load. Reason:TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ") DEFAULT ''[*]user[*] name'::text'" at line 4, column 47.
Was expecting: "options" | "," | ")": org.teiid.metadata.ParseException: TEIID30386 org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered ") DEFAULT ''[*]user[*] name'::text'" at line 4, column 47.
Was expecting: "options" | "," | ")"

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In