diff options
author | Bill King <bking@trolltech.com> | 2009-07-06 05:57:41 (GMT) |
---|---|---|
committer | Bill King <bking@trolltech.com> | 2009-07-06 05:57:41 (GMT) |
commit | 8915977e56b58c4631dfb2b8616585b664e55f38 (patch) | |
tree | 2749523142ef9fa1ebb532ea301bb26b3bba1f23 /tests | |
parent | 8fa9744b1b18f97b98fc434b8b8057434118e3db (diff) | |
download | Qt-8915977e56b58c4631dfb2b8616585b664e55f38.zip Qt-8915977e56b58c4631dfb2b8616585b664e55f38.tar.gz Qt-8915977e56b58c4631dfb2b8616585b664e55f38.tar.bz2 |
Fix more sql autotest failures.
Sql server fails at numeric field calculations. (Confirmed by running
against MySql via odbc). Also, quote fields properly. The drivers know
how to do it correctly, so let them handle it.
Diffstat (limited to 'tests')
-rw-r--r-- | tests/auto/q3sqlcursor/tst_q3sqlcursor.cpp | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/tests/auto/q3sqlcursor/tst_q3sqlcursor.cpp b/tests/auto/q3sqlcursor/tst_q3sqlcursor.cpp index 812c862..360c3b7 100644 --- a/tests/auto/q3sqlcursor/tst_q3sqlcursor.cpp +++ b/tests/auto/q3sqlcursor/tst_q3sqlcursor.cpp @@ -575,7 +575,7 @@ void tst_Q3SqlCursor::precision() if(!tst_Databases::isSqlServer(db)) QCOMPARE( cur.value( 0 ).asString(), precStr ); else - QCOMPARE( cur.value( 0 ).asString(), precStr.left(precStr.size()-1) ); + QCOMPARE( cur.value( 0 ).asString(), precStr.left(precStr.size()-1) ); // Sql server fails at counting. QVERIFY( cur.next() ); QCOMPARE( cur.value( 0 ).asDouble(), precDbl ); } @@ -759,8 +759,9 @@ void tst_Q3SqlCursor::insertFieldNameContainsWS() { QSqlQuery q(db); q.exec(QString("DROP TABLE %1").arg(tableName)); - QString query = QString("CREATE TABLE %1 (id int, \"first Name\" varchar(20), " - "lastName varchar(20))"); + QString query = "CREATE TABLE %1 (id int, " + + db.driver()->escapeIdentifier("first Name", QSqlDriver::FieldName) + + " varchar(20), lastName varchar(20))"; QVERIFY_SQL(q, exec(query.arg(tableName))); Q3SqlCursor cur(QString("%1").arg(tableName), true, db); |