List Support doens't work.

[klesh]

connection.Query<int>(
  "select * from (select 1 as Id union all select 2 union all select 3) as X where Id in @Ids", 
  new { Ids = new int[] { 1, 2, 3 } }
)

I ran this query and got an exception:

Npgsql.NpgsqlException: ERROR: 42883: operator does not exist: integer = integer[]

The SQL I got was:

select * from (select 1 as Id union all select 2 union all select 3) as X where Id in @Ids

Seems the LIST SUPPORT doens't work at all...

[NickCraver]

Which version of npgsql was this on? The step from v2 to v3 was major, so I'm wondering which you're hitting this on...or is it both?

[klesh]

It's been a while, I'm not sure about v2 v3 ? I think it was 1.42 on nuget.org that I downloaded.

[NickCraver]

I'll see what we can do to make this work reasonably in v3. My understanding is this never worked in v2 or v3, so there's no breaking concern here on the npgsql side.

[perennialinnocence]

This is caused by Issue #150