Hello,

If one executes query with multiple SELECT statements then only first result
set is accessible on client.

How-To-Repeat:
mysql_real_connect(FMySQL, 'localhost', 'root', '', 'mydactest', 3306,
nil, CLIENT_MULTI_QUERIES);
mysql_query(FMySQL, 'SELECT uid, c_int FROM ALL_TYPES;SELECT * FROM
ALL_TYPES');
while (mysql_more_results(FMySQL) )
mysql_next_result(FMySQL); // Never execute !!!


Originator: Vladimir Zheleznyak
Organization: CoreLab
MySQL support: none
Severity: serious
Priority: medium
Category: ó
Class: sw-bug
Release: mysql-4.1.0

Exectutable: libmysql.dll
System: Win2000
Compiler: VC++ 6.0
Architecture: i




Best regards,
Vladimir Zheleznyak



--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org

Vladimir Zheleznyak writes:
>
> Hello,
>
> If one executes query with multiple SELECT statements then only first=
result
> set is accessible on client.
>
> How-To-Repeat:
> mysql_real_connect(FMySQL, 'localhost', 'root', '', 'mydactest', 33=
06,
> nil, CLIENT_MULTI_QUERIES);
> mysql_query(FMySQL, 'SELECT uid, c_int FROM ALL_TYPES;SELECT * FROM=

> ALL_TYPES');
> while (mysql_more_results(FMySQL) )
> mysql_next_result(FMySQL); // Never execute !!!
>
>
> Originator: Vladimir Zheleznyak
> Organization: CoreLab
> MySQL support: none
> Severity: serious
> Priority: medium
> Category: =F3
> Class: sw-bug
> Release: mysql-4.1.0
>

This option has been implemented in 4.1.1 which is currently available
from our BK repository, in the manner explained in our manual.

--

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=3Dm=
smi
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <sinisa [at] mysql.com=
>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB
/_/ /_/\_, /___/\___\_\___/ Fulltime Developer and Support Coordinat=
or
<___/ www.mysql.com Larnaca, Cyprus


--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs [at] m.gmane.org