I'm having a hard time getting the simplest stored procedure to work
under latest datamapper
test case:
mysql> DELIMITER //
mysql> create procedure testme()
-> BEGIN
-> select 1;
-> END //
mysql> DELIMITER ;
mysql> call testme();
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.00 sec)
repository(:default).adapter.select("call testme()")
repository(:default).adapter.execute("call testme()")
both return
DataObjects::SQLError: PROCEDURE some_shit.testme can't return a
result set in the given context (code: 1312, sql state: 0A000, query:
call testme()
I believe it might have to do with a CLIENT_MULTI_RESULTS setting:
http://code.google.com/p/sequel-pro/issues/detail?id=226
I found this, http://pastie.org/949184 and it works BUT that is one
result being returned, not several
so, is there any way to turn on the CLIENT_MULTI_RESULTS flag? and
does dm support it even if I turn it on??
I know stored procedures don't have the greatest reputation but I'd
like to see this working
--
You received this message because you are subscribed to the Google Groups
"DataMapper" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/datamapper?hl=en.
