Timotheus Preisinger created IGNITE-15866:
---------------------------------------------

             Summary: Nested SELECT with WHERE clause failes with 
IgniteCheckedException
                 Key: IGNITE-15866
                 URL: https://issues.apache.org/jira/browse/IGNITE-15866
             Project: Ignite
          Issue Type: Bug
          Components: sql, thin client
    Affects Versions: 2.11
            Reporter: Timotheus Preisinger


Steps to reproduce:

 
{code:java}
CREATE TABLE TEST (COL1 int primary key, COL2 int, COL3 int);
INSERT INTO TEST VALUES(1,2,3);

--Working:
SELECT * FROM (SELECT * FROM (SELECT * FROM TEST)) WHERE COL1 = 1;
--Also working:
SELECT * FROM (SELECT * FROM (SELECT * FROM TEST WHERE COL1 = 1));
--Not Working:
SELECT * FROM (SELECT * FROM (SELECT * FROM TEST) WHERE COL1 = 1);
{code}
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to