On Mon, 21 Aug 2023 at 12:46, Tom Lane <t...@sss.pgh.pa.us> wrote: > "David G. Johnston" <david.g.johns...@gmail.com> writes: > > Otherwise, I agree this seems like a bug, probably in the JDBC driver, > > though one pertains to style as opposed to semantics since both answers > are > > technically correct. > > I don't see any such behavior change in psql, so I agree that this is > probably something to ask about on the JDBC list. > > My first thought was that the output change occurs when the query > transitions from custom to generic plan. However, since there are > no parameters involved the backend would go for a generic plan > immediately. Having said that, I seem to recall that the JDBC driver > has its own notion of custom vs generic execution, so maybe the > issue is around there somewhere. > > regards, tom lane > > Tom,
It's because we also switch to binary at that point and don't parse text any more. I agree though it shouldn't happen. Dave