[jira] [Commented] (JDO-650) Support for conditional operator ? : in JDOQL

["Andy Jefferson (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/JDO-650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14256741#comment-14256741 ] 

Andy Jefferson commented on JDO-650:
------------------------------------

SELECT FROM org.apache.jdo.tck.pc.company.FullTimeEmployee WHERE this.salary > (IF (this.department.name == 'Development') 15000 ELSE 25000) ORDER BY this.empid

Anyone want to give me an idea what/where is "empid" ? "personid" I can see (in the root class)

> Support for conditional operator ? : in JDOQL
> ---------------------------------------------
>
>                 Key: JDO-650
>                 URL: https://issues.apache.org/jira/browse/JDO-650
>             Project: JDO
>          Issue Type: New Feature
>          Components: specification, tck
>    Affects Versions: JDO 2 maintenance release 2 (2.2)
>            Reporter: Michael Bouschen
>            Assignee: Michael Bouschen
>             Fix For: JDO 3.1
>
>
> JDOQL should support the Java conditional operator ? :, e.g. salary >= 1000.0 ? salary : salary * 1.1
> The conditional operator can be mapped to the CASE-expression in SQL: CASE WHEN condition THEN thenExpr ELSE elseExpr END. Are there any issues with non-SQL datastores when supporting the conditional operator? 
> Another question: which part of a JDOQL query can include a conditional expression? I propose the query filter, the having clause and the result specification.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)