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
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.