Parsing error on Preview in Teiid Designer if the source column has a default value
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, tools, and much more.