Evgeny, give your error in postgres. I think this error while generating the schema.
12 января 2010 г. 16:50 пользователь Рябицкий Евгений < [email protected]> написал: > > 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 > -- Olga Tkacheva
