Handling of CONCAT for Oracle datasources
Issue
In Oracle concatenating a zero-length string with another operand always results in the other operand, so null can result only from the concatenation of two null strings, so for example:
CONCAT(null, 'colin')
Would result in 'colin'. To get this behaviour in Teiid you would need to use the CONCAT2 function as CONCAT behaves in the ANSI standard way returning null if either operand is null.
Environment
JBoss Enterprise Data Services Platform
5.2/5.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.
