[Sqlrelay-discussion] MySQL 5.0+ and stored procedures

[Devananda <kar...@ya...>]

I've made a minor change to the mysql connector -- more of a hack really 
-- to allow a result set to be returned by stored procedures. I'm sure 
there is a better way to do it, since this "quick-fix" only handles the 
first result set returned, and procedures can return many result sets. 
However, this covers all my needs (for now)... Hope it helps someone else!

The two changes as follows, to the connections/mysql/mysql.C file:

First, tell MySQL that we can process multi_result sets...

lines 73-85, reordered to set CLIENT_MULTI_RESULT if MYSQL_VERSION_ID > 5000
>     #if MYSQL_VERSION_ID < 32200
>         if (!mysql_real_connect(&mysql,hostval,user,password,
>                         portval,socketval,0)) {
>     #else
>         // initialize database connection structure
>         if (!mysql_init(&mysql)) {
>             fprintf(stderr,"mysql_init failed\n");
>             return false;
>         }       
>         #if MYSQL_VERSION_ID < 50000
>             if (!mysql_real_connect(&mysql,hostval,user,password,dbval,
>                         portval,socketval,0)) {
>         #else
>             if (!mysql_real_connect(&mysql,hostval,user,password,dbval,
>                         portval,socketval,CLIENT_MULTI_RESULTS)) {
>         #endif
>     #endif
Second, make sure we do NOT leave any result sets trailing around.

function def. on line 855, inserted "#if MYSQL_VERSION_ID..." block:
> void mysqlcursor::cleanUpData(bool freeresult, bool freebinds) {
> #ifdef HAVE_MYSQL_STMT_PREPARE
>     if (!mysqlconn->fakebinds) {
>         if (freebinds) {
>             bindcounter=0;
>             rawbuffer::zero(&bind,sizeof(bind));
>             mysql_stmt_reset(stmt);
>         }       
>         if (freeresult) {
>             mysql_stmt_free_result(stmt);
>             if (mysqlresult) {
>                 mysql_free_result(mysqlresult);
>                 mysqlresult=NULL;
>             }       
>         }       
>     } else {
> #endif
>         if (freeresult && mysqlresult!=(MYSQL_RES *)NULL) {
>             mysql_free_result(mysqlresult);
>             mysqlresult=NULL;
>         }       
> #if MYSQL_VERSION_ID > 50000
>         whlie(!mysql_next_result(&mysqlconn->mysql)) {
>             mysqlresult=mysql_store_result($mysqlconn->mysql);
>             mysql_free_result(mysqlresult);
>             mysqlresult=NULL;
>         }       
> #endif
> #ifdef HAVE_MYSQL_STMT_PREPARE
>     }
> #endif
>     delete[] columnnames;
>     columnnames=NULL;
> }