AWS Quicksight cant execute mysql procedure

While working with AWS Quicksight I needed to execute a more complex query using temporary tables, and decided to creat a stored procedure.

Much to my surprise, ended up founding that AWS Quicksight cant execute a Store Procedure.

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CALL spprocteste() ) ds LIMIT 0' at line 2"

Tried a bunch of stack overflow posts but no solution to this problem whatsoever.

Any additional info on this would be greatly appreciated.


Check out my new book about R Language http://www.amazon.com/dp/B00SX6WA06