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