DV Teiid Designer re-write of TRIM() function incorrect
Issue
- Entered the below SQL in the transformation editor to create a view table:
SELECT
trim(INTKEY),trim(STRINGKEY),trim(INTNUM),trim(STRINGNUM),trim(FLOATNUM),trim(LONGNUM),trim(DOUBLENUM),trim(BYTENUM),trim(DATEVALUE),trim(TIMESTAMPVALUE), trim(BOOLEANVALUE),trim(CHARVALUE),trim(SHORTVALUE),trim(BIGINTEGERVALUE),trim(BIGDECIMALVALUE),trim(OBJECTVALUE)
FROM
bqtora.LARGEB
Once it's saved, it gets rewritten with the defaults, but it leaves the column name out most of the time:
SELECT
trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGKEY), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.STRINGNUM), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM ), trim(' ' FROM bqtora.LARGEB.OBJECTVALUE)
FROM
bqtora.LARGEB
So obviously a validation parsing error is given:
ERROR: Error in parsing of sql - Encountered " ")" ") "" at line 2, column 31.
Was expecting one of:
"char" ...
"date" ...
"time" ...
Environment
- Red Hat JBoss Data Virtualization (DV) 6.3
- Red Hat JBoss Developer Studio (JBDS) 10.3
- Teiid Designer for JBDS 11.01
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.