Skip to content

Hash on array with NULL throws exception #48623

@zhanglistar

Description

@zhanglistar
CREATE TABLE test
(
    c Array(Nullable(Int64))
)
ENGINE = Memory;

INSERT INTO test VALUES (NULL) ([-1,NULL]);

SELECT xxHash32(c) FROM test

Produces

Received exception from server (version 23.4.1):
Code: 48. DB::Exception: Received from localhost:9001. DB::Exception: Method getDataAt is not supported for Nullable(Int64) in case if value is NULL: while executing 'FUNCTION xxHash32(a :: 0) -> xxHash32(a) UInt32 : 1'. (NOT_IMPLEMENTED)

This used to work until #40195.

See also #51541

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions