|
For 2nd statement generating affected rows number, SQLRowCount would still return the row count for 1st statement. To repeat
ODBC_TEST(test_multi_statements)
{
SQLLEN num_inserted;
SQLRETURN rc;
OK_SIMPLE_STMT(Stmt, "DROP TABLE IF EXISTS t1");
OK_SIMPLE_STMT(Stmt, "CREATE TABLE t1 (a int)");
OK_SIMPLE_STMT(Stmt, "INSERT INTO t1 VALUES(1);INSERT INTO t1 VALUES(2), (3)");
SQLRowCount(Stmt, &num_inserted);
diag("inserted: %ld", (long)num_inserted);
FAIL_IF(num_inserted != 1, "Expected 1 row inserted");
rc= SQLMoreResults(Stmt);
num_inserted= 0;
rc= SQLRowCount(Stmt, &num_inserted);
FAIL_IF(num_inserted != 2, "Expected 2 row inserted");
rc= SQLMoreResults(Stmt);
FAIL_IF(rc != SQL_NO_DATA, "expected no more results");
return OK;
}
2nd call of SQLRowCount returns 1
|