[OpenSIPS-Users] db_mysql_convert_rows says no rows but there is one

[Brett Nemeroff]

You don’t want to return multiple result sets. I wouldn’t think any support
would be added for this.

Maybe you can create a stored procedure that calls that stored procedure
and returns a single combined result set

On Wed, Mar 18, 2020 at 5:32 PM Calvin Ellison <calvin.ellison at voxox.com>
wrote:

> We've narrowed this down to a stored procedure that sometimes returns more
> than one result set, and when that happens the first result set is empty.
> It appears that db_mysql is setting the client flags to accept
> multiple result sets but the only processes the first one.
>
> Here's how my developer phrased it:
>
>> We have a store procedure that queries two tables and returns two result
>> sets. Something like “select * from table1 where condition=‘x’; select *
>> from table2 where condition=‘y’;” we need to be able to iterate through
>> both result sets. Since it’s a third party stored procedure we can’t modify
>> the way it works or make two separate queries. Currently the avp_db_query
>> method is returning “query returned no results” but it’s ignoring the
>> second result set.
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200318/d8a2109c/attachment-0001.html>