You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@metamodel.apache.org by "Kasper Sørensen (JIRA)" <ji...@apache.org> on 2017/11/19 20:42:00 UTC

[jira] [Updated] (METAMODEL-1134) Support for NOT / NOT IN operator

     [ https://issues.apache.org/jira/browse/METAMODEL-1134?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kasper Sørensen updated METAMODEL-1134:
---------------------------------------
    Fix Version/s:     (was: 4.5.6)
                   5.0.0

> Support for NOT / NOT IN operator
> ---------------------------------
>
>                 Key: METAMODEL-1134
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-1134
>             Project: Apache MetaModel
>          Issue Type: Improvement
>            Reporter: Hans Drexler
>             Fix For: 5.0.0
>
>
> In MetaModel it is not possible to write a query containing a NOT/NOT IN operator. In our case we want to select the highest job from a table that is not in failed or completed state. This can not be done (ok, this example is a bit too easy, but in our project we have a query that can not be handled).
> {code}
> select max(jobid) from foo where state not in ('COMPLETE', 'FAILED')
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)