Alberto created METAMODEL-118:
---------------------------------
Summary: Subqueries within the IN statement do not work
Key: METAMODEL-118
URL: https://issues.apache.org/jira/browse/METAMODEL-118
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)
