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:
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.
JBoss Enterprise Data Services Platform
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.