cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Рябицкий Евгений <eryabits...@diasoft.ru>
Subject RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Date Tue, 12 Jan 2010 14:50:33 GMT

I run tests without my patch over hsqldb, mssql + jtds, posgres
 
Postgres don't like me.... :/


NO PATCH (ONLY TEST)
 
* hsqldb *
 
 Failed tests: 
  testDATE(org.apache.cayenne.access.ReturnTypesMappingTest)
  testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testREAL(org.apache.cayenne.access.ReturnTypesMappingTest)
  testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIME(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest)

Tests in error: 
  testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
  testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)

Tests run: 2031, Failures: 7, Errors: 4, Skipped: 0


* SQL Server + JTDS *

Failed tests: 
  testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
  testSelectLikeCaseSensitive(org.apache.cayenne.query.SelectQueryTest)
  testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
  testCLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
  testDATE(org.apache.cayenne.access.ReturnTypesMappingTest)
  testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
  testDECIMAL2(org.apache.cayenne.access.ReturnTypesMappingTest)
  testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testLONGVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
  testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
  testNUMERIC2(org.apache.cayenne.access.ReturnTypesMappingTest)
  testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIME(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIMESTAMP2(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest)

Tests in error: 
  testLongIn(org.apache.cayenne.exp.ExpressionFactoryTest)
  testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testBINARY2(org.apache.cayenne.access.ReturnTypesMappingTest)
  testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testVARBINARY2(org.apache.cayenne.access.ReturnTypesMappingTest)

Tests run: 2031, Failures: 17, Errors: 5, Skipped: 0


* postgres *

Failed tests: 
  warning(junit.framework.TestSuite$1)
  testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
  testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
  testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
  testBIGINT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testBIT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
  testBOOLEAN(org.apache.cayenne.access.ReturnTypesMappingTest)
  testCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
  testCLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
  testDATE(org.apache.cayenne.access.ReturnTypesMappingTest)
  testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
  testDOUBLE(org.apache.cayenne.access.ReturnTypesMappingTest)
  testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testINTEGER(org.apache.cayenne.access.ReturnTypesMappingTest)
  testLONGVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
  testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
  testREAL(org.apache.cayenne.access.ReturnTypesMappingTest)
  testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIME(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
  testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest)
  testVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)

