Hi, developers, Trafodion concat() works differently than other popular database (Oracle/PostgreSQL/MySQL) when concatenating data of two different SQL types.
Here is the example: >>select '|'||80||'|' from dual; (EXPR) ------ | 80| Trafodion add 4 space when converting integer (80) into varchar. Other database doesn't do this, it is desired to be: >>select '|'||80||'|' from dual; (EXPR) ------ |80| Users need to do concat to generate data for further processing, and the left pad is not expected, an extra trim is required. I think Trafodion should behave like other RDBMS, which is better. I created jira https://issues.apache.org/jira/browse/TRAFODION-2904 and PR https://github.com/apache/trafodion/pull/1397 Please add your comments here or in the JIRA/PR. This may not be backward compatible, so I ask all your opinion here. Maybe there is a strong reason to do the left padding. Thanks, Ming
