Skip to content

if function fails when one argument is NULL and the second is const Nullable #43069

@Avogar

Description

@Avogar
SELECT if(number % 2, NULL, toNullable(1)) FROM numbers(1)

SELECT if(number % 2, NULL, toNullable(1))
FROM numbers(1)

Received exception from server (version 22.7.1):
Code: 44. DB::Exception: Received from localhost:9000. DB::Exception: Nullable(UInt8) cannot be inside Nullable column. (ILLEGAL_COLUMN)

Metadata

Metadata

Assignees

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