2009/10/9 Ольга Ткачева <tkachovao...@gmail.com>
> 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 > > I will try to find reasons this.
