[Dovecot] Bug in driver-mysql.c + fix
tss at iki.fi
Wed Mar 10 16:23:23 EET 2010
On Wed, 2010-03-10 at 16:18 +0200, Timo Sirainen wrote:
> > password_query = CALL user_pass_check('%n', '%d', '%w')
> > user_query = CALL user_info('%n', '%d')
> > This failed with the message:
> > User query failed: PROCEDURE imap.user_info can't return a result set in the given context
> I thought it was possible to avoid that error by implementing the MySQL
> procedure in a specific way?..
"Statements that return a result set can be used within a stored
procedcure but not within a stored function. This prohibition includes
SELECT statements that do not have an INTO var_list clause and other
statements such as SHOW, EXPLAIN, and CHECK TABLE."
Sounds like if you used SELECT .. INTO and returned those variables, it
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 198 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20100310/7a37fb17/attachment.bin
More information about the dovecot