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) <[email protected]> > > [ > 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