Tests in error: 
  testMultiDBUpdate(org.apache.cayenne.access.DataContextCrossDBTest)
  testQualifyOnToMany(org.apache.cayenne.unit.jira.CAY_194Test)
  testQualifyOnToOne(org.apache.cayenne.unit.jira.CAY_194Test)
  testUnregisterThenRegister(org.apache.cayenne.access.ObjectStoreTest)
  testNullifyToOne(org.apache.cayenne.NestedCayenneContextTest)
  testSelect(org.apache.cayenne.NestedCayenneContextTest)
  testDeleteNew(org.apache.cayenne.NestedCayenneContextTest)
  testLocalObjectSynchronize(org.apache.cayenne.NestedCayenneContextTest)
  testLocalObjectsNoOverride(org.apache.cayenne.NestedCayenneContextTest)
  testPrefetchingToOne(org.apache.cayenne.NestedCayenneContextTest)
  testPrefetchingToMany(org.apache.cayenne.NestedCayenneContextTest)
  testCommitChangesToParent(org.apache.cayenne.NestedCayenneContextTest)
  testCommitChangesToParentDeleted(org.apache.cayenne.NestedCayenneContextTest)
  testCommitChanges(org.apache.cayenne.NestedCayenneContextTest)
  testAddRemove(org.apache.cayenne.NestedCayenneContextTest)
  testChangeRel(org.apache.cayenne.NestedCayenneContextTest)
  testCAY1183(org.apache.cayenne.NestedCayenneContextTest)
  testRollbackRelationshipModification(org.apache.cayenne.remote.RemoteRollbackTest)
  testRollbackDeletedObject(org.apache.cayenne.remote.RemoteRollbackTest)
  testRollbackModifiedObject(org.apache.cayenne.remote.RemoteRollbackTest)
  testInsertSubclass(org.apache.cayenne.CayenneContextInheritanceTest)
  testDeepMergeExistingSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest)
  testDeepMergeNonExistentSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest)
  testPrefetchQuote(org.apache.cayenne.access.DataContexQuoteTest)
  testParentUpdatedId(org.apache.cayenne.remote.NestedObjectContextParentEventsTest)
  testSave(org.apache.cayenne.access.InheritanceTest)
  testInsertSingle(org.apache.cayenne.GenericMappingTest)
  testInsertRelated(org.apache.cayenne.GenericMappingTest)
  testUpdateRelated(org.apache.cayenne.GenericMappingTest)
  testReturnDiffInPrePersist(org.apache.cayenne.remote.ClientChannelServerDiffsTest)
  testReturnDiffClientArcChanges(org.apache.cayenne.remote.ClientChannelServerDiffsTest)
  testReturnIdDiff(org.apache.cayenne.remote.ClientChannelServerDiffsTest)
  testNullify(org.apache.cayenne.remote.RelationshipChangeTest)
  testChange(org.apache.cayenne.remote.RelationshipChangeTest)
  testFailLockingOnToOne(org.apache.cayenne.access.OptimisticLockingTest)
  testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
  testAddToMany(org.apache.cayenne.CDOMapRelationshipTest)
  testAddToManyViaReverse(org.apache.cayenne.CDOMapRelationshipTest)
  testInsert(org.apache.cayenne.access.EmbeddingTest)
  testAddToMany(org.apache.cayenne.CayenneContextMapRelationshipTest)
  testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
  testNullifyToOne(org.apache.cayenne.CayenneContextDeleteRulesTest)
  testCascadeToOne(org.apache.cayenne.CayenneContextDeleteRulesTest)
  testDenyToOne(org.apache.cayenne.CayenneContextDeleteRulesTest)
  testCascadeToOneNewObject(org.apache.cayenne.CayenneContextDeleteRulesTest)
  testDenyToOne(org.apache.cayenne.access.DeleteRulesTest)
  testNoActionToOne(org.apache.cayenne.access.DeleteRulesTest)
  testNoActionToMany(org.apache.cayenne.access.DeleteRulesTest)
  testNoActionFlattened(org.apache.cayenne.access.DeleteRulesTest)
  testNoActionFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
  testCascadeFlattened(org.apache.cayenne.access.DeleteRulesTest)
  testCascadeFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
  testNullifyFlattened(org.apache.cayenne.access.DeleteRulesTest)
  testNullifyFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
  testDenyFlattened(org.apache.cayenne.access.DeleteRulesTest)
  testDenyFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
  testUpdate(org.apache.cayenne.access.jdbc.SoftDeleteBatchQueryBuilderTest)
  testPeerObjectUpdatedSimpleProperty(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
  testPeerObjectUpdatedToOneRelationship(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
  testPeerObjectUpdatedToManyRelationship(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
  testPeerObjectUpdatedTempOID(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
  testMultipleSimpleProperties(org.apache.cayenne.CayenneContextGraphDiffCompressorTest)
  testComplimentaryArcs(org.apache.cayenne.CayenneContextGraphDiffCompressorTest)
  testDeletion(org.apache.cayenne.remote.CayenneContextDeletionTest)
  testOutParams(org.apache.cayenne.access.DataContextProcedureQueryTest)
  testValidate(org.apache.cayenne.CayenneContextValidationTest)
  testReturnDiffInPrePersist(org.apache.cayenne.CayenneContextServerDiffsTest)
  testReturnDiffInPreUpdate(org.apache.cayenne.CayenneContextServerDiffsTest)
  testReturnDiffClientArcChanges(org.apache.cayenne.CayenneContextServerDiffsTest)
  testReturnDiffServerArcChanges(org.apache.cayenne.CayenneContextServerDiffsTest)
  testReadRelationship(org.apache.cayenne.CDOOneToManyFKTest)
  testAddToMany(org.apache.cayenne.CDOSetRelationshipTest)
  testAddToManyViaReverse(org.apache.cayenne.CDOSetRelationshipTest)
  testDefault(org.apache.cayenne.remote.RemoteCallbacksTest)
  testServer(org.apache.cayenne.remote.LightSuperClassTest)
  testCollectionMemberOfId(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest)
  testCollectionNotMemberOfId(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest)
  testCollectionNotMemberOfToOne(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest)
  testInsertJoinWithPK(org.apache.cayenne.FlattenedRelationshipsTest)
  testQualifyOnToManyFlattened(org.apache.cayenne.FlattenedRelationshipsTest)
  testToOneSeriesFlattenedRel(org.apache.cayenne.FlattenedRelationshipsTest)
  testSynchronizeCommit(org.apache.cayenne.access.ClientServerChannelTest)
  testRollbackChanges(org.apache.cayenne.CayenneContextWithDataContextTest)
  testSelectPrimitives(org.apache.cayenne.CayenneContextWithDataContextTest)
  testCommitChangesPrimitives(org.apache.cayenne.CayenneContextWithDataContextTest)
  testPostAddCallback(org.apache.cayenne.CayenneContextWithDataContextTest)
  testPostAddOnObjectCallback(org.apache.cayenne.CayenneContextWithDataContextTest)
  testPreRemoveCallback(org.apache.cayenne.CayenneContextWithDataContextTest)
  testCAY830(org.apache.cayenne.CayenneContextWithDataContextTest)
  testOIDQueryInterception(org.apache.cayenne.CayenneContextWithDataContextTest)
  testAddToMany(org.apache.cayenne.CDOCollectionRelationshipTest)
  testAddToManyViaReverse(org.apache.cayenne.CDOCollectionRelationshipTest)
  testDelete(org.apache.cayenne.CDOOneToOneFKTest)
  testReadRelationship(org.apache.cayenne.CDOOneToOneFKTest)
  testNewAdd(org.apache.cayenne.CDOOneToOneFKTest)
  test2Null(org.apache.cayenne.CDOOneToOneFKTest)
  testTakeObjectSnapshotDependentFault(org.apache.cayenne.CDOOneToOneFKTest)
  testReplaceNull1(org.apache.cayenne.CDOOneToOneFKTest)
  testReplaceNull2(org.apache.cayenne.CDOOneToOneFKTest)
  testSyncNewObject(org.apache.cayenne.CayenneContextClientChannelEventsTest)
  testSyncNewDeletedObject(org.apache.cayenne.CayenneContextClientChannelEventsTest)
  testSyncNewObjectIntoDirtyContext(org.apache.cayenne.CayenneContextClientChannelEventsTest)
  testSyncToManyRelationship(org.apache.cayenne.CayenneContextClientChannelEventsTest)
  testSyncToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest)
  testSyncManyToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest)
  testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
  testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)

Tests run: 2031, Failures: 23, Errors: 108, Skipped: 0


Evgeny.


-----Original Message-----
From: Ольга Ткачева [mailto:tkachovaolga@gmail.com] 
Sent: Tuesday, January 12, 2010 4:43 PM
To: dev@cayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries

in oracle ReturnTypesMappingTest has error generating schema

SEVERE: Error generating schema...
java.sql.SQLException: ORA-01754: a table may contain only one column of
type LONG

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
    at
oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)

