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 "Andy Jefferson (JIRA)" <ji...@apache.org> on 2014/06/29 09:21:24 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=14047069#comment-14047069 ]
Andy Jefferson commented on JDO-650:
------------------------------------
Suggested JDOQL syntax would be
IF (conditional_expression)
scalar_expression
{ELSE IF (conditional_expression)
scalar_expression}*
ELSE
scalar_expression
And yes, DataNucleus has support for such a construct (unreleased).
> 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)