Skip to content

JIT compiler issue / Cannot convert column because it is non constant in source stream but must be constant in result #51090

@den-crane

Description

@den-crane

https://fiddle.clickhouse.com/52b751b5-fa79-4865-bd9b-49aca042bc13

SELECT
    sum(c),
    toInt32((h - null::Nullable(DateTime)) / 3600) + 1 AS a
FROM
(
    SELECT count() AS c, h
    FROM ( SELECT now() AS h )
    WHERE toInt32((h - null::Nullable(DateTime)) / 3600) + 1 = 1
    GROUP BY h
)
GROUP BY a settings min_count_to_compile_expression=0;

DB::Exception: Cannot convert column 
`plus(toInt32(divide(minus(h, CAST(NULL, 'Nullable(DateTime)')), 3600)), 1)` 
because it is non constant in source stream but must be constant in result. (ILLEGAL_COLUMN)

WA: compile_expressions=0

Metadata

Metadata

Labels

bugConfirmed user-visible misbehaviour in official release

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions