Unexpected Set for IN is not created yet error

[alesapin]

How to reproduce

CREATE TABLE testmt
(
    `CounterID` UInt64, 
    `value` String
)
ENGINE = MergeTree()
ORDER BY CounterID;

INSERT INTO testmt VALUES (1, '1');

SELECT arrayJoin([CounterID NOT IN (2)]) AS counter
FROM testmt
WHERE CounterID IN (2)
GROUP BY counter;

Code: 49. DB::Exception: Received from localhost:9000. DB::Exception: Set for IN is not created yet.

Introduced in #7497.

[alesapin]

@amosbird Maybe you have any ideas about how to fix it?

[amosbird]

Interesting.

a reduced test:

select CounterID NOT IN (2) a FROM testmt WHERE CounterID IN (2) group by a;

however these two variants work:

SELECT CounterID NOT IN (3) a FROM testmt WHERE CounterID IN (2) group by a;

SELECT CounterID NOT IN (2) a FROM testmt WHERE CounterID IN (2);

Is it somehow urgent? I might no be available recently.

[filimonov]

Fixed in #8868