Hello to everyone! I performed tests on several databases. Here are the results.
MySQL Failed tests: test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest) Tests in error: test1MBClob(org.apache.cayenne.access.DataContextClobTest) test1MBBlob(org.apache.cayenne.access.DataContextBlobTest) Oracle Failed tests: testNot(org.apache.cayenne.exp.ParsedExpQualifierCompatTest) testSelectBooleanNotTrueOr(org.apache.cayenne.query.SelectQueryTest) Tests run: 2072, Failures: 2, Errors: 0, Skipped: 0 SQLserver Failed tests: testDBGeneratorStrategy(org.apache.cayenne.access.dbsync.SchemaUpdateStrategyTest) testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest) Tests run: 2072, Failures: 2, Errors: 0, Skipped: 0 Derby Tests in error: testSimpleColumn(org.apache.cayenne.merge.DropColumnToModelTest) testRemoveFKColumnWithoutRelationshipInDb(org.apache.cayenne.merge.DropColumnToModelTest) testDifferentEntity(org.apache.cayenne.access.DataContextEJBQLSubqueryTest) testExists(org.apache.cayenne.access.DataContextEJBQLSubqueryTest) test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest) test(org.apache.cayenne.merge.SetNotNullToDbTest) testMerging(org.apache.cayenne.util.EntityMergeSupportTest) testAddAndDropColumnToDb(org.apache.cayenne.merge.MergerFactoryTest) testChangeVarcharSizeToDb(org.apache.cayenne.merge.MergerFactoryTest) testMultipleTokensToDb(org.apache.cayenne.merge.MergerFactoryTest) testAddTableToDb(org.apache.cayenne.merge.MergerFactoryTest) testAddForeignKeyWithTable(org.apache.cayenne.merge.MergerFactoryTest) testAddForeignKeyAfterTable(org.apache.cayenne.merge.MergerFactoryTest) test(org.apache.cayenne.merge.ValueForNullTest) testAddTable(org.apache.cayenne.merge.CreateTableToModelTest) test(org.apache.cayenne.merge.SetAllowNullToDbTest) testBindForPassedNullParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testBindForNotPassedParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testAddColumn(org.apache.cayenne.merge.AddColumnToModelTest) testDropTable(org.apache.cayenne.merge.DropTableToModelTest) testForreignKey(org.apache.cayenne.merge.DropRelationshipToModelTest) Tests run: 2072, Failures: 0, Errors: 21, Skipped: 0 H2 Failed tests: test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest) Tests run: 2072, Failures: 1, Errors: 0, Skipped: 0 DB2 Tests in error: testSimpleColumn(org.apache.cayenne.merge.DropColumnToModelTest) testRemoveFKColumnWithoutRelationshipInDb(org.apache.cayenne.merge.DropColumnToModelTest) test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest) test(org.apache.cayenne.merge.SetNotNullToDbTest) testMerging(org.apache.cayenne.util.EntityMergeSupportTest) testAddAndDropColumnToDb(org.apache.cayenne.merge.MergerFactoryTest) testChangeVarcharSizeToDb(org.apache.cayenne.merge.MergerFactoryTest) testMultipleTokensToDb(org.apache.cayenne.merge.MergerFactoryTest) testAddTableToDb(org.apache.cayenne.merge.MergerFactoryTest) testAddForeignKeyWithTable(org.apache.cayenne.merge.MergerFactoryTest) testAddForeignKeyAfterTable(org.apache.cayenne.merge.MergerFactoryTest) testReadToMany(org.apache.cayenne.CDOQualifiedEntitiesTest) testReadToOne(org.apache.cayenne.CDOQualifiedEntitiesTest) test(org.apache.cayenne.merge.ValueForNullTest) testAddTable(org.apache.cayenne.merge.CreateTableToModelTest) test(org.apache.cayenne.merge.SetAllowNullToDbTest) testBindForPassedNullParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testBindForNotPassedParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testAddColumn(org.apache.cayenne.merge.AddColumnToModelTest) testDropTable(org.apache.cayenne.merge.DropTableToModelTest) testForreignKey(org.apache.cayenne.merge.DropRelationshipToModelTest) Tests run: 2072, Failures: 0, Errors: 21, Skipped: 0 Postgres Failed tests: testUnsetJoinWithPK(org.apache.cayenne.FlattenedRelationshipsTest) Tests run: 2072, Failures: 1, Errors: 0, Skipped: 0 Sqlite Failed tests: testSimpleColumn(org.apache.cayenne.merge.DropColumnToModelTest) testRemoveFKColumnWithoutRelationshipInDb(org.apache.cayenne.merge.DropColumnToModelTest) test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest) test(org.apache.cayenne.merge.SetNotNullToDbTest) testMerging(org.apache.cayenne.util.EntityMergeSupportTest) testAddAndDropColumnToDb(org.apache.cayenne.merge.MergerFactoryTest) testChangeVarcharSizeToDb(org.apache.cayenne.merge.MergerFactoryTest) testMultipleTokensToDb(org.apache.cayenne.merge.MergerFactoryTest) testAddTableToDb(org.apache.cayenne.merge.MergerFactoryTest) testAddForeignKeyWithTable(org.apache.cayenne.merge.MergerFactoryTest) testAddForeignKeyAfterTable(org.apache.cayenne.merge.MergerFactoryTest) test(org.apache.cayenne.merge.ValueForNullTest) testDeleteNoIdVar(org.apache.cayenne.access.DataContextEJBQLDeleteTest) testDeleteNoQualifier(org.apache.cayenne.access.DataContextEJBQLDeleteTest) testPerformNonSelectingQueryCounts2(org.apache.cayenne.access.DataContextTest) testAddTable(org.apache.cayenne.merge.CreateTableToModelTest) test(org.apache.cayenne.merge.SetAllowNullToDbTest) testAddColumn(org.apache.cayenne.merge.AddColumnToModelTest) testDropTable(org.apache.cayenne.merge.DropTableToModelTest) testForreignKey(org.apache.cayenne.merge.DropRelationshipToModelTest) Tests in error: testMultiDBUpdate(org.apache.cayenne.access.DataContextCrossDBTest) testTime(org.apache.cayenne.access.DateTimeTypesTest) testFetchLimit_DistinctResultIterator(org.apache.cayenne.access.jdbc.SelectActionTest) testNewObject(org.apache.cayenne.access.IdentityColumnsTest) testCAY823(org.apache.cayenne.access.IdentityColumnsTest) testUnrelatedUpdate(org.apache.cayenne.access.IdentityColumnsTest) testMultipleNewObjectsSeparateTables(org.apache.cayenne.access.IdentityColumnsTest) testMultipleNewObjects(org.apache.cayenne.access.IdentityColumnsTest) testCompoundPKWithGeneratedColumn(org.apache.cayenne.access.IdentityColumnsTest) testUpdateDependentWithNewMaster(org.apache.cayenne.access.IdentityColumnsTest) testPropagateToDependent(org.apache.cayenne.access.IdentityColumnsTest) testBindForPassedNullParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testBindWithJDBCForPassedNullParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testBindForNotPassedParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testBindWithJDBCForNotPassedParam(org.apache.cayenne.access.jdbc.BindDirectiveTest) testSelectCompound1(org.apache.cayenne.access.DataContextFlattenedAttributesTest) testSelectCompound2(org.apache.cayenne.access.DataContextFlattenedAttributesTest) testSelectEJQBQL(org.apache.cayenne.access.DataContextFlattenedAttributesTest) testLongIn(org.apache.cayenne.exp.ExpressionFactoryTest) Tests run: 2072, Failures: 20, Errors: 19, Skipped: 0
