Unable to use CTE scalar as numbers() argument

[pablote]

This is a simplification of what I'm trying to achieve:

with
    (select 25) as something
select *, something
from numbers(toUInt64(something));

It fails with error: Code: 47, e.displayText() = DB::Exception: Missing columns: 'something' while processing query: 'toUInt64(something)', required columns: 'something', source columns: '_dummy' (version 19.17.5.18 (official build))

Replace last line with a fixed value, and the query works fine. Is it not possible to use a CTE value as input to numbers()? Any workaround?

thanks!

[lopn]

  with
    (select 25) as something
select toUInt64(something)

[amosbird]

It's because table functions are evaluated earlier than scalar subqueries, and in fact they don't take subqueries into account at all. However it's still a valid use case. You can switch it to a feature request and it might work in near future.

[andrewzolotukhin]

Would be great to have that...

[azat]

This had been fixed in analyzer - #56337 (comment)