Bug #2208 fetching resultset from multi statements doesn't work correctly in embedded
Submitted: 25 Dec 2003 6:04 Modified: 11 Feb 2004 4:37
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Embedded Library ( libmysqld ) Severity:S3 (Non-critical)
Version:4.1.2 OS:Linux (Linux)
Assigned to: Alexey Botchkov CPU Architecture:Any

[25 Dec 2003 6:04] Georg Richter
Description:
When executing a multi statement with embedded server first call to mysql_store_result returns a valid (wrong) resultset 

How to repeat:
...
mysql_server_init(0, NULL, NULL);

mysql = mysql_init(NULL);

mysql_real_connect(mysql,NULL,NULL,NULL, "client_test_db", 0, NULL, CLIENT_MULTI_STATEMENTS);

mysql_query(mysql, "DROP TABLE IF EXISTS test_multi_tab;SELECT 'foo'");
if (res = mysql_store_result(mysql)) {
	printf("Drop has no resultset, we already have resultset from select without calling mysql_next_result\n");
}
[11 Feb 2004 4:37] Alexey Botchkov
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

bk commit - 4.1 tree (hf:1.1700) 10 Feb
bk commit - 4.1 tree (hf:1.1716) 11 Feb 2004