Soeren Wolfers

Wrong results when applying group_by().agg() to guvectorized function

7

### Checks - [X] I have checked that this issue has not already been reported. - [X] I have confirmed this bug exists on the [latest version](https://pypi.org/project/polars/) of Polars. ###...

Hide browser when displaying a notebook via Voila

1

Is it possible to deploy a notebook with Voila while hiding the fact that the "application" is just a website opened in Chrome (let's say), i.e. opening the application in...

Below, I'm making suggestions (A)-(E) how I think cell magic could be made even better. If people generally think these are good ideas, I'd try and make a PR. First,...

Jupyter notebook jumps to top of cell on Ctrl-Enter

4

## Description When I hit Ctrl-Enter while in line number >40 of a cell with 50 lines and I'm scrolled towards the bottom of the cell such that lines 1-40...

Internal exception after referencing unnested column

1

### What happens? Referencing the name of a `unnest` column breaks the duckdb connection and requires a restart. ### To Reproduce ```sql SELECT unnest([]) AS unnested, sum(unnested) OVER (); ```...

ORDER BY picks wrong column of deduplication

2

### What happens? ORDER BY doesn't work right with deduplication. Ideally, I'd want duckdb to throw if I accidentally use the same column identifier twice rather than silently continuing (...

### What happens? duckdb says `'09:00:00+00:00'::TIMETZ < '09:01:00+01:00'::TIMETZ`. (Side problem: duckdb displays TIMETZ different than TIMESTAMPTZ: It doesn't consistently display TIMETZ using the settings-time-zone, but sometimes uses `+00:00` offset) ###...

Out of memory on exploding join

5

### What happens? Depending on the size of the involved dataframes, duckdb will either use absolutely no memory or suddenly run entirely out of memory when I increase the size...

Executed query is being run again

4

### What happens? In pseudocode, ```python a = duckdb.query("SELECT MYFIRSTQUERY").execute() b = duckdb.query("SELECT sum(a)").execute() ``` executes `MYFIRSTQUERY` twice. I would have thought that `.query().execute()` (unlike just `.query()`) behaves the same...

Not working on Android phone

1

### What happens? shell.duckdb.org shows a black screen on my Pixel 6a phone, and keyboard input doesn't do anything.   ### To Reproduce Visit shell.duckdb.org ### Browser/Environment: Chrome 124.0.6367...