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:14:00 UTC
[jira] [Comment Edited] (IGNITE-14713) Calcite. Explain failed for
subquery expression.
[ https://issues.apache.org/jira/browse/IGNITE-14713?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17366584#comment-17366584 ]
Ivan Daschinsky edited comment on IGNITE-14713 at 6/21/21, 1:13 PM:
--------------------------------------------------------------------
[~zstan] In current implementation of {{checkQuery}}, explaining plan checked already. So if you put {{explain plan for}} inside your query you got syntax check failure. I have checked your reproducer and everything works.
If you don't mind, I will close this issue as not a bug.
was (Author: ivandasch):
[~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)