Thijs

Hi, thank you for raising the issue! I am however confused by the answers you filled out, as the DuckDB version says 0.4.0. Have you verified that this issue still...

I am looking at `Database collation not reloaded?` But I am having trouble reproducing the issue, AF is not a recognized collation name, so the first step already fails to...

`C-API IN query row index out chunk size` This is not actually a C-API specific issue, I can reproduce it with the unittester as well ```sql # name: test/fuzzer/pedro/force_no_cross_product.test #...

Thanks for the PR! First of all I really like the changes to the tests! However the hydrated exceptions make a couple of assumptions that might not hold true for...

> @Tishj what's your plan with regards to all the tests? Are you planning to merge without updating them all as I have done here? I was thinking of taking...

Hi there, Looks like this issue is caused by a bug in TransformPythonValue. (more specifically, types of Values currently aren't upgraded when appropriate so NULL stays NULL instead of turning...

Made the first step to optimize distinct aggregates further, attempting to prevent creating multiple hashtables for the same inputs. But it seems this requires more changes upstream as a query...

> @Tishj the distinct aggregates are maybe something for a separate PR or do you want to do this here still? Do you mean the optimization that essentially re-uses tables...

Issues I was facing are likely caused by missing support for the ALIAS `ExtraTypeInfo` introduced by PR #3668

The issue is highlighted by this test: ```sql statement ok CREATE TYPE alias AS VARCHAR; statement ok CREATE TABLE test AS select 'happy'::ALIAS; ``` When we force a cast, this...