[JIRA] Created: (CAY-820) EJBQL resolution: OpenBase limitations

From: Andrus Adamchik (JIRA) ("Andrus)
Date: Sun Jul 01 2007 - 09:35:28 EDT

  • Next message: Andrus Adamchik (JIRA): "[JIRA] Created: (CAY-821) EJBQL resolution: FrontBase limitations"

    EJBQL resolution: OpenBase limitations
    --------------------------------------

                     Key: CAY-820
                     URL: https://issues.apache.org/cayenne/browse/CAY-820
                 Project: Cayenne
              Issue Type: Improvement
              Components: Cayenne Core Library
        Affects Versions: 3.0
                Reporter: Andrus Adamchik
                Assignee: Andrus Adamchik
                Priority: Minor
                 Fix For: 3.0

    Listing the limitations of the OpenBase DB that make EJBQL support incomplete. I am not sure if we need to fix them on our end (still I am trying to follow up on it with OpenBase, maybe they can fix it). Currently the tests for these conditions are suppressed via special AccessStackAdapter methods.

    1. Having a value on the left-hand site of the comparison in the WHERE clause.

    TestCase: DataContextEJBQLQueryTest.testSelectFromWhereEqualReverseOrder

    select a from Artist a where 'AA2' = a.artistName

    We can theoretically fix it on our end, b reversing the expressions... But we can't make it work all the way. E.g. 'AA2' = 'AA2' should work per EJBQL, but there's no valid OpenBase syntax to do the same as far as I know.

    2. Returning no rows for MIN/MAX aggregate queries when WHERE clause matches no rows.

    TestCase: DataContextEJBQLQueryTest.testSelectAggregateNull

    "select max(p.estimatedPrice), sum(p.estimatedPrice) "
                    + "from Painting p WHERE p.paintingTitle = 'NONEXISTENT'"

    All DB's return a single row with NULL values in it. OpenBase returns no rows.

    -- 
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.
    



    This archive was generated by hypermail 2.0.0 : Sun Jul 01 2007 - 09:35:52 EDT