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.elli...@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. >> > >
_______________________________________________ Users mailing list Users@lists.opensips.org http://lists.opensips.org/cgi-bin/mailman/listinfo/users
