Soeren Wolfers

Result of sql(..).execute() still refers to local context variables.

2

### What happens? The relation returned by `duckdb.sql(..).execute()` still refers to local context variables, such that if it is used in a different context (e.g., after being returned by a...

First of all, great job with this! I wrote a feature request at the main duckdb repo asking almost for exactly what I just now found out you've already done...

aggregate(df).* is a syntax error but should be unnest(aggregate(df))

2

### What happens? From my understanding of https://duckdb.org/docs/sql/expressions/star.html#struct, I should be able to apply `struct.*` anywhere, including on the result of an aggregate. ### To Reproduce ```sql FROM ( SELECT...

Setting to get error on scalar subquery with more than one row

3

### What happens? I occasionally get tripped up writing scalar subqueries that I believe return a single row but since I messed up return multiple rows. Duckdb will then just...

Memory usage increases 100x when using row instead of column majorness in input

5

### What happens? Whether I feed ```python b1 = pd.DataFrame(b_array).stack().reset_index() ``` or ```python b2 = pd.DataFrame(b_array.T).stack().reset_index().iloc[:, [1, 0, 2]] ``` into `duckdb` makes no semantic difference (the two dataframes have...

Search function is broken and has questionable defaults

4

## Description [badv2.webm](https://github.com/user-attachments/assets/0c8f073c-1af4-43d4-a5f9-6ae4805ea937) The search function that's included in the JupyterLab based Jupyter notebooks (likely also the search function of JupyterLab itself, I never use that) via Ctrl-F is close...

No syntax highlighting in Chrome

5

## Description No syntax highlighting in Chrome.  (the covered pip freeze outputs in the screenshot are included below in raw text form) ## Reproduce Create notebook. Write Python. ##...

Superfluous empty space at the bottom of notebook

5

## Description Way too much empty space at the bottom of notebooks in Jupyter Notebook 7. ## Reproduce 1: Create new notebook 2: Create empty cells to fill the screen...

Long triple quoted strings oscillate in color for each new character added

2

## Description Display oscillates for long triple quoted strings. ## Reproduce 1: Create new notebook. 2: Paste the following into the first input cell: ```python """ aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...

`IN ARRAY` edge case

1

### What happens? ```sql select array(select 2 union select null) ``` returns `[2, null]` and ```sql select 1 in [2, null] ``` returns `false`, yet ```sql select 1 in array(select...