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:[email protected]] Sent: Tuesday, January 12, 2010 4:43 PM To: [email protected] 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 <[email protected] > написал: > > 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
