Skip to content

merge raises internal ugly error on CH if types are not compatible #1481

@shcheklein

Description

@shcheklein
DB::Exception: There is no supertype for types String, Int64 because some of them are String/FixedString/Enum and some of them are not: JOIN  INNER JOIN ... ON PKgFxBXUIkWjxKAV.file_id = avtEcmyNKoXggsXh.file_id cannot infer common type in ON section for keys. Left key __table1.file_id type String. Right key __table3.file_id type Int64. Stack trace:

We need to check schema and don't allow this

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions