Informix SQL working incorrectly since upgrading to v2.5 with the SUM function
I am noticing a result difference between TDA 2.1 and 2.5 on an Informix environment using the SUM function. Since I upgraded to Toad v2.5, the query is not returning the correct results.
The query uses the sum function: "sum(specified_column_ or_ expression)". If the sum function is removed, the results are returned with the correct data. When adding in the sum function back into query however, the returned data is incorrect.
Waiting for fix in a future version of Toad for Data Analysts.