Problem

Given a ResultSet "rows" on iOS, calling "rows.rowCount" will affect the number of rows returned whle iterating over "rows" using "rows.isValidRow()" and "rows.next()".

Expected Behavior

Calling rows.rowCount should return the same integer as if you count how many rows you iterate over using "rows.isValidRow()" and "rows.next()".

Test Cases

The first test below FAILS on iPhone simulator 4.2, PASSES on Android 2.2. The second test PASSES on both iPhone simulator 4.2 and Android 2.2.

/**
 * Initializes the test environment, creating a simple table "data" that has 1500
 * rows in it.
 */
var testRowCount = 1500;
var db = Ti.Database.open('data');
db.execute('CREATE TABLE IF NOT EXISTS data (id INTEGER PRIMARY KEY, val TEXT)');
db.execute('DELETE FROM data WHERE 1=1');
for (var i = 1; i <= testRowCount; i++) {
    db.execute('INSERT INTO data (val) VALUES(?)','our value:' + i);
}

/**
 * TEST ROW COUNT DOES NOT ADVANCE RESULT SET.
 *
 * EXPECTED RESULT: rows.rowCount will return 1500, and realCount after
 * iterating over rows, will also return 1500.
 *
 * REAL BEHAVIOR IN 1.5.1: rows.rowCount returns 1000, and pushes the result set of
 * rows to 1001, so realCount after iteration is only 500, and not 1500 as expected.
 */
function testRowCountDoesNotAdvanceResultSet() {
    // now select out our data from the database
    var rows = db.execute("SELECT * FROM data");
    var rowCount = rows.rowCount;
    Ti.API.info('rows.rowCount = ' + rowCount);
    var realCount = 0;
    while (rows.isValidRow()) {
        realCount += 1;
        rows.next();
    }
    // check that the rowCount is equal to the number of rows we actually got out
    Ti.API.info('realCount = ' + realCount);
    if (realCount != rowCount) {
        Ti.API.error('rowCount == realCount assertion FAILED!');
    } else {
        Ti.API.info('rowCount == realCount assertion PASSED!');
    }
}

testRowCountDoesNotAdvanceResultSet();

/*
 * TEST RESULT SET COUNT WITHOUT ROW COUNT IS CORRECT
 *
 * To prove that the above test is valid, check that iterating over the result set
 * without first calling "rows.rowCount" will return the correct 1500 rows.
 *
 * EXPECTED RESULT: realCount after iterating over the rows will be 1500
 *
 * REAL BEHAVIOR IN 1.5.1: realCount after iterating over the rows is 1500
 */
function testResultSetCountWithoutRowCount() {
    // now select out our data from the database
    var rows = db.execute("SELECT * FROM data");
    var realCount = 0;
    while (rows.isValidRow()) {
        realCount += 1;
        rows.next();
    }
    Ti.API.info('realCount = ' + realCount);
    if (realCount != testRowCount) {
        Ti.API.error('realCount == ' + testRowCount + ' assertion FAILED!');
    } else {
        Ti.API.info('realCount == ' + testRowCount + ' assertion PASSED!');
    }
}

testResultSetCountWithoutRowCount();

Associated Help Desk Ticket

http://developer.appcelerator.com/helpdesk/view/61451">http://developer.appcelerator.com/helpdesk/view/61451