Re: The same prepared query yield "-1" the first six times and then "-1.0"

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: The same prepared query yield "-1" the first six times and then "-1.0"
Дата
Msg-id CADK3HHLMwhfTQYkMqmbtht1KL85KxOdGLUHnwUrdAC5wUP8BVw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: The same prepared query yield "-1" the first six times and then "-1.0"  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general



On Mon, 21 Aug 2023 at 12:46, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@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 

В списке pgsql-general по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: JDBC + PG-15 but not psql
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: The same prepared query yield "-1" the first six times and then "-1.0"