support for CLIENT_MULTI_STATEMENTS

Hi,

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.

--Andy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: support for CLIENT_MULTI_STATEMENTS

Andreas Vierengel wrote:
> Hi,
>
> 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.
>
> --Andy
>

forgive me, I meant: "Is there a technical reason for not inlcuding
support for CLIENT_MULTI_STATEMENTS ?"

--Andiy

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: support for CLIENT_MULTI_STATEMENTS

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

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: support for CLIENT_MULTI_STATEMENTS

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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org