Halo
July 12, 2019, 7:07am
1
Hello! I’m trying call a stored procedure but it is always showing no data was returned.
This is the code of the procedure
BEGIN
select order_uid,
date(delivered_by) as delivery_date
from `TABLE`;
END
How do I make this work in redash or does redash support calling of store procedure?
Jakdaw
August 6, 2019, 2:03pm
2
Which version of redash are you using?
I have a tonne of queries that call stored procedures (or indeed do similar for MariaDB servers within the query itself using compound statements outside of Stored Programs - see https://mariadb.com/kb/en/library/using-compound-statements-outside-of-stored-programs/ ).
However I’m using a slightly modified version of redash - the good news is Arik has accepted my patch, I’m just not sure whether that made it into Redash 7 - have a feeling you might need a dev build or Redash 8 when it appears.
arikfr
August 8, 2019, 3:04pm
3
It didn’t. But v8 release is coming soon. Already working on the release notes