[Dovecot] Bug in driver-mysql.c + fix

[Timo Sirainen]

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
would work?

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part
Url : http://dovecot.org/pipermail/dovecot/attachments/20100310/7a37fb17/attachment.bin