Skip to content

distsql: heterogeneous big endian - little endian clusters can produce incorrect results #148773

Open
@yuzefovich

Description

@yuzefovich

DistSQL machinery relies on having the same hash computation across all nodes in the distributed plan. As it turns out (see #146108), there is a difference at least for the hash utilities used by the vectorized engine between big endian and little endian systems. As a result, a heterogenous cluster that has nodes running on both big endian and little endian systems can produce incorrect results for distributed plans. A possible workaround if someone really needs this setup would be to disable distsql via SET CLUSTER SETTING sql.defaults.distsql = off;.

Jira issue: CRDB-51797

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-s390xIssues involving the s390x architectureA-sql-executionRelating to SQL execution.C-cleanupTech debt, refactors, loose ends, etc. Solution not expected to significantly change behavior.T-sql-queriesSQL Queries Teamdocs-known-limitation

    Type

    No type

    Projects

    Status

    Cold Storage

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions