Repository navigation
Unable to run con.sql on previously valid expression #63
Description
What happens?
A window function call inside of a scalar call fails in duckdb 1.4.0, and it used to work previously.
To Reproduce
>>> import duckdb
>>> duckdb.sql('select nullif(sum(1) over (rows between unbounded preceding and unbounded following), 1)')
Results in
Traceback (most recent call last):
File "<python-input-1>", line 1, in <module>
duckdb.sql('select nullif(sum(1) over (rows between unbounded preceding and unbounded following), 1)')
~~~~~~~~~~^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
_duckdb.NotImplementedException: Not implemented Error: Unimplemented expression class
OS:
linux x86_64
DuckDB Package Version:
1.4.0
Python Version:
3.13.7
Full Name:
Charles Cloud
Affiliation:
Self
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a stable release
Did you include all relevant data sets for reproducing the issue?
Not applicable - the reproduction does not require a data set
Did you include all code required to reproduce the issue?
- Yes, I have
Did you include all relevant configuration to reproduce the issue?
- Yes, I have
Activity
Tishj commentedon Sep 17, 2025
Euhm, for a change of pace, I think this should go to core 😅
I don't think this is anything that Python is doing here
Tishj commentedon Sep 17, 2025
@szarnyasg can you move this to
duckdb/duckdb?evertlammerts commentedon Sep 17, 2025
Same conclusion:
vs
NickCrews commentedon Oct 16, 2025
This is no longer present on 1.4.1 (as just tested on https://shell.duckdb.org/)