Re: support for CLIENT_MULTI_STATEMENTS

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

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]