metamodel-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kasper Sørensen (JIRA) <j...@apache.org>
Subject [jira] [Closed] (METAMODEL-119) Subqueries within the IN statement do not work
Date Wed, 11 Mar 2015 17:50:38 GMT

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

Kasper Sørensen closed METAMODEL-119.
-------------------------------------
    Resolution: Duplicate

> Subqueries within the IN statement do not work
> ----------------------------------------------
>
>                 Key: METAMODEL-119
>                 URL: https://issues.apache.org/jira/browse/METAMODEL-119
>             Project: Apache MetaModel
>          Issue Type: Bug
>    Affects Versions: 4.3.0-incubating
>            Reporter: Alberto
>
> The following query does not work:
> SELECT INVENTORY_ID FROM INVENTORY WHERE FILM_ID IN (SELECT film_id from film where lower(title)
like '%war%')
> The next one works though:
> SELECT INVENTORY_ID FROM INVENTORY WHERE FILM_ID IN (1, 2, 3)



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

Mime
View raw message