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:tkachovaolg..mail.com]
Sent: Tuesday, January 12, 2010 4:43 PM
To: de..ayenne.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 <andru..bjectstyle.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
This archive was generated by hypermail 2.0.0 : Tue Jan 12 2010 - 09:51:30 EST