Using Result, Query::store, Query::store_next and Connection::opt_multi_statements with INSERT, UPDATE, DELETE etc.

[James Vanns]

OK, so with the latest version of MySQL++ 2.3.2 and MySQL 5.0.27 I don't seem to get the
correct return code from Query::success() when using multi-statements that don't return a
result set. This used to work with 2.1 and according to the MySQL page referenced in you
developer documentation/reference manuals:

http://dev.mysql.com/doc/mysql/en/c-api-multiple-queries.html

Is referenced from
file:///usr/share/doc/mysql++-manuals-2.3.2/html/refman/classmysqlpp_1_1Query.html#a34

The MySQL example on that former page gives an example:

/* execute multiple statements */
status = mysql_query(mysql,
                     "DROP TABLE IF EXISTS test_table;\
                      CREATE TABLE test_table(id INT);\
                      INSERT INTO test_table VALUES(10);\
                      UPDATE test_table SET id=20 WHERE id=10;\
                      SELECT * FROM test_table;\
                      DROP TABLE test_table");

And they appear to use mysql_store_result(). I have a similar multi-query:

USE my_db;
UPDATE foobar () VALUES ();

And then this algorithm:

               bool done = false;
               Query query = con->query ();
               query << "USE my_db;UPDATE foobar () VALUES ();"

               std::cerr  << query.preview () << endl;
                  
                  for (Result result = query.store () ; !done ; result = query.store_next
()) {
                     if (query.success ()) {
                        results += con->affected_rows ();
                        remove = success = true;
                     }

                     done = !query.more_results ();
                  }

Here, with version 2.3.2 query.success () always returns false - even if the command
succeeded! Why? Am I doing something wrong? Has something this major changed? It also
appears the affected_rows() sometimes doesn't return the correct value for say, DELETES.

Cheers, 

Jim

-- 
James Vanns
Systems Programmer
Framestore CFC Ltd.