Clickhouse return database not exist(error code 81) about clickhouse HOT 8 CLOSED

we are having the same problem, it only started happening after we updated clickhouse to 24.4.1 revision 54467
for us the query is like this

SELECT 
			'current' as period,
			date(event_time,'America/Los_Angeles') as label,
			arrayFilter(x -> dateDiff('day', event_time, toDateTime(parseDateTime64BestEffortOrZero(JSONExtractString(x, 'event_time')))) >= 0 and dateDiff('day', event_time, toDateTime(parseDateTime64BestEffortOrZero(JSONExtractString(x, 'event_time')))) < 14, workflows) as a
		FROM 
			orders
		WHERE 
			domain_id='xxx' 
			AND date(event_time,'America/Los_Angeles') BETWEEN '2024-04-07' AND '2024-05-07'  
	    limit 20

when removing the arrayFilter, query works

from clickhouse.

Issues are simpler to investigate if you provide reproducible examples -> https://fiddle.clickhouse.com/

from clickhouse.

also just checked this problem is only happening with distributed tables, i tried running the same query on the local table and it is working fine.

from clickhouse.

Issues are simpler to investigate if you provide reproducible examples -> https://fiddle.clickhouse.com/

CREATE TABLE users (uid Int16, name String, age Int16) ENGINE=Memory;

INSERT INTO users VALUES (1231, 'John', 33);
INSERT INTO users VALUES (6666, 'Ksenia', 48);
INSERT INTO users VALUES (8888, 'Alice', 50);

with test AS (
select uid from users
where age > 40
)
select
uid,
name,
age
from
users
where
uid in (test.uid);

from clickhouse.

it can reproduce with the sql I just posted. @Algunenano
also, you can successfully run the SQL just replace test.uid with test

from clickhouse.

@livingston0318 you should use a subquery

with test AS ( select uid from users where age > 40 )
  select uid,name, age
  from users
  where uid in (select uid from test);

https://fiddle.clickhouse.com/67c86990-4d3f-400b-ab8b-6ca5cbeb59e7

with test AS ( select uid from users where age > 40 )
  select uid,name, age
  from users
  where uid in (test.uid);

Such syntax is not supported by other databases, PG, Mysql. It was an undefined behaviour that it worked before.
I think it's good that it does not work anymore.
The issue should be closed after adding positive and negative tests.

from clickhouse.

Ah, I see, it never worked at all. https://fiddle.clickhouse.com/749eb4c7-5b07-4da9-a640-da57e89a2b6e

from clickhouse.

@den-crane thanks bro, this issue can be closed.

from clickhouse.