orzom411

```sql -- Might this help? WITH movies as ( SELECT a.tconst, a.genres FROM (SELECT UNNEST( [ {tconst: 1, genres: ['drama', 'action']}, {tconst: 2, genres: ['drama', 'action','comedy']}, {tconst: 3, genres: ['drama',...

I started with the max(len...) then convinced myself that it would be row specific, e.g. an array could have duplicate values, didn't think that was your intent, hence the count...

I would differ from this request. The referential check is appropriate and in many ways I'd humbly rather see all references properly addressed, e.g. it would make maintaining the code...

> @orzom411 I appreciate your wisdom, but what exactly is being protected against when someone writes the following: > > ``` > SELECT id, name, score > FROM a, b...

Having a similar issue, details: `D pragma version;` library_version|source_id v0.10.0|20b1486d11 `D from duckdb_settings() where name like '%extensions%';` name|value|description|input_type allow_unsigned_extensions|false|Allow to load extensions with invalid or missing signatures|BOOLEAN autoinstall_known_extensions|false|Whether known extensions...

Fyi, the issue I'm seeing is Windows, both 10 and 11, CLI for version 0.10.0.

Good Morning Samansmink, Downloaded the zip: duckdb_cli-windows-amd64.zip Extracted and started: v0.10.0 20b1486d11 `select * from duckdb_extensions() as e where e.extension_name = 'aws';` ``` extension_name|loaded|installed|install_path|description|aliases aws|false|true|C:\Users\mo\.duckdb\extensions\v0.10.0\windows_amd64\aws.duckdb_extension|Provides features that depend on the...

Attempted to build 2.0.1.0 and this issue persists. 2>RC : fatal error RC1110: could not open src\interfaces\libpq\libpq.rc 2> 2>Done building project "libpq.vcxproj" -- FAILED. ========== Rebuild All: 1 succeeded, 1...