Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 2.0.0-M2
    • Fix Version/s: 2.0.0-M2
    • Component/s: query
    • Labels:
      None

      Issue Links

        Activity

        Hide
        Catalina Wei added a comment -

        The following queries are valid in JPA2

        1. selection can be a math expression, for example :

        select e.salary + e.bonus from Emp e

        2. selection can be aliased such that the alias can be used in Order by clause, example:

        select e.salary + e.bonus as comp from Emp e order by comp

        Show
        Catalina Wei added a comment - The following queries are valid in JPA2 1. selection can be a math expression, for example : select e.salary + e.bonus from Emp e 2. selection can be aliased such that the alias can be used in Order by clause, example: select e.salary + e.bonus as comp from Emp e order by comp
        Hide
        Catalina Wei added a comment -

        Add support for JPA2 GeneralCaseExpression and SimpleCaseExpression for JDBC back-end.
        Support for In-Memory case expression evaluation will be added later.

        Show
        Catalina Wei added a comment - Add support for JPA2 GeneralCaseExpression and SimpleCaseExpression for JDBC back-end. Support for In-Memory case expression evaluation will be added later.
        Hide
        Catalina Wei added a comment -

        In this iteration 1, we provide the following support of JPA2 Query constructs (JPA2 public review draft: dated Oct. 31, 2008):

        1. Simple Case Expression
        2. General Case Expression
        3. Coalesce Expression
        4. Nullif Expression

        in addition to the above,
        5. the select expression allow math expressions
        6. the result alias can be specified for select expression; the result alias can be used in ORDER BY clause.

        Show
        Catalina Wei added a comment - In this iteration 1, we provide the following support of JPA2 Query constructs (JPA2 public review draft: dated Oct. 31, 2008): 1. Simple Case Expression 2. General Case Expression 3. Coalesce Expression 4. Nullif Expression in addition to the above, 5. the select expression allow math expressions 6. the result alias can be specified for select expression; the result alias can be used in ORDER BY clause.

          People

          • Assignee:
            Catalina Wei
            Reporter:
            Catalina Wei
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development