Skip to content

SUM(bigint) produces strange results on M1 mac in Docker #99

@bcipriano

Description

@bcipriano

AcademySoftwareFoundation/OpenCue#1199 has a full description of the issue.

Over on the OpenCue project we use embedded-postgres for unit tests.

Basically we are seeing strange results from SUM(bigint) on arm64+Docker where the result is wildly incorrect.

  • Issue does not occur on other architectures.
  • Issue does not occur when running directly on M1 -- only in Docker.
  • I've tried a few different base images (gradle, almalinux) and that doesn't seem to change the result.
  • I've tried a few different Postgres versions -- 11, 12, 14, 15 -- same issue on all of them.
  • I haven't been able to reproduce the issue using the standard postgres Docker image.
  • Changing our queries to SUM(CAST(bigint as numeric)) fixes the issue.

Our build.gradle.

Any ideas here?

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions