[
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)
