BestCareAnyLeaB
Windmill2y ago
4 replies
BestCareAnyLea

Aggregate functions unsupported type MYSQL_TYPE_NEWDECIMAL

Hello, when I try to use aggregate functions in my sql queries, Windmill returns the query result as "unsupported type MYSQL_TYPE_NEWDECIMAL". So a simple example would be a query like "SELECT SUM(Revenue) FROM Orders;". So far I have been using a work around and casting: "SELECT CAST(SUM(Revenue) AS UNSIGNED) FROM Orders;", however this does not seem to work for more complex queries, for example when trying to calculate with two SUM values. Any advice on this? Thanks
Was this page helpful?