pkoppstein

**Describe the bug** OSS-FUZZ is unhappy with a filter that uses _nwise(0). Note that `_nwise(0)` typically behaves like `recurse([])`, and one could argue that the def of _nwise/1 is just...

### What happens? To reproduce: 1) Download and unzip the "well-known" SQLite database at https://www.kaggle.com/datasets/hugomathien/soccer 2) Assuming database.sqlite is in the pwd invoke duckdb and execute the program shown below....

Issues with list_reduce()

3

In a nutshell: 1) The documentation of list_reduce should clarify how the existing implementation initializes the accumulator. 2) DuckDB should be enhanced so that, in effect, it is possible to...

### What happens? One way to collect the column names of a table, t, into a list is: ```sql select array_agg(column_name) from (describe t); ``` But it is currently not...

Confusing error message when creating a MACRO to parameterize the argument of read_csv_auto()

4

### What happens? The SQL command: ``` CREATE MACRO read(fn) AS (SELECT * FROM read_csv_auto(fn)); ``` results in a Binder Error: ``` Table function "read_csv_auto" does not support lateral join...

try/catch work as expected with jq and jaq, but gojq has trouble with `"\u263"': ``` for jq in jq jaq gojq ; do echo jq=$jq (echo '"a\u263"'; echo '"def"' )...

documentation about recursive functions (CREATE FUNCTION)

2

### What happens? It seems that currently functions that are defined recursively will either not compile or will result in a **max expression depth limit** error, e.g. using the snippet...

bug affecting RECURSIVE CTE computation

7

### What happens? Appended is a "RECURSIVE CTE" table function which is intended to produce a Knuth shuffle of the input list; in the version shown here, it produces a...

'with recursive cte' within a function bleeds into subsequent 'with recursive cte'

5

### What happens? Perhaps this is a well-known issue, but in case not, contrast the result of these two queries: ```sql with recursive cte(i,s) as ( select 1 as i,...

### What happens? This might technically be an Enhancement Request, but since read_csv() understands '/dev/stdin' and read_text() appears not to, it certainly seems more like a bug. ``` $ echo...