QtSql Tests

From Qt Wiki
Jump to navigation Jump to search

Currently only SQLite is actually tested in CI for the QtSQL module so there is potentially a lot of tests that are indicating problems without it being known.

The following database combinations have been tested:

  • Oracle 11g
  • MySQL 5.5
  • PostgreSQL 9.2
  • ODBC -> MySQL 5.5
tst_QSql: Totals: 8 passed, 0 failed, 0 skipped

FAIL! : tst_QSqlDatabase::formatValueTrimStrings(4_QODBC@testMySql) '(q).exec(QString("INSERT INTO %1 (id, t_varchar, t_char) values (50, 'Trim Test
', 'Trim Test 2 ')").arg(qTableName("qtest", ".tst_qsqldatabase.cpp", db)))' returned FALSE. (QODBC @testMySql: (1062) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Duplicate entry '50-Trim Test ' for key 'PRIMARY'')
._qsqldatabase.cpp(1707) : failure location
FAIL! : tst_QSqlDatabase::precisionPolicy(4_QODBC@testMySql) '(q).exec(QString("CREATE TABLE %1 (id smallint, num numeric(18,5))").arg(tableName))'
eturned FALSE. (QODBC @testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtstb946e173_qtes_prec' already exists')
FAIL! : tst_QSqlDatabase::mysqlOdbc_unsignedIntegers(4_QODBC@testMySql) '(q).exec(QString("INSERT INTO %1 VALUES (–4000000000, –4000000000)").arg(tableName))' returned FALSE. (QODBC @testMySql: (1264) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Out of range value for column 'foo' at row 1')
FAIL! : tst_QSqlDatabase::odbc_testqGetString(4_QODBC@testMySql) '(q).exec("CREATE TABLE " + testqGetString + "(id int, vcvalue varchar(65538))")' returned FALSE. (QODBC @testMySql: (1074) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Column length too big for column 'vcvalue' (max = 65535); use BLOB or TEXT instead')
tst_QSqlDatabase: Totals: 75 passed, 6 failed, 34 skipped

tst_QSqlDriver: Totals: 12 passed, 0 failed, 0 skipped
tst_QSqlError: Totals: 5 passed, 0 failed, 0 skipped
tst_QSqlField: Totals: 22 passed, 0 failed, 0 skipped

FAIL! : tst_QSqlQuery::blob(4_QODBC@testMySql) '(q).exec( queryString )' returned FALSE. (QODBC @testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad44610_qtest_blob' already exists')
._qsqlquery.cpp(910) : failure location
FAIL! : tst_QSqlQuery::char1SelectUnicode(4_QODBC@testMySql) '(q).exec( createQuery )' returned FALSE. (QODBC @testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad44610_char1su' already exists')
._qsqlquery.cpp(476) : failure location
FAIL! : tst_QSqlQuery::lastInsertId(2_QMYSQL@testdb) 'v.isValid()' returned FALSE. ()
._qsqlquery.cpp(2330) : failure location
FAIL! : tst_QSqlQuery::lastInsertId(3_QPSQL@testdb) 'v.isValid()' returned FALSE. ()
._qsqlquery.cpp(2330) : failure location
FAIL! : tst_QSqlQuery::bindBool(1_QOCI@localhost) '(q).exec()' returned FALSE. (QOCI @localhost: (1722) 'Unable to execute statement' || 'ORA-01722: invalid number
')
._qsqlquery.cpp(607) : failure location
FAIL! : tst_QSqlQuery::blobsPreparedQuery(1_QOCI@localhost) '(q).exec()' returned FALSE. (QOCI @localhost: (1465) 'Unable to execute statement' || 'ORA-01465: invalid hex number')
._qsqlquery.cpp(2774) : failure location
FAIL! : tst_QSqlQuery::blobsPreparedQuery(4_QODBC@testMySql) '(q).exec( QString( "CREATE TABLE %1(id INTEGER, data %2)" ).arg( tableName ).arg( typeN
ame ) )' returned FALSE. (QODBC @testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad4
4610_blobstest' already exists')
._qsqlquery.cpp(2766) : failure location
FAIL! : tst_QSqlQuery::QTBUG_2192(4_QODBC@testMySql) '(q).exec()' returned FALSE. (QODBC @testMySql: (1292) 'QODBC3: Unable to execute statement' ||
[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Incorrect datetime value: '2012-07-04 23:59:59.900000000' for column 'dt' at row 1')
._qsqlquery.cpp(3468) : failure location
FAIL! : tst_QSqlQuery::aggregateFunctionTypes(2_QMYSQL@testdb) Compared values are not the same
._qsqlquery.cpp(3693) : failure location
FAIL! : tst_QSqlQuery::aggregateFunctionTypes(3_QPSQL@testdb) Compared values are not the same
._qsqlquery.cpp(3693) : failure location
FAIL! : tst_QSqlQuery::aggregateFunctionTypes(4_QODBC@testMySql) Compared values are not the same
._qsqlquery.cpp(3661) : failure location
tst_QSqlQuery: Totals: 212 passed, 11 failed, 48 skipped

tst_QSqlRecord: Totals: 26 passed, 0 failed, 0 skipped
tst_QSqlResult: Totals: 4 passed, 0 failed, 0 skipped

FAIL! : tst_QSqlThread::initTestCase() '(q).exec("create table " + qtest + "(id int NOT NULL primary key, name varchar(20), title int)")' returned FALSE. (QODBC @testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst5a1e258b_qtest' already exists')
._qsqlthread.cpp(317) : failure location
tst_QSqlThread: Totals: 1 passed, 1 failed, 0 skipped

tst_QSqlQueryModel: Totals: 51 passed, 0 failed, 2 skipped

FAIL! : tst_QSqlRelationalTableModel::data(1_QOCI@localhost) Compared values are not the same
 Actual (model.data(model.index(4, 0)).toInt()): 6
 Expected (5): 5
._qsqlrelationaltablemodel.cpp(228) : failure location
FAIL! : tst_QSqlRelationalTableModel::setData(3_QPSQL@testdb) Compared values are not the same
 Actual (model.data(model.index(0,1)).toString()): Mr
 Expected (QString("Hr")): Hr
._qsqlrelationaltablemodel.cpp(405) : failure location
FAIL! : tst_QSqlRelationalTableModel::insertRecord(4_QODBC@testMySql) '(model).insertRecord(-1, rec)' returned FALSE. (QODBC @testMySql: (1062) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Duplicate entry '7' for key 'PRIMARY'')
._qsqlrelationaltablemodel.cpp(482) : failure location
FAIL! : tst_QSqlRelationalTableModel::insertWithStrategies(4_QODBC@testMySql) Compared values are not the same
 Actual (model.data(model.index(0,3)).toString()): herr
 Expected (QString("mister")): mister
._qsqlrelationaltablemodel.cpp(578) : failure location
FAIL! : tst_QSqlRelationalTableModel::removeColumn(1_QOCI@localhost) Compared values are not the same
 Actual (lmodel.data(lmodel.index(0, 0)).toInt()): 3
 Expected (1): 1
._qsqlrelationaltablemodel.cpp(710) : failure location
FAIL! : tst_QSqlRelationalTableModel::sort(1_QOCI@localhost) Compared values are not the same
 Actual (model.data(model.index(0, 2)).toString()):
 Expected (QString("mister")): mister
._qsqlrelationaltablemodel.cpp(794) : failure location
FAIL! : tst_QSqlRelationalTableModel::sort(3_QPSQL@testdb) Compared values are not the same
 Actual (model.data(model.index(0, 2)).toString()):
 Expected (QString("mister")): mister
._qsqlrelationaltablemodel.cpp(794) : failure location
FAIL! : tst_QSqlRelationalTableModel::clearDisplayValuesCache(4_QODBC@testMySql) Compared values are not the same
 Actual (model.data(model.index(3, 0)).toInt()): 2
 Expected (3): 3
._qsqlrelationaltablemodel.cpp(932) : failure location
FAIL! : tst_QSqlRelationalTableModel::insertRecordDuplicateFieldNames(4_QODBC@testMySql) 'model.submitAll()' returned FALSE. ()
._qsqlrelationaltablemodel.cpp(1011) : failure location
FAIL! : tst_QSqlRelationalTableModel::escapedRelations(1_QOCI@localhost) Compared values are not the same
 Actual (model.data(model.index(0, 0)).toInt()): 3
 Expected (1): 1
._qsqlrelationaltablemodel.cpp(1184) : failure location
FAIL! : tst_QSqlRelationalTableModel::whiteSpaceInIdentifiers(4_QODBC@testMySql) Compared values are not the same
 Actual (model.data(model.index(0,1)).toString()): New York
 Expected (QString("Washington")): Washington
._qsqlrelationaltablemodel.cpp(1382) : failure location
FAIL! : tst_QSqlRelationalTableModel::selectAfterUpdate(4_QODBC@testMySql) 'model.relationModel(2)->rowCount() == 2' returned FALSE. ()
._qsqlrelationaltablemodel.cpp(1487) : failure location
FAIL! : tst_QSqlRelationalTableModel::relationOnFirstColumn(1_QOCI@localhost) '(q).exec("CREATE TABLE " + testTable1 + " (val1 INTEGER, id1 INTEGER PRIMARY KEY);")' returned FALSE. (QOCI @localhost: (911) 'Unable to execute statement' || 'ORA-00911: invalid character
')
._qsqlrelationaltablemodel.cpp(1514) : failure location
tst_QSqlRelationalTableModel: Totals: 84 passed, 13 failed, 2 skipped

FAIL! : tst_QSqlTableModel::initTestCase() '(q).exec(qry)' returned FALSE. (QOCI @localhost: (972) 'Unable to execute statement' || 'ORA-00972: identifier is too long')
._qsqltablemodel.cpp(217) : failure location
FAIL! : tst_QSqlTableModel::initTestCase() '(q).exec("insert into " + test + " values(1, 'harry', 1)")' returned FALSE. (QMYSQL @: (1146) 'QMYSQL: Unable to execute query' || 'Table 'testdb.dbtstf4f2689a_test' doesn't exist')
._qsqltablemodel.cpp(231) : failure location
tst_QSqlTableModel: Totals: 1 passed, 2 failed, 0 skipped
Retrieved from "https://wiki.qt.io/index.php?title=QtSql_Tests&oldid=23079"