Re: support for CLIENT_MULTI_STATEMENTS
Patrick Galbraith <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Andreas Vierengel wrote: > Jim Winstead wrote: > >> On Wed, Jan 31, 2007 at 05:21:05PM +0100, Andreas Vierengel wrote: >> >>> Andreas Vierengel wrote: >>> >>>> as far as I have seen support for CLIENT_MULTI_RESULTS is already >>>> in recent DBD::Mysql. Is there a technical reason for not inlcuding >>>> support fuer multi-results ? >>>> >>>> At the moment I hacked 2 lines of code to dbimp.c to support it >>>> very basically. >>> >>> forgive me, I meant: "Is there a technical reason for not inlcuding >>> support for CLIENT_MULTI_STATEMENTS ?" >> >> >> No, and I've finally checked in the support for this, so it will be in >> the next version of DBD::mysql. >> >> Jim >> > > ok, I have finally tested version 4.004, but it seems not working in > cases where queries are involved which do not return a result-set. > > Example: > > create temporary table x ( a int, b int ); > insert into x values( 1,2); > insert into x values( 3,4); > select count(*) from x; > insert into x values( 5,6); > select * from x; > drop temporary table x; > > I looked in dbdimp.c in line 2761 and changed > return 0 > to > return 1 > > after that, the example above seems to work. I'm no C-hacker, so this > "fix" might be wrong :) > Andy, Thanks very muchly! I'll check this fix out with the test suite. I could roll out another release in a week (too soon would be a bit soon!). regards, Patrick > --Andy > -- Patrick Galbraith, Senior Programmer Grazr - Easy feed grazing and sharing http://www.grazr.com Satyam Eva Jayate - Truth Alone Triumphs Mundaka Upanishad -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]