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) <jir..pache.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
This archive was generated by hypermail 2.0.0 : Mon Jan 11 2010 - 06:06:39 EST