Cayenne › Cayenne - Dev

Test results

6 messages Options
Embed this post
Permalink
Ольга Ткачева

Test results

Reply Threaded More More options
Print post
Permalink
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
Ольга Ткачева

Re: Test results

Reply Threaded More More options
Print post
Permalink
End errors in Sybase:

  Sybase

 Failed tests:

test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest)

test(org.apache.cayenne.merge.SetAllowNullToDbTest)

 Tests in error:

testBindForPassedNullParam(org.apache.cayenne.access.jdbc.BindDirectiveTest)


testBindForNotPassedParam(org.apache.cayenne.access.jdbc.BindDirectiveTest)

 Tests run: 2072, Failures: 2, Errors: 2, Skipped: 0
Ольга Ткачева

Re: Test results

Reply Threaded More More options
Print post
Permalink
In reply to this post by Ольга Ткачева
2009/10/9 Ольга Ткачева <[hidden email]>

> 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.
Andrus Adamchik

Re: Test results

Reply Threaded More More options
Print post
Permalink

On Oct 9, 2009, at 2:33 PM, Ольга Ткачева wrote:

>>
>>
> I will try to find reasons this.

Hi Olga,

Yeah, looks like a few things have changed since M6. Thanks for doing  
all this regression testing and working on fixing it. Hopefully this  
is just a few problems that affected the variety of test conditions.

Cheers,
Andrus

Ольга Ткачева

Re: Test results

Reply Threaded More More options
Print post
Permalink
I added patch in *CAY-1293 <https://issues.apache.org/jira/browse/CAY-1293>*.
It fix some tests. As a result, on databases postgres, oracle, h2, sybase
tests are successful.

I have not fix 2 failed tests in sqlserver and db2. And i didn't look
sqlite.


In sqlserver:

     Failed tests:

         testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)


In db2:

      Failed tests:

         test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest)





In mysql were 2 tests with errors. They were before, in last release.


Tests in error:

    test1MBClob(org.apache.cayenne.access.DataContextClobTest)

    test1MBBlob(org.apache.cayenne.access.DataContextBlobTest)


In derby were 2 tests with errors. They also were before. (derby don't
support DISTINCT in Subquerys)

  Tests in error:


testDifferentEntity(org.apache.cayenne.access.DataContextEJBQLSubqueryTest)

    testExists(org.apache.cayenne.access.DataContextEJBQLSubqueryTest)





9 октября 2009 г. 14:38 пользователь Andrus Adamchik <[hidden email]
> написал:

>
> On Oct 9, 2009, at 2:33 PM, Ольга Ткачева wrote:
>
>
>>>
>>>  I will try to find reasons this.
>>
>
> Hi Olga,
>
> Yeah, looks like a few things have changed since M6. Thanks for doing all
> this regression testing and working on fixing it. Hopefully this is just a
> few problems that affected the variety of test conditions.
>
> Cheers,
> Andrus
>
>


--
Olga
Andrus Adamchik

Re: Test results

Reply Threaded More More options
Print post
Permalink
Thanks Olga. Aside from my comments on CAY-1293 Jira, looks like we  
are in a good shape. Although we'll need at least one more cross-DB  
regression to check CAY-1282 (and possibly yet uncommitted CAY-1280)  
effects.

Cheers,
Andrus


On Oct 15, 2009, at 7:02 PM, Ольга Ткачева wrote:

> I added patch in *CAY-1293 <https://issues.apache.org/jira/browse/CAY-1293 
> >*.
> It fix some tests. As a result, on databases postgres, oracle, h2,  
> sybase
> tests are successful.
>
> I have not fix 2 failed tests in sqlserver and db2. And i didn't look
> sqlite.
>
>
> In sqlserver:
>
>     Failed tests:
>
>          
> testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
>
>
> In db2:
>
>      Failed tests:
>
>         test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest)
>
>
>
>
>
> In mysql were 2 tests with errors. They were before, in last release.
>
>
> Tests in error:
>
>    test1MBClob(org.apache.cayenne.access.DataContextClobTest)
>
>    test1MBBlob(org.apache.cayenne.access.DataContextBlobTest)
>
>
> In derby were 2 tests with errors. They also were before. (derby don't
> support DISTINCT in Subquerys)
>
>  Tests in error:
>
>
> testDifferentEntity
> (org.apache.cayenne.access.DataContextEJBQLSubqueryTest)
>
>    testExists(org.apache.cayenne.access.DataContextEJBQLSubqueryTest)
>
>
>
>
>
> 9 октября 2009 г. 14:38 пользователь Andrus Adamchik <[hidden email]
>> написал:
>
>>
>> On Oct 9, 2009, at 2:33 PM, Ольга Ткачева wrote:
>>
>>
>>>>
>>>> I will try to find reasons this.
>>>
>>
>> Hi Olga,
>>
>> Yeah, looks like a few things have changed since M6. Thanks for  
>> doing all
>> this regression testing and working on fixing it. Hopefully this is  
>> just a
>> few problems that affected the variety of test conditions.
>>
>> Cheers,
>> Andrus
>>
>>
>
>
> --
> Olga

Free Embeddable Forum Powered by Nabble Help