Recently we have several customers reported sql aggregation returns wrong result in sql command editor. For example, following sql returns unexpected/wrong result:
select sum(column1) from table1
This is not sql command editor “problem”, but a LIMITATION. For the details, please refer to SAP note 2426293 – SQL command editor: Purpose and limitation.
That is to say business process must not rely on sql command editor.
Technically from certain SP level, we introduced “new” SQL command editor which caues sum() (or maybe other sql functions) is not working as expected, which is the reason why “old” sql command “worked”. So this issue often occurs after basis SP level upgrade.