duckdb / duckdb/duckdb-java

MAX() inside PIVOT yielding crazy results for value from window function

Open
#128 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
C++
Stars
127
Forks
80
Avg merge
13h 49m
Merged PRs (30d)
48

Description

After switching from jar 1.0.0 to jar 1.1.3 I get wild values for a function that worked before, where I PIVOT using MAX() on the value from a window function:

Image

Before the switch I saw correct values. When I use max(arg, n), I see the correct values again (but as a list):

Image

first() also yields these crazy values. sum() works.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.