You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-dev@db.apache.org by "Craig L Russell (JIRA)" <ji...@apache.org> on 2014/07/11 19:04:07 UTC
[jira] [Commented] (JDO-650) Support for conditional operator ? :
in JDOQL
[ https://issues.apache.org/jira/browse/JDO-650?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14059006#comment-14059006 ]
Craig L Russell commented on JDO-650:
-------------------------------------
For my money, the following is pretty clear:
salary < 100 ? "bronze" : ( salary < 1000 ? "silver" : ( salary < 10000 ? "gold" : "platinum" ))
My issue with the other proposals is that they are pretty far away from Java...
> 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.2
>
>
> JDOQL should support the Java conditional operator ? :, e.g. salay >= 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.2#6252)