BestCareAnyLea
BestCareAnyLea4mo ago

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
4 Replies
rubenf
rubenf4mo ago
@Hugo
BestCareAnyLea
BestCareAnyLea4mo ago
Any feedback on this?
rubenf
rubenf4mo ago
it's a todo on our end
Hugo C.
Hugo C.4mo ago
hi @BestCareAnyLea, what windmill version are you on? we did add support for it a few months back