Details
-
Bug
-
Resolution: Fixed
-
Minor
-
5.5.0
-
Enterprise Edition 5.5.0 build 2009
-
Untriaged
-
Unknown
-
CX Sprint 115
Description
Running the below CBAS query on the attached data throws an error:
"msg": "ASX0005: Invalid item type: function agg-sum cannot process item type string in an input array (or multiset)"
SELECT SUM(DISTINCT int_field1 ) FROM multiple_table_db_64708804_simple_table_1_shadow WHERE ((bool_field1 AND char_field1 = "N")) OR ((bool_field1 != true OR int_field1 <= 50208485)) GROUP BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 , bool_field1;
|
On making a slight modification to the query by removing DISTINCT, it works:
SELECT SUM(int_field1 ) FROM multiple_table_db_64708804_simple_table_1_shadow WHERE ((bool_field1 AND char_field1 = "N")) OR ((bool_field1 != true OR int_field1 <= 50208485)) GROUP BY int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 , bool_field1;
|
Also attaching the data for reference. int_field1 contains all integer values.