mariano/node-db-mysql — Issue #48: Problem with stored procedures
Author: rfrancisco
Created: 2011-12-27 17:39:58+00:00
State: open

I get the error "PROCEDURE mydb.test can't return a result set in the given context" in any procedure that returns a result such as the one below.

CREATE DEFINER=`root`@`%` PROCEDURE `test`()
BEGIN
select 1 as result;
END

Im executing something like db.query('call test()').
Any help would be apreciated.