Interesting, Postgres does this correctly: https://dbfiddle.uk/?rdbms=postgres_12&fiddle=dc4ce40bd526955b38db4bc96cb781c2 https://dbfiddle.uk/?rdbms=postgres_1

Interesting, Postgres does this correctly: https://dbfiddle.uk/?rdbms=postgres_12&fiddle=dc4ce40bd526955b38db4bc96cb781c2 https://dbfiddle.uk/?rdbms=postgres_12&fiddle=dc4ce40bd52695...