You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ivan Daschinsky (Jira)" <ji...@apache.org> on 2021/06/21 13:30:00 UTC
[jira] [Resolved] (IGNITE-14713) Calcite. Explain failed for
subquery expression.
[ https://issues.apache.org/jira/browse/IGNITE-14713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ivan Daschinsky resolved IGNITE-14713.
--------------------------------------
Resolution: Cannot Reproduce
Not reproduced on latest {{sql-calcite}}
> Calcite. Explain failed for subquery expression.
> ------------------------------------------------
>
> Key: IGNITE-14713
> URL: https://issues.apache.org/jira/browse/IGNITE-14713
> Project: Ignite
> Issue Type: Bug
> Components: sql
> Reporter: Stanilovsky Evgeny
> Assignee: Ivan Daschinsky
> Priority: Major
> Labels: calcite, calcite2-required, calcite3-required
>
> 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)