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

Posted to dev@metamodel.apache.org by "Alberto (JIRA)" <ji...@apache.org> on 2015/03/11 18:30:38 UTC

[jira] [Created] (METAMODEL-119) Subqueries within the IN statement do not work

Alberto created METAMODEL-119:
---------------------------------

             Summary: 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)