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

Hello, I am using postgresql version: 15.3 (Debian 15.3-0+deb12u1) org.postgresql.postgresql JDBC driver version: 42.6.0 via Java 17.0.7 I discovered an unattended (for me) situation: when I execute 10 times the same prepared query the result is not always the same. I wrote a little test case to

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

> Il giorno 21 ago 2023, alle ore 17:45, Adrian Klaver > ha scritto: > > On 8/21/23 08:27, Edoardo Panfili wrote: >> Hello, >> I am using >> postgresql version: 15.3 (Debian 15.3-0+deb12u1) >> org.postgresql.postgresql JDBC driver version: 42.6.0 &

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

> Il giorno 21 ago 2023, alle ore 17:50, David G. Johnston > ha scritto: > > > On Mon, Aug 21, 2023 at 8:28 AM Edoardo Panfili > mailto:edoardo.panf...@iisgubbio.edu.it>> > wrote: >> >>dim1 real DEFAULT '-1' NOT NULL >>

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

> Il giorno 21 ago 2023, alle ore 18:45, Tom Lane ha > scritto: > > "David G. Johnston" 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 an

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

> Il giorno 21 ago 2023, alle ore 20:13, Peter J. Holzer ha > scritto: > > On 2023-08-21 17:27:20 +0200, Edoardo Panfili wrote: >> The attended result was a sequence of ten equal values but this is the >> actual result: >> p: -1 >> p: -1 >> p: -1 &g

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

> Il giorno 21 ago 2023, alle ore 21:37, Dave Cramer > ha scritto: > > > > On Mon, 21 Aug 2023 at 14:42, Edoardo Panfili <mailto:edoard...@gmail.com>> wrote: >> >> >> > Il giorno 21 ago 2023, alle ore 20:13, Peter J. Holzer > > <ma