EDS TRIM function rewrites in the Transformation Editor and becomes invalid query
Issue
- We noticed that TRIM ( LEADING .... FROM .... ) function in the transformation editor removes the LEADING string etc while validating in the transformation editor.
select trim ( leading '+' from '++++Test') trim_col1
becomes below after being saved:
SELECT Trim(leading FROM ) AS trim_col1
and gives a parsing error:
ERROR: Parsing error: Encountered ")" at line 2, column 36.
Was expecting one of:
"exists" ...
"has" ...
"not" ...
"translate" ...
"?" ...
<POS_REF> ...
<STRINGVAL> ...
<INTEGERVAL> ...
<FLOATVAL> ...
"false" ...
...
Environment
- Red Hat JBoss Data Services (EDS) 5.3.1
- Red Hat JBoss Developer Studio (JBDS) 5.0.2
- Teiid Designer plugin version 7.7.4.v20130801-1634-H7-Final
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.