Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type - Mailing list pgsql-bugs

From Dave Cramer
Subject Re: BUG #17911: Database or JDBC Driver Provides Incorrect Type
Date
Msg-id CADK3HHLrcck+oa_-axwR6GY5pLy9bTZku-mzrEdP3SvJMg-O6g@mail.gmail.com
Whole thread Raw
In response to BUG #17911: Database or JDBC Driver Provides Incorrect Type  (PG Bug reporting form <noreply@postgresql.org>)
Responses RE: BUG #17911: Database or JDBC Driver Provides Incorrect Type  (<PostgreSQL@Bergeon.org>)
List pgsql-bugs
Hi,

Can you provide more detail please? Possibly are reproducer?
Dave Cramer
www.postgres.rocks


On Thu, 27 Apr 2023 at 14:27, PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      17911
Logged by:          Stephen Bergeon
Email address:      postgresql@bergeon.org
PostgreSQL version: 15.2
Operating system:   Windows 10
Description:       

When the JDBC driver returns a ResultSet, both from obtaining table column
info, as well as from an actual query, the DATA_TYPE returned is incorrect
for Time-with-Time-Zone and Timestamp-With-Time-Zone columns. In both cases
the returned value returned indicates that the non-time-zone value is
returned.

    This has been tested on multiple versions of PostgreSQL and its JDBC
driver through the latest release [database version 15.2 and JDBC driver
42.6.0].

pgsql-bugs by date:

Previous
From: Sergiu Ignat
Date:
Subject: XML element with special characters can be created, serialized, but not deserialized
Next
From: PG Bug reporting form
Date:
Subject: BUG #17935: Incorrect memory access in fuzzystrmatch/difference()