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

[Calvin Ellison]

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.
>

What's needed to make db_mysql handle multiple result sets? It looks like
they would need to be compiled into a single result set of zero or more
rows before handing off to the DB API.

Regards,

*Calvin Ellison*
Senior Voice Operations Engineer
calvin.ellison at voxox.com

>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20200318/73a4396f/attachment.html>