query output data not properly displayed or valorized

[Marco Delgrosso]

Hello Thomas, all,

I have spotted this potential issue in the visualization of the output data.

I run the query (valid_until_Build127_java11.0.12_64bit) in the SQLWB 2020-08-22 (Build 127) Java version 11.0.12 (64bit) the field "valuntil" it is not valorized with a timestamp.

Strange enough that because if I run the same query (valid_until_Build125_java1.8.0311_32bit) on the SQLWB 2019-05-08 (Build 125) Java Version 1.8.0_311 (32bit) the field "valuntil" it is correctly filled with the expected timestamp.

I double-checked the two SQLWB settings several times but they are identical.

What could be causing this difference?

Any suggestions for solving this issue are more than welcome.

Thank you in advance.

Marco

[Thomas Kellerer]

Which database and JDBC driver are you using?

With Java 11 I am using different JDBC calls to retrieve timestamp values.

Please send me the (full) logfile - most likely there are some hints in it

Regards
Thomas

Marco Delgrosso schrieb am 13.04.2022 um 13:30:
> Hello Thomas, all,
>
> I have spotted this potential issue in the visualization of the output data.
>

> I run the query (valid_until_Build127_java11.0.12_64bit <https://drive.google.com/file/d/1Vh35gaiR2bkVSy4F6uYnp8t-OCdjTiCD/view?usp=sharing>) in the SQLWB 2020-08-22 (Build 127) Java version 11.0.12 (64bit) the field "valuntil" it is *not* valorized with a timestamp.
>
> Strange enough that because if I run the same query (valid_until_Build125_java1.8.0311_32bit <https://drive.google.com/file/d/181STwvOJeYW3Q0PndqeasudgCHoln9t7/view?usp=sharing>) on the SQLWB 2019-05-08 (Build 125) Java Version 1.8.0_311 (32bit) the field "valuntil" it is *correctly* filled with the expected timestamp.

[Marco Delgrosso]

Hello Thomas,

I'am using Amazon Redshift database and currently I'am using this JDBC driver redshift-jdbc42-2.1.0.1.jar

Here you can find the full log file (sanitazed from personal data). Hope this it's enough, if not, let me know what are you need.

Let me know your findings

Regards,

Marco

[Thomas Kellerer]

Hmm, I somehow suspected some error coming from the Redshift driver.

What data type is that column exactly?
The only thing that changed between those releases was the handling of "timestamp with time zone" or "time with time zone" columns

Thomas

Marco Delgrosso schrieb am 13.04.2022 um 17:48:
> Hello Thomas,
>
> I'am using Amazon Redshift database and currently I'am using this JDBC driver redshift-jdbc42-2.1.0.1.jar
>

> Here <https://drive.google.com/file/d/1s_1-plyBKR9valwV4gUL-G4BY1aK6Ma6/view?usp=sharing> you can find the full log file (sanitazed from personal data). Hope this it's enough, if not, let me know what are you need.

> --
> You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbenc...@googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/c6997a4f-8d82-47cc-906c-47a160bc850bn%40googlegroups.com <https://groups.google.com/d/msgid/sql-workbench/c6997a4f-8d82-47cc-906c-47a160bc850bn%40googlegroups.com?utm_medium=email&utm_source=footer>.

[Marco Delgrosso]

the datatype for the column valuntil is “abstime”. 

https://www.postgresql.org/docs/9.3/view-pg-user.html

Thank you.

Marco

Sent from my iPhone

On 13 Apr 2022, at 18:18, Thomas Kellerer <google...@sql-workbench.net> wrote:

Hmm, I somehow suspected some error coming from the Redshift driver.

To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/6112b162-3ce4-65c5-e5e3-0945bb248013%40sql-workbench.net.

[Thomas Kellerer]

I can't test this with Redshift, but the Postgres driver returns the value correctly:

So I guess it's (again) something strange with the Redshift driver.

I am sorry, but there is not much I can do about. You might want to ask Amazon support regarding that.

Regards
Thomas

To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/E93B555A-D225-4F80-BD36-EB5A057F0B3B%40gmail.com.

[Marco Delgrosso]

Hello Thomas,

You were right. 

I have downloaded the latest available redshift JDBC driver (redshift-jdbc42-2.1.0.5) and now it works fine. So with the driver redshift-jdbc42-2.1.0.1.jar it doesn’t works. 

Thank you.

Marco

On 13 Apr 2022, at 19:24, Thomas Kellerer <google...@sql-workbench.net> wrote:



To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/687ae81e-66dd-0b6f-ad9c-df9ce10c0822%40sql-workbench.net.