Skip to content

sum(all null) is 0 in vortex-duckdb #9084

New issue
New issue
Closed
#9113
Closed
sum(all null) is 0 in vortex-duckdb#9084
#9113
Assignees
mhk197
Labels
ext/duckdbRelates to the DuckDB integration

Description

@myrrc
myrrc
opened on Jul 30, 2026

vortex-duckdb uses own accumulator for sum since #8645.
sum(all null) is 0 in vortex, and that's intended behaviour.

However, there's #8705 which adds the aggregate with behavior we want

Activity

  1. myrrc
    assigned
    mhk197
    on Jul 30, 2026
  2. myrrc
    added
    ext/duckdbRelates to the DuckDB integration
    on Jul 30, 2026
  3. myrrc
    added a parent issue on Jul 30, 2026
  4. myrrc
    linked a pull request that will close this issueAdd `StandardSum`: a sum aggregate where zero valid values yields null #8705on Jul 30, 2026
  5. mhk197
    closed this as completedin #9113on Aug 7, 2026
  6. mhk197
    added a commit that references this issue on Aug 7, 2026

    SQL style null-on-empty semantics for Sum and Mean (#9113)

    329bba2
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

ext/duckdbRelates to the DuckDB integration

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions