[IGNITE-15866] Nested SELECT with WHERE clause failes with IgniteCheckedException

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.11
• Component/s: sql, thin client
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Timotheus Preisinger
• Created: 02/Nov/21 15:03
• Updated: 02/Nov/21 15:03

Description

Steps to reproduce:

 

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