cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Рябицкий Евгений <eryabits...@diasoft.ru>
Subject RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Date Mon, 11 Jan 2010 11:45:36 GMT
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) <jira@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

Mime
View raw message