DV Teiid Designer re-write of TRIM() function incorrect

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content