|
|
|
A query using the "+" operator to concatenate strings could interfere with padding of CHAR types. The "+" operator is supported to concatenate any CHAR types. However, when a VARCHAR is concatenated with a CHAR using "+" and the second operand is CHAR the resulting output type is CHAR and contains extra spaces due to padding issues. (When the second operand is VARCHAR, the output type is VARCHAR and there are no spacing issues.) The "||" operator is also documented as a string concatenation operator and using this construct returns proper results. When using the "||" operator or CONCAT, the output type is always VARCHAR, and the issue doesn't arise. The "+" operator has been modified such that it behaves in the same manner as "||" or CONCAT.
