You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by Ольга Ткачева <tk...@gmail.com> on 2010/01/11 12:05:54 UTC
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
values in Row Queries
I apply the latest patch from this Jira locally and run a test.
*Result without the patch*
*mysql* - all ok
*sqlserver*
Failed tests:
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
Tests run: 1986, Failures: 3, Errors: 0, Skipped: 0
*postgres*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
Tests in error:
testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
Tests run: 1986, Failures: 3, Errors: 2, Skipped: 0
*Result with the patch*
*mysql*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
Tests run: 2030, Failures: 3, Errors: 0, Skipped: 0
*sqlserver*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest)
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
testDECIMAL2(org.apache.cayenne.access.ReturnTypesMappingTest)
testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
testNUMERIC2(org.apache.cayenne.access.ReturnTypesMappingTest)
testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
Tests in error:
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: 2030, Failures: 11, Errors: 4, Skipped: 0
*postgres*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest)
testBIGINT(org.apache.cayenne.access.ReturnTypesMappingTest)
testBINARY(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)
testLONGVARBINARY(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)
testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
testVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
Tests in error:
testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
Tests run: 2030, Failures: 26, Errors: 2, Skipped: 0
2010/1/10 Andrus Adamchik (JIRA) <ji...@apache.org>
>
> [
> https://issues.apache.org/jira/browse/CAY-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798458#action_12798458]
>
> Andrus Adamchik commented on CAY-1354:
> --------------------------------------
>
> Next week myself or Olga may try to test this patch in our environment that
> includes PostgreSQL and SQLServer (I think the later was causing trouble)...
>
> > Wrong Types mapping for selected values in Row Queries
> > ------------------------------------------------------
> >
> > Key: CAY-1354
> > URL: https://issues.apache.org/jira/browse/CAY-1354
> > Project: Cayenne
> > Issue Type: Bug
> > Components: Core Library
> > Affects Versions: 3.1M1
> > Reporter: Evgeny Ryabitskiy
> > Assignee: Evgeny Ryabitskiy
> > Priority: Critical
> > Fix For: 3.1M1
> >
> > Attachments: CAY-1354.patch, CAY-1354_TEST.patch,
> ReturnTypesMappingTest.java
> >
> >
> > By default every SQL type is mapped to some Java type by modeler.
> > I am expecting same behavior in common DataRow queries (without ORM).
> > But in fact half of types are not mapped correctly....
> > Attached JUnit test can to explain problem with more details...
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
--
Olga Tkacheva
RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Рябицкий Евгений <er...@diasoft.ru>.
Nope. But it helps... thx! :)
Evgeny.
-----Original Message-----
From: Tore Halset [mailto:halset@pvv.ntnu.no]
Sent: Wednesday, January 13, 2010 10:21 AM
To: dev@cayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
This is an old-timer. Did you do a "createlang plpgsql databasename"?
- Tore.
On Jan 13, 2010, at 07:54 , Рябицкий Евгений wrote:
> 13.01.2010 9:52:17 org.apache.cayenne.unit.CayenneResources getResources
> SEVERE: Error generating schema...
> org.postgresql.util.PSQLException: ERROR: language "plpgsql" does not exist
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Tore Halset <ha...@pvv.ntnu.no>.
This is an old-timer. Did you do a "createlang plpgsql databasename"?
- Tore.
On Jan 13, 2010, at 07:54 , Рябицкий Евгений wrote:
> 13.01.2010 9:52:17 org.apache.cayenne.unit.CayenneResources getResources
> SEVERE: Error generating schema...
> org.postgresql.util.PSQLException: ERROR: language "plpgsql" does not exist
RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Рябицкий Евгений <er...@diasoft.ru>.
13.01.2010 9:52:17 org.apache.cayenne.unit.CayenneResources getResources
SEVERE: Error generating schema...
org.postgresql.util.PSQLException: ERROR: language "plpgsql" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
at org.apache.cayenne.unit.AccessStackAdapter.executeDDL(AccessStackAdapter.java:231)
at org.apache.cayenne.unit.AccessStackAdapter.executeDDL(AccessStackAdapter.java:240)
at org.apache.cayenne.unit.PostgresStackAdapter.createdTables(PostgresStackAdapter.java:68)
at org.apache.cayenne.unit.AbstractAccessStack.createSchema(AbstractAccessStack.java:267)
at org.apache.cayenne.unit.SimpleAccessStack.createSchema(SimpleAccessStack.java:121)
at org.apache.cayenne.unit.CayenneResources.rebuildSchema(CayenneResources.java:192)
at org.apache.cayenne.unit.CayenneResources.getResources(CayenneResources.java:108)
at org.apache.cayenne.unit.CayenneCase.<init>(CayenneCase.java:66)
at org.apache.cayenne.CayenneDataObjectValidationTest.<init>(CayenneDataObjectValidationTest.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at junit.framework.TestSuite.createTest(TestSuite.java:131)
at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
at junit.framework.TestSuite.<init>(TestSuite.java:75)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at org.apache.maven.surefire.junit.JUnitTestSet.constructTestObject(JUnitTestSet.java:151)
at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:197)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
at org.apache.maven.surefire.Surefire.run(Surefire.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)
Tests run: 3, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 9.093 sec <<< FAILURE!
-----Original Message-----
From: Ольга Ткачева [mailto:tkachovaolga@gmail.com]
Sent: Tuesday, January 12, 2010 7:43 PM
To: dev@cayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Evgeny, give your error in postgres. I think this error while generating the
schema.
12 января 2010 г. 16:50 пользователь Рябицкий Евгений <
eryabitskiy@diasoft.ru> написал:
>
> 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
>
--
Olga Tkacheva
RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Рябицкий Евгений <er...@diasoft.ru>.
org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "artist_pkey"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:343)
at org.apache.cayenne.access.jdbc.SQLTemplateAction.execute(SQLTemplateAction.java:149)
at org.apache.cayenne.access.jdbc.SQLTemplateAction.performAction(SQLTemplateAction.java:123)
at org.apache.cayenne.access.DataNodeQueryAction.runQuery(DataNodeQueryAction.java:87)
at org.apache.cayenne.access.DataNode.performQueries(DataNode.java:269)
at org.apache.cayenne.access.DataDomainQueryAction.runQuery(DataDomainQueryAction.java:418)
at org.apache.cayenne.access.DataDomainQueryAction.access$000(DataDomainQueryAction.java:65)
at org.apache.cayenne.access.DataDomainQueryAction$2.transform(DataDomainQueryAction.java:391)
at org.apache.cayenne.access.DataDomain.runInTransaction(DataDomain.java:847)
at org.apache.cayenne.access.DataDomainQueryAction.runQueryInTransaction(DataDomainQueryAction.java:388)
at org.apache.cayenne.access.UnitTestDomainQueryAction.runQueryInTransaction(UnitTestDomainQueryAction.java:54)
at org.apache.cayenne.access.DataDomainQueryAction.execute(DataDomainQueryAction.java:117)
at org.apache.cayenne.access.UnitTestDomainQueryAction.execute(UnitTestDomainQueryAction.java:48)
at org.apache.cayenne.access.UnitTestDomain.onQuery(UnitTestDomain.java:63)
at org.apache.cayenne.unit.SimpleAccessStack.createTestData(SimpleAccessStack.java:97)
at org.apache.cayenne.unit.CayenneCase.createTestData(CayenneCase.java:119)
at org.apache.cayenne.access.DataContextEJBQLQueryTest.testSelectFromWhereGreaterOrEqual(DataContextEJBQLQueryTest.java:314)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
at junit.framework.TestResult$1.protect(TestResult.java:106)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.framework.TestResult.run(TestResult.java:109)
at junit.framework.TestCase.run(TestCase.java:118)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:213)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
at org.apache.maven.surefire.Surefire.run(Surefire.java:180)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)
-----Original Message-----
From: Ольга Ткачева [mailto:tkachovaolga@gmail.com]
Sent: Tuesday, January 12, 2010 7:43 PM
To: dev@cayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Evgeny, give your error in postgres. I think this error while generating the
schema.
12 января 2010 г. 16:50 пользователь Рябицкий Евгений <
eryabitskiy@diasoft.ru> написал:
>
> 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
>
--
Olga Tkacheva
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
values in Row Queries
Posted by Ольга Ткачева <tk...@gmail.com>.
Evgeny, give your error in postgres. I think this error while generating the
schema.
12 января 2010 г. 16:50 пользователь Рябицкий Евгений <
eryabitskiy@diasoft.ru> написал:
>
> 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
>
--
Olga Tkacheva
RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Рябицкий Евгений <er...@diasoft.ru>.
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
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
values in Row Queries
Posted by Ольга Ткачева <tk...@gmail.com>.
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
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Andrus Adamchik <an...@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
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
values in Row Queries
Posted by Ольга Ткачева <tk...@gmail.com>.
I have run tests on 3.0. results:
*postgres
*
Tests in error:
testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
Tests run: 2083, Failures: 0, Errors: 1, Skipped: 0
*mysql*
Tests in error:
test1MBClob(org.apache.cayenne.access.DataContextClobTest)
test1MBBlob(org.apache.cayenne.access.DataContextBlobTest)
Tests run: 2083, Failures: 0, Errors: 2, Skipped: 0
*sqlserver*
Failed tests:
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
Tests run: 2083, Failures: 1, Errors: 0, Skipped: 0
11 января 2010 г. 13:45 пользователь Рябицкий Евгений <
eryabitskiy@diasoft.ru> написал:
> Strange result... looks like I have to install Postgress to check it
> myself... :)
>
> Evgeny.
>
>
>
> -----Original Message-----
> From: Ольга Ткачева [mailto:tkachovaolga@gmail.com]
> Sent: Monday, January 11, 2010 2:06 PM
> To: dev@cayenne.apache.org
> Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
> values in Row Queries
>
> I apply the latest patch from this Jira locally and run a test.
>
> *Result without the patch*
>
> *mysql* - all ok
>
> *sqlserver*
>
> Failed tests:
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
> testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
>
> Tests run: 1986, Failures: 3, Errors: 0, Skipped: 0
>
> *postgres*
>
> Failed tests:
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
>
> Tests in error:
> testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
> testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
>
> Tests run: 1986, Failures: 3, Errors: 2, Skipped: 0
>
>
>
> *Result with the patch*
>
> *mysql*
>
> Failed tests:
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
>
> Tests run: 2030, Failures: 3, Errors: 0, Skipped: 0
>
>
> *sqlserver*
>
> Failed tests:
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
>
>
> testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest)
> testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
> testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDECIMAL2(org.apache.cayenne.access.ReturnTypesMappingTest)
> testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
> testNUMERIC2(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests in error:
> 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: 2030, Failures: 11, Errors: 4, Skipped: 0
>
>
> *postgres*
>
> Failed tests:
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
>
>
> testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest)
> testBIGINT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testBINARY(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)
> testLONGVARBINARY(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)
> testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests in error:
> testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
> testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
>
> Tests run: 2030, Failures: 26, Errors: 2, Skipped: 0
>
>
>
>
> 2010/1/10 Andrus Adamchik (JIRA) <ji...@apache.org>
>
> >
> > [
> >
> https://issues.apache.org/jira/browse/CAY-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798458#action_12798458
> ]
> >
> > Andrus Adamchik commented on CAY-1354:
> > --------------------------------------
> >
> > Next week myself or Olga may try to test this patch in our environment
> that
> > includes PostgreSQL and SQLServer (I think the later was causing
> trouble)...
> >
> > > Wrong Types mapping for selected values in Row Queries
> > > ------------------------------------------------------
> > >
> > > Key: CAY-1354
> > > URL: https://issues.apache.org/jira/browse/CAY-1354
> > > Project: Cayenne
> > > Issue Type: Bug
> > > Components: Core Library
> > > Affects Versions: 3.1M1
> > > Reporter: Evgeny Ryabitskiy
> > > Assignee: Evgeny Ryabitskiy
> > > Priority: Critical
> > > Fix For: 3.1M1
> > >
> > > Attachments: CAY-1354.patch, CAY-1354_TEST.patch,
> > ReturnTypesMappingTest.java
> > >
> > >
> > > By default every SQL type is mapped to some Java type by modeler.
> > > I am expecting same behavior in common DataRow queries (without ORM).
> > > But in fact half of types are not mapped correctly....
> > > Attached JUnit test can to explain problem with more details...
> >
> > --
> > This message is automatically generated by JIRA.
> > -
> > You can reply to this email to add a comment to the issue online.
> >
> >
>
>
> --
> Olga Tkacheva
>
--
Olga Tkacheva
RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Рябицкий Евгений <er...@diasoft.ru>.
Strange result... looks like I have to install Postgress to check it myself... :)
Evgeny.
-----Original Message-----
From: Ольга Ткачева [mailto:tkachovaolga@gmail.com]
Sent: Monday, January 11, 2010 2:06 PM
To: dev@cayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
I apply the latest patch from this Jira locally and run a test.
*Result without the patch*
*mysql* - all ok
*sqlserver*
Failed tests:
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
Tests run: 1986, Failures: 3, Errors: 0, Skipped: 0
*postgres*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
Tests in error:
testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
Tests run: 1986, Failures: 3, Errors: 2, Skipped: 0
*Result with the patch*
*mysql*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
Tests run: 2030, Failures: 3, Errors: 0, Skipped: 0
*sqlserver*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest)
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
testDECIMAL2(org.apache.cayenne.access.ReturnTypesMappingTest)
testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
testNUMERIC2(org.apache.cayenne.access.ReturnTypesMappingTest)
testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
Tests in error:
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: 2030, Failures: 11, Errors: 4, Skipped: 0
*postgres*
Failed tests:
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest)
testBIGINT(org.apache.cayenne.access.ReturnTypesMappingTest)
testBINARY(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)
testLONGVARBINARY(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)
testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
testVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
Tests in error:
testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
Tests run: 2030, Failures: 26, Errors: 2, Skipped: 0
2010/1/10 Andrus Adamchik (JIRA) <ji...@apache.org>
>
> [
> https://issues.apache.org/jira/browse/CAY-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798458#action_12798458]
>
> Andrus Adamchik commented on CAY-1354:
> --------------------------------------
>
> Next week myself or Olga may try to test this patch in our environment that
> includes PostgreSQL and SQLServer (I think the later was causing trouble)...
>
> > Wrong Types mapping for selected values in Row Queries
> > ------------------------------------------------------
> >
> > Key: CAY-1354
> > URL: https://issues.apache.org/jira/browse/CAY-1354
> > Project: Cayenne
> > Issue Type: Bug
> > Components: Core Library
> > Affects Versions: 3.1M1
> > Reporter: Evgeny Ryabitskiy
> > Assignee: Evgeny Ryabitskiy
> > Priority: Critical
> > Fix For: 3.1M1
> >
> > Attachments: CAY-1354.patch, CAY-1354_TEST.patch,
> ReturnTypesMappingTest.java
> >
> >
> > By default every SQL type is mapped to some Java type by modeler.
> > I am expecting same behavior in common DataRow queries (without ORM).
> > But in fact half of types are not mapped correctly....
> > Attached JUnit test can to explain problem with more details...
>
> --
> This message is automatically generated by JIRA.
> -
> You can reply to this email to add a comment to the issue online.
>
>
--
Olga Tkacheva
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
values in Row Queries
Posted by Andrey Razumovsky <ra...@gmail.com>.
11 января 2010 г. 17:03 пользователь Рябицкий Евгений <
eryabitskiy@diasoft.ru> написал:
> Can't imagine how EJBQLQueryTest is related to my changes. Should see some
> logs...
>
As I already wrote, EJBQLQueryTest fails to my changes:
http://cayenne.markmail.org/search/#query:+page:2+mid:nmtd4haq53lvqoay+state:results
RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Posted by Рябицкий Евгений <er...@diasoft.ru>.
Still little bit confusing...
>I apply the latest patch from this Jira locally and run a test.
>>
>> *Result without the patch*
>>
>> *mysql* - all ok
>>
>it hsqldb - ok
So you applied patch or only add tests?
Tests shouldn't work on hsqldb without patch. At least I check everything on hsqldb and get everything working there before publishing patch.
I guess... sections for *Result without the patch* and *Result with the patch* should be switched? :) or it looks like my patch broke everything?
Also this tests assertation should be fixed (I will publish newer patch including that fixes)
testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
So there still:
*postgres*
Tests in error:
testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
Second one is mine and quite new. It can be not well written.
Can't imagine how EJBQLQueryTest is related to my changes. Should see some logs...
*sqlserver*
Failed tests:
testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
Also strange fail. Can be related to some strange type assert.
Evgeny.
-----Original Message-----
From: Ольга Ткачева [mailto:tkachovaolga@gmail.com]
Sent: Monday, January 11, 2010 4:47 PM
To: dev@cayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
sorry, i have confused results mysql and hsqldb
I apply the latest patch from this Jira locally and run a test.
>
> *Result without the patch*
>
> *mysql* - all ok
>
it hsqldb - ok
mysql have old errors
Tests in error:
test1MBClob(org.apache.cayenne.access.DataContextClobTest)
test1MBBlob(org.apache.cayenne.access.DataContextBlobTest)
Tests run: 2083, Failures: 0, Errors: 2, Skipped: 0
>
> *Result with the patch*
>
> *mysql*
>
> Failed tests:
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
>
> Tests run: 2030, Failures: 3, Errors: 0, Skipped: 0
>
>
it hsqldb have this errors
>
>
>
>
> 2010/1/10 Andrus Adamchik (JIRA) <ji...@apache.org>
>
>
>> [
>> https://issues.apache.org/jira/browse/CAY-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798458#action_12798458]
>>
>> Andrus Adamchik commented on CAY-1354:
>> --------------------------------------
>>
>> Next week myself or Olga may try to test this patch in our environment
>> that includes PostgreSQL and SQLServer (I think the later was causing
>> trouble)...
>>
>> > Wrong Types mapping for selected values in Row Queries
>> > ------------------------------------------------------
>> >
>> > Key: CAY-1354
>> > URL: https://issues.apache.org/jira/browse/CAY-1354
>> > Project: Cayenne
>> > Issue Type: Bug
>> > Components: Core Library
>> > Affects Versions: 3.1M1
>> > Reporter: Evgeny Ryabitskiy
>> > Assignee: Evgeny Ryabitskiy
>> > Priority: Critical
>> > Fix For: 3.1M1
>> >
>> > Attachments: CAY-1354.patch, CAY-1354_TEST.patch,
>> ReturnTypesMappingTest.java
>> >
>> >
>> > By default every SQL type is mapped to some Java type by modeler.
>> > I am expecting same behavior in common DataRow queries (without ORM).
>> > But in fact half of types are not mapped correctly....
>> > Attached JUnit test can to explain problem with more details...
>>
>> --
>> This message is automatically generated by JIRA.
>> -
>> You can reply to this email to add a comment to the issue online.
>>
>>
>
>
> --
> Olga Tkacheva
>
--
Olga Tkacheva
Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
values in Row Queries
Posted by Ольга Ткачева <tk...@gmail.com>.
sorry, i have confused results mysql and hsqldb
I apply the latest patch from this Jira locally and run a test.
>
> *Result without the patch*
>
> *mysql* - all ok
>
it hsqldb - ok
mysql have old errors
Tests in error:
test1MBClob(org.apache.cayenne.access.DataContextClobTest)
test1MBBlob(org.apache.cayenne.access.DataContextBlobTest)
Tests run: 2083, Failures: 0, Errors: 2, Skipped: 0
>
> *Result with the patch*
>
> *mysql*
>
> Failed tests:
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
>
> Tests run: 2030, Failures: 3, Errors: 0, Skipped: 0
>
>
it hsqldb have this errors
>
>
>
>
> 2010/1/10 Andrus Adamchik (JIRA) <ji...@apache.org>
>
>
>> [
>> https://issues.apache.org/jira/browse/CAY-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798458#action_12798458]
>>
>> Andrus Adamchik commented on CAY-1354:
>> --------------------------------------
>>
>> Next week myself or Olga may try to test this patch in our environment
>> that includes PostgreSQL and SQLServer (I think the later was causing
>> trouble)...
>>
>> > Wrong Types mapping for selected values in Row Queries
>> > ------------------------------------------------------
>> >
>> > Key: CAY-1354
>> > URL: https://issues.apache.org/jira/browse/CAY-1354
>> > Project: Cayenne
>> > Issue Type: Bug
>> > Components: Core Library
>> > Affects Versions: 3.1M1
>> > Reporter: Evgeny Ryabitskiy
>> > Assignee: Evgeny Ryabitskiy
>> > Priority: Critical
>> > Fix For: 3.1M1
>> >
>> > Attachments: CAY-1354.patch, CAY-1354_TEST.patch,
>> ReturnTypesMappingTest.java
>> >
>> >
>> > By default every SQL type is mapped to some Java type by modeler.
>> > I am expecting same behavior in common DataRow queries (without ORM).
>> > But in fact half of types are not mapped correctly....
>> > Attached JUnit test can to explain problem with more details...
>>
>> --
>> This message is automatically generated by JIRA.
>> -
>> You can reply to this email to add a comment to the issue online.
>>
>>
>
>
> --
> Olga Tkacheva
>
--
Olga Tkacheva