[jira] [Commented] (IGNITE-14713) Calcite. Explain failed for subquery expression.

["Ivan Daschinsky (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-14713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17366584#comment-17366584 ] 

Ivan Daschinsky commented on IGNITE-14713:
------------------------------------------

[~zstan] In current implementation of {{checkQuery}}, explaining plan checked. So if you put {{explain plan for}} inside your query you got failure. I repoved this from your reproducer and everything works.
If you don't mind, I will close this issue as not a bug.

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