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

["Yury Gerzhedovich (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-14713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yury Gerzhedovich updated IGNITE-14713:
---------------------------------------
    Labels: calcite calcite2-required calcite3-required  (was: 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
>            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)