Skip to content

FULL OUTER JOIN crashes CH. #7544

@den-crane

Description

@den-crane

I accidentally mistyped
(foo.a = bar.b) AND (foo.b = bar.b)
instead of
(foo.a = bar.a) AND (foo.b = bar.b)


ClickHouse client version 19.17.1.1553 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 19.17.1 revision 54428.

SELECT *
FROM
(
    SELECT
        1 AS a,
        2 AS b,
        4 AS c
) AS foo
FULL OUTER JOIN
(
    SELECT
        1 AS a,
        2 AS b,
        3 AS c
) AS bar ON (foo.a = bar.b) AND (foo.b = bar.b)


Exception on client:
Code: 32. DB::Exception: Attempt to read after eof: while receiving packet from localhost:9000

Connecting to localhost:9000 as user default.
Code: 210. DB::NetException: Connection refused (localhost:9000)

Metadata

Metadata

Assignees

Labels

bugConfirmed user-visible misbehaviour in official releasecomp-joinsJOINs, JOIN algorithms, JOIN optimizations.crashCrash / segfault / abort

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions