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

From: Ольга Ткачев (tkachovaolg..mail.com)
Date: Mon Jan 11 2010 - 07:40:23 EST

  • Next message: Ольга Ткачев: "Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries"

    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 пользователь Рябицкий Евгений <
    eryabitski..iasoft.ru> написал:

    > 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
    >

    -- 
    Olga Tkacheva
    



    This archive was generated by hypermail 2.0.0 : Mon Jan 11 2010 - 07:41:00 EST