#include <mysql.h>
#include <string.h>
#include <stdio.h>
#include <assert.h>

int main ()
{
    MYSQL       conn;

    mysql_init (&conn);
    if (!mysql_real_connect (
        &conn,
        "localhost",
        "root",
        "",
        "animal",
        0,
        "/tmp/mysql50.sock",
        0)) {
		fprintf(stderr, "Failed to connect to database: Error: %s\n",
        mysql_error(&conn));
		return 1;
	} else {
		printf("%s\n", mysql_error(&conn));
	}
	
	
	int 		OK;
	
	const char* query = "drop database if exists bug28009";
	
	OK = mysql_real_query (&conn, query, strlen(query));
	
	assert(0 == OK);
	
	const char* query2 = "create database bug28009";
	
	OK = mysql_real_query (&conn, query2, strlen(query2));
	
	assert(0 == OK);
	
	const char* query3 = "CREATE PROCEDURE bug28009.`TestPreparedMultiResults` () BEGIN  SET @sql = 'SET @a = 10';  PREPARE stmt FROM @sql;  EXECUTE stmt;  DEALLOCATE PREPARE stmt;END";
	
	OK = mysql_real_query (&conn, query3, strlen(query3));
	
	assert(0 == OK);
	
	const char* query4 = "call bug28009.TestPreparedMultiResults()";
	
	OK = mysql_real_query (&conn, query4, strlen(query4));
	
	assert(0 == OK);
 	return 0;
};