ydb icon indicating copy to clipboard operation
ydb copied to clipboard

Missing Passthrough(/:kv_urls) constraint in node Just

Open rvu1024 opened this issue 10 months ago • 0 comments

Fatal: contrib/ydb/library/yql/core/yql_expr_constraint.cpp:3745 CheckExpected(): requirement newConstr failed, message: Rewrite error, missing Passthrough(/:kv_urls) constraint in node Just, code: 1

yqlrun query to reproduce:

USE plato;

insert into @a
select * from (
    select [Just("a"), Just("b")] as url
) flatten list by url;

insert into @b
select Just(["b", "c"]) as kv_urls
;

commit;

$BAD_URLS =
SELECT url
FROM @a
where url == ""
;

SELECT
  ListHasItems(ListFilter(kv_urls, ($x)->{RETURN $x IN $BAD_URLS})) AS bad_kv,
FROM @b;

rvu1024 avatar Apr 24 '24 16:04 rvu1024