QtSql Tests: Difference between revisions
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
Currently only | 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: | The following database combinations have been tested: | ||
Line 6: | Line 6: | ||
* MySQL 5.5 | * MySQL 5.5 | ||
* PostgreSQL 9.2 | * PostgreSQL 9.2 | ||
* | * ODBC -> MySQL 5.5 | ||
<code>tst_QSql: Totals: 8 passed, 0 failed, 0 skipped | |||
FAIL! : tst_QSqlDatabase::formatValueTrimStrings(4_QODBC</code>testMySql) '(q).exec&amp;#40;QString("INSERT INTO %1 (id, t_varchar, t_char&amp;#41; values (50, 'Trim Test<br />', 'Trim Test 2 ')").arg(qTableName("qtest&quot;, ".tst_qsqldatabase.cpp&quot;, db)))' returned FALSE. (QODBC<code>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'')<br />._qsqldatabase.cpp(1707) : failure location<br />FAIL! : tst_QSqlDatabase::precisionPolicy(4_QODBC</code>testMySql) '(q).exec&amp;#40;QString("CREATE TABLE %1 (id smallint, num numeric(18,5&amp;#41;)").arg(tableName))'<br />eturned FALSE. (QODBC<code>testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtstb946e173_qtes_prec' already exists')<br />FAIL! : tst_QSqlDatabase::mysqlOdbc_unsignedIntegers(4_QODBC</code>testMySql) '(q).exec&amp;#40;QString("INSERT INTO %1 VALUES (–4000000000, –4000000000&amp;#41;").arg(tableName))' returned FALSE. (QODBC</code>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')<br />FAIL! : tst_QSqlDatabase::odbc_testqGetString(4_QODBC<code>testMySql) '(q).exec&amp;#40;"CREATE TABLE " + testqGetString + "(id int, vcvalue varchar(65538&amp;#41;)")' returned FALSE. (QODBC<code>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')<br />tst_QSqlDatabase: Totals: 75 passed, 6 failed, 34 skipped | |||
tst_QSqlDriver: Totals: 12 passed, 0 failed, 0 skipped<br />tst_QSqlError: Totals: 5 passed, 0 failed, 0 skipped<br />tst_QSqlField: Totals: 22 passed, 0 failed, 0 skipped | |||
FAIL! : tst_QSqlQuery::blob(4_QODBC</code>testMySql) '(q).exec&amp;#40; queryString &#41;' returned FALSE. (QODBC</code>testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad44610_qtest_blob' already exists')<br />._qsqlquery.cpp(910) : failure location<br />FAIL! : tst_QSqlQuery::char1SelectUnicode(4_QODBC<code>testMySql) '(q).exec&amp;#40; createQuery &#41;' returned FALSE. (QODBC<code>testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad44610_char1su' already exists')<br />._qsqlquery.cpp(476) : failure location<br />FAIL! : tst_QSqlQuery::lastInsertId(2_QMYSQL</code>testdb) 'v.isValid()' returned FALSE. ()<br />._qsqlquery.cpp(2330) : failure location<br />FAIL! : tst_QSqlQuery::lastInsertId(3_QPSQL<code>testdb) 'v.isValid()' returned FALSE. ()<br />._qsqlquery.cpp(2330) : failure location<br />FAIL! : tst_QSqlQuery::bindBool(1_QOCI</code>localhost) '(q).exec&amp;#40;&#41;' returned FALSE. (QOCI</code>localhost: (1722) 'Unable to execute statement' || 'ORA-01722: invalid number<br />')<br />._qsqlquery.cpp(607) : failure location<br />FAIL! : tst_QSqlQuery::blobsPreparedQuery(1_QOCI<code>localhost) '(q).exec&amp;#40;&#41;' returned FALSE. (QOCI<code>localhost: (1465) 'Unable to execute statement' || 'ORA-01465: invalid hex number')<br />._qsqlquery.cpp(2774) : failure location<br />FAIL! : tst_QSqlQuery::blobsPreparedQuery(4_QODBC</code>testMySql) '(q).exec&amp;#40; QString( "CREATE TABLE %1(id INTEGER, data %2&amp;#41;" ).arg( tableName ).arg( typeN<br />ame ) )' returned FALSE. (QODBC<code>testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad4<br />4610_blobstest' already exists')<br />._qsqlquery.cpp(2766) : failure location<br />FAIL! : tst_QSqlQuery::QTBUG_2192(4_QODBC</code>testMySql) '(q).exec&amp;#40;&#41;' returned FALSE. (QODBC</code>testMySql: (1292) 'QODBC3: Unable to execute statement' ||<br />[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')<br />._qsqlquery.cpp(3468) : failure location<br />FAIL! : tst_QSqlQuery::aggregateFunctionTypes(2_QMYSQL<code>testdb) Compared values are not the same<br />._qsqlquery.cpp(3693) : failure location<br />FAIL! : tst_QSqlQuery::aggregateFunctionTypes(3_QPSQL</code>testdb) Compared values are not the same<br />._qsqlquery.cpp(3693) : failure location<br />FAIL! : tst_QSqlQuery::aggregateFunctionTypes(4_QODBC<code>testMySql) Compared values are not the same<br />._qsqlquery.cpp(3661) : failure location<br />tst_QSqlQuery: Totals: 212 passed, 11 failed, 48 skipped | |||
tst_QSqlRecord: Totals: 26 passed, 0 failed, 0 skipped<br />tst_QSqlResult: Totals: 4 passed, 0 failed, 0 skipped | |||
FAIL! : tst_QSqlThread::initTestCase() '(q).exec&amp;#40;"create table " + qtest + "(id int NOT NULL primary key, name varchar(20&amp;#41;, title int)")' returned FALSE. (QODBC</code>testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst5a1e258b_qtest' already exists')<br />._qsqlthread.cpp(317) : failure location<br />tst_QSqlThread: Totals: 1 passed, 1 failed, 0 skipped | |||
tst_QSqlQueryModel: Totals: 51 passed, 0 failed, 2 skipped | |||
FAIL! : tst_QSqlRelationalTableModel::data(1_QOCI<code>localhost) Compared values are not the same<br /> Actual (model.data(model.index(4, 0)).toInt()): 6<br /> Expected (5): 5<br />._qsqlrelationaltablemodel.cpp(228) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::setData(3_QPSQL</code>testdb) Compared values are not the same<br /> Actual (model.data(model.index(0,1)).toString()): Mr<br /> Expected (QString("Hr&quot;)): Hr<br />._qsqlrelationaltablemodel.cpp(405) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::insertRecord(4_QODBC<code>testMySql) '(model).insertRecord(<s>1, rec)' returned FALSE. (QODBC<code>testMySql: (1062) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Duplicate entry '7' for key 'PRIMARY'')<br />._qsqlrelationaltablemodel.cpp(482) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::insertWithStrategies(4_QODBC</code>testMySql) Compared values are not the same<br /> Actual (model.data(model.index(0,3)).toString()): herr<br /> Expected (QString("mister&quot;)): mister<br />._qsqlrelationaltablemodel.cpp(578) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::removeColumn(1_QOCI<code>localhost) Compared values are not the same<br /> Actual (lmodel.data(lmodel.index(0, 0)).toInt()): 3<br /> Expected (1): 1<br />._qsqlrelationaltablemodel.cpp(710) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::sort(1_QOCI</code>localhost) Compared values are not the same<br /> Actual (model.data(model.index(0, 2)).toString()):<br /> Expected (QString("mister&quot;)): mister<br />._qsqlrelationaltablemodel.cpp(794) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::sort(3_QPSQL<code>testdb) Compared values are not the same<br /> Actual (model.data(model.index(0, 2)).toString()):<br /> Expected (QString("mister&quot;)): mister<br />._qsqlrelationaltablemodel.cpp(794) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::clearDisplayValuesCache(4_QODBC</code>testMySql) Compared values are not the same<br /> Actual (model.data(model.index(3, 0)).toInt()): 2<br /> Expected (3): 3<br />._qsqlrelationaltablemodel.cpp(932) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::insertRecordDuplicateFieldNames(4_QODBC<code>testMySql) 'model.submitAll()' returned FALSE. ()<br />._qsqlrelationaltablemodel.cpp(1011) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::escapedRelations(1_QOCI</code>localhost) Compared values are not the same<br /> Actual (model.data(model.index(0, 0)).toInt()): 3<br /> Expected (1): 1<br />._qsqlrelationaltablemodel.cpp(1184) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::whiteSpaceInIdentifiers(4_QODBC<code>testMySql) Compared values are not the same<br /> Actual (model.data(model.index(0,1)).toString()): New York<br /> Expected (QString("Washington&quot;)): Washington<br />._qsqlrelationaltablemodel.cpp(1382) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::selectAfterUpdate(4_QODBC</code>testMySql) 'model.relationModel(2)</s>>rowCount() == 2' returned FALSE. ()<br />._qsqlrelationaltablemodel.cpp(1487) : failure location<br />FAIL! : tst_QSqlRelationalTableModel::relationOnFirstColumn(1_QOCI<code>localhost) '(q).exec&amp;#40;"CREATE TABLE " + testTable1 + " (val1 INTEGER, id1 INTEGER PRIMARY KEY&amp;#41;;")' returned FALSE. (QOCI<code>localhost: (911) 'Unable to execute statement' || 'ORA-00911: invalid character<br />')<br />._qsqlrelationaltablemodel.cpp(1514) : failure location<br />tst_QSqlRelationalTableModel: Totals: 84 passed, 13 failed, 2 skipped | |||
FAIL! : tst_QSqlTableModel::initTestCase() '(q).exec&amp;#40;qry&amp;#41;' returned FALSE. (QOCI</code>localhost: (972) 'Unable to execute statement' || 'ORA-00972: identifier is too long')<br />._qsqltablemodel.cpp(217) : failure location<br />FAIL! : tst_QSqlTableModel::initTestCase() '(q).exec&amp;#40;"insert into " + test + " values(1, 'harry', 1&amp;#41;")' returned FALSE. (QMYSQL<code>: (1146) 'QMYSQL: Unable to execute query' || 'Table 'testdb.dbtstf4f2689a_test' doesn't exist')<br />._qsqltablemodel.cpp(231) : failure location<br />tst_QSqlTableModel: Totals: 1 passed, 2 failed, 0 skipped</code> |
Revision as of 11:11, 24 February 2015
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&#40;QString("INSERT INTO %1 (id, t_varchar, t_char&#41; 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'')<br />._qsqldatabase.cpp(1707) : failure location<br />FAIL! : tst_QSqlDatabase::precisionPolicy(4_QODBC
testMySql) '(q).exec&#40;QString("CREATE TABLE %1 (id smallint, num numeric(18,5&#41;)").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')<br />FAIL! : tst_QSqlDatabase::mysqlOdbc_unsignedIntegers(4_QODBC
testMySql) '(q).exec&#40;QString("INSERT INTO %1 VALUES (–4000000000, –4000000000&#41;").arg(tableName))' returned FALSE. (QODBCtestMySql: (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&amp;#40;"CREATE TABLE " + testqGetString + "(id int, vcvalue varchar(65538&amp;#41;)")' returned FALSE. (QODBC<code>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')<br />tst_QSqlDatabase: Totals: 75 passed, 6 failed, 34 skipped
tst_QSqlDriver: Totals: 12 passed, 0 failed, 0 skipped<br />tst_QSqlError: Totals: 5 passed, 0 failed, 0 skipped<br />tst_QSqlField: Totals: 22 passed, 0 failed, 0 skipped
FAIL! : tst_QSqlQuery::blob(4_QODBC
testMySql) '(q).exec&#40; queryString )' returned FALSE. (QODBCtestMySql: (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&amp;#40; createQuery &#41;' returned FALSE. (QODBC<code>testMySql: (1050) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Table 'dbtst9ad44610_char1su' already exists')<br />._qsqlquery.cpp(476) : failure location<br />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. ()<br />._qsqlquery.cpp(2330) : failure location<br />FAIL! : tst_QSqlQuery::bindBool(1_QOCI
localhost) '(q).exec&#40;)' returned FALSE. (QOCIlocalhost: (1722) 'Unable to execute statement' || 'ORA-01722: invalid number
')
._qsqlquery.cpp(607) : failure location
FAIL! : tst_QSqlQuery::blobsPreparedQuery(1_QOCI
localhost) '(q).exec&amp;#40;&#41;' returned FALSE. (QOCI<code>localhost: (1465) 'Unable to execute statement' || 'ORA-01465: invalid hex number')<br />._qsqlquery.cpp(2774) : failure location<br />FAIL! : tst_QSqlQuery::blobsPreparedQuery(4_QODBC
testMySql) '(q).exec&#40; QString( "CREATE TABLE %1(id INTEGER, data %2&#41;" ).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<br />4610_blobstest' already exists')<br />._qsqlquery.cpp(2766) : failure location<br />FAIL! : tst_QSqlQuery::QTBUG_2192(4_QODBC
testMySql) '(q).exec&#40;)' returned FALSE. (QODBCtestMySql: (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<br />._qsqlquery.cpp(3693) : failure location<br />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<br />._qsqlquery.cpp(3661) : failure location<br />tst_QSqlQuery: Totals: 212 passed, 11 failed, 48 skipped
tst_QSqlRecord: Totals: 26 passed, 0 failed, 0 skipped<br />tst_QSqlResult: Totals: 4 passed, 0 failed, 0 skipped
FAIL! : tst_QSqlThread::initTestCase() '(q).exec&amp;#40;"create table " + qtest + "(id int NOT NULL primary key, name varchar(20&amp;#41;, 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<br /> Actual (model.data(model.index(4, 0)).toInt()): 6<br /> Expected (5): 5<br />._qsqlrelationaltablemodel.cpp(228) : failure location<br />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(<s>1, rec)' returned FALSE. (QODBC<code>testMySql: (1062) 'QODBC3: Unable to execute statement' || '[MySQL][ODBC 5.2(w) Driver][mysqld-5.5.29]Duplicate entry '7' for key 'PRIMARY'')<br />._qsqlrelationaltablemodel.cpp(482) : failure location<br />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<br /> Actual (lmodel.data(lmodel.index(0, 0)).toInt()): 3<br /> Expected (1): 1<br />._qsqlrelationaltablemodel.cpp(710) : failure location<br />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<br /> Actual (model.data(model.index(0, 2)).toString()):<br /> Expected (QString("mister&quot;)): mister<br />._qsqlrelationaltablemodel.cpp(794) : failure location<br />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. ()<br />._qsqlrelationaltablemodel.cpp(1011) : failure location<br />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<br /> Actual (model.data(model.index(0,1)).toString()): New York<br /> Expected (QString("Washington&quot;)): Washington<br />._qsqlrelationaltablemodel.cpp(1382) : failure location<br />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&amp;#40;"CREATE TABLE " + testTable1 + " (val1 INTEGER, id1 INTEGER PRIMARY KEY&amp;#41;;")' returned FALSE. (QOCI<code>localhost: (911) 'Unable to execute statement' || 'ORA-00911: invalid character<br />')<br />._qsqlrelationaltablemodel.cpp(1514) : failure location<br />tst_QSqlRelationalTableModel: Totals: 84 passed, 13 failed, 2 skipped
FAIL! : tst_QSqlTableModel::initTestCase() '(q).exec&amp;#40;qry&amp;#41;' 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&#40;"insert into " + test + " values(1, 'harry', 1&#41;")' returned FALSE. (QMYSQL
: (1146) 'QMYSQL: Unable to execute query' || 'Table 'testdb.dbtstf4f2689a_test' doesn't exist')<br />._qsqltablemodel.cpp(231) : failure location<br />tst_QSqlTableModel: Totals: 1 passed, 2 failed, 0 skipped