in test generate 2 long column: LONGVARBINARY_COLUMN LONG RAW NULL,
LONGVARCHAR_COLUMN LONG VARCHAR NULL


12 января 2010 г. 11:48 пользователь Andrus Adamchik <andrus@objectstyle.org
> написал:

>
> On Jan 11, 2010, at 1:45 PM, Рябицкий Евгений wrote:
>
>  Strange result... looks like I have to install Postgress to check it
>> myself... :)
>>
>> Evgeny.
>>
>
> Hi Evgeny,
>
> looking at most test failures in Olga's tests, I see that most failures are
> caused by various DB incompatibilities, and have nothing to do with the
> change itself, but rather with the unit tests themselves not being
> compatible with a given DB. Olga just logged one issue (CAY-1363) that is
> actually a bug in Cayenne. Others are similar, such as:
>
> * MySQL truncating milliseconds (so the test has to be written to compare
> with precision up to the nearest second)
> * Precision and scale not declared for decimal values, causing loss of
> precision in some DB's
> * Max length for VARCHAR being 255 on some DBs
>
> Those fairly benign issues would cause massive test failures, and
> potentially hide the real issues. And those affect not only the current
> patch, but also your earlier commit per
> http://svn.apache.org/viewvc?view=revision&revision=889168
>
> We may need your help to make your tests compatible with other DB's. Olga
> is about to send a patch on top of your patch fixing some of the above
> things (and also fix CAY-1363). Can you take it from there and install at
> least PostgreSQL and MySQL and try to make your tests run on those (in
> addition to Oracle, HSQLDB, and anything else you might be testing against)?
>
> This would be of tremendous help to us, as your changes touch on JDBC
> internals that are very sensitive to DB and driver type and version.
>
> Andrus
>
>
>
>


-- 
Olga Tkacheva

Mime
View raw message