Stanilovsky Evgeny created IGNITE-14713:
-------------------------------------------
Summary: Calcite. Explain failed for subquery expression.
Key: IGNITE-14713
URL: https://issues.apache.org/jira/browse/IGNITE-14713
Project: Ignite
Issue Type: Improvement
Components: sql
Reporter: Stanilovsky Evgeny
Failure test:
{code:java}
@Test
public void test0() throws Exception {
IgniteCache<Integer, Integer> cache = grid(0).getOrCreateCache(
new CacheConfiguration<Integer, Integer>("test")
.setBackups(1)
.setIndexedTypes(Integer.class, Integer.class)
);
for (int i = 0; i < 100; i++)
cache.put(i, i);
awaitPartitionMapExchange();
// Correlated INNER join.
checkQuery("explain plan for SELECT t._val FROM \"test\".Integer t
WHERE t._val < 5 AND " +
"t._key in (SELECT x FROM table(system_range(t._val, t._val))) ")
.check();
}
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
