Bug "UNION types \"char\" and text cannot be matched" with v9.0.1.+++ versions,

[yevon]

Environment

• PostgREST docker image version: v9.0.1.20220802 or v9.0.1.20220714

Description of issue

I was trying versions above v9.0.1, from v9.0.1.20220714, but when I change the docker image I just receive errors in the docker logs. Any idea what could it be? If I just go back to the stable v9.0.1 it works ok. I tried a schema reload without success.

[wolfgangwalther]

Which PostgreSQL version are you using?

Can you try to put together a reproducible example? There's probably something in your schema that triggers this.

[wolfgangwalther]

You could also have a look at the PostgreSQL logs - the statement that failed should be logged there, could you show us that, too?

[yevon]

I'm using the postgres 15 beta 2. I think that I found the query that fails, if I try to manually execute it it fails:

Found here:

https://github.com/PostgREST/postgrest/blob/bac63f339daa4a9292870b0674b41cde2bcfee74/src/PostgREST/DbStructure.hs#L655-L809

I'm trying to figure out why:

[yevon]

The issue is here, but I don't quite understand why it fails, it is mixing char and text:

[yevon]

Possible fix is to add a cast to the first union:

[yevon]

Seems to be just that, contype is type "char" and concat returns type "text", so the union fails:

[yevon]

Clossing this as this was corrected in v10.0.0! Thanks.