You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Aleksey Plekhanov (Jira)" <ji...@apache.org> on 2026/04/20 09:05:00 UTC
[jira] [Created] (IGNITE-28577) Calcite engine.Condition with scalar NOT IN with large amount of operands hangs while planning
Aleksey Plekhanov created IGNITE-28577:
------------------------------------------
Summary: Calcite engine.Condition with scalar NOT IN with large amount of operands hangs while planning
Key: IGNITE-28577
URL: https://issues.apache.org/jira/browse/IGNITE-28577
Project: Ignite
Issue Type: Bug
Reporter: Aleksey Plekhanov
It takes to long for planning NOT IN with large amount of operands, for example:
{code:java}
String in = IntStream.range(1, 1000).mapToObj(Integer::toString).collect(Collectors.joining(", "));
assertQuery("SELECT * FROM t WHERE i NOT IN (" + in + ")").check();
{code}
Hangs and throw an error after planner timeout.
But the same expression in projects works fine:
{code:java}
String in = IntStream.range(1, 1000).mapToObj(Integer::toString).collect(Collectors.joining(", "));
assertQuery("SELECT i NOT IN (" + in + ") FROM t").check();
{code}
Condition with IN also works fine:
{code:java}
String in = IntStream.range(1, 1000).mapToObj(Integer::toString).collect(Collectors.joining(", "));
assertQuery("SELECT * FROM t WHERE i IN (" + in + ")").check();
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)