MAX() inside PIVOT yielding crazy results for value from window function
Maintainers usually reply within 1 day
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
Research direction
Reproduce the reported PIVOT query using MAX() on a window-function value with jar 1.0.0 and 1.1.3, then compare the results with max(arg, n), first(), and sum(). The issue does not name a source file or test, so first identify the JDBC or SQL execution path that handles these aggregate results and add a regression test once the failure is isolated.
Written by the indexing model from the issue text.
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:
Before the switch I saw correct values. When I use max(arg, n), I see the correct values again (but as a list):
first() also yields these crazy values. sum() works.
- Dominant language
- C++
- Stars
- 127
- Forks
- 81
- Avg merge
- 7h 57m
- Merged PRs (30d)
- 38
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from duckdb/duckdb-java
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
duckdb/duckdb-java#832 · 2 comments ·
Maintainers usually reply within 1 day
-
Native SIGSEGV in DuckDB JDBC when repeatedly executing queries with window functions and LIMIT 0Open
Difficulty 4/5 3-5 days Newbie friendliness 48/100
duckdb/duckdb-java#871 · 4 comments ·
Maintainers usually reply within 1 day
-
Difficulty 4/5 3-5 days Newbie friendliness 45/100
duckdb/duckdb-java#872 ·
Maintainers usually reply within 1 day
-
Difficulty 5/5 Over a week Newbie friendliness 35/100
duckdb/duckdb-java#837 ·
Maintainers usually reply within 1 day
-
executeBatch()` on a prepared INSERT runs s are ~1–2 orders of magnitude slower than the AppenderOpen
Difficulty 5/5 Over a week Newbie friendliness 42/100
duckdb/duckdb-java#815 · 1 comment ·
Maintainers usually reply within 1 day
All issues in duckdb/duckdb-java
Similar issues
-
Difficulty 1/5 Under an hour Newbie friendliness 78/100
espressif/esp-matter#1874 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
opencv/opencv_contrib#4231 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
MiSTer-devel/Main_MiSTer#1341 ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
linux-test-project/lcov#552 ·
Maintainers usually reply within 1 day
-
Difficulty 1/5 1-3 hours Newbie friendliness 94/100
Maintainers usually reply within 1 day