RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries

From: òÑÂÉÃËÉÊ å×ÇÅÎÉ (eryabitski..iasoft.ru)
Date: Mon Jan 11 2010 - 06:45:36 EST

  • Next message: ïÌØÇÁ ôËÁÞÅ×: "Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries"

    Strange result... looks like I have to install Postgress to check it myself... :)

    Evgeny.

    -----Original Message-----
    From: ïÌØÇÁ ôËÁÞÅ×Á [mailto:tkachovaolg..mail.com]
    Sent: Monday, January 11, 2010 2:06 PM
    To: de..ayenne.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) <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:46:34 EST