| From: | Dumitru Boldureanu <dboldureanu(at)inthergroup(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Bug fetching Timestamps in JDBC driver 9.4.1209 |
| Date: | 2016-08-10 15:46:29 |
| Message-ID: | 00112c49-5ab2-412d-ade5-8bf5c04df99c@inthergroup.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
We noticed, what seems to be a bug in JDBC driver 9.4.1209.
The bug was detected in an application that is testing database migration scripts. The application is comparing through JDBC the data before and after the execution of the migration scripts.
We noticed that for timestamp columns we were getting changes, which do not actually exist.
And these changes are not static, the records and tables in which we get them are random.
We’ve fought a lot with this issue, checked for unclosed connections, results sets, etc.
The solution was to replace the JDBC driver 9.4.1209 with 9.4-1201, and the random timestamps values disappeared.
Noticed in the release of 9.4.1209, mentioned: * Performance optimization for timestamps (~TimeZone.getDefault optimization)
Maybe it added a bug? Tried to google and found no one complaining on this issue.
Kind regards / Mit freundlichen Grüßen / Met vriendelijke groeten / Cu respect / 顺祝商祺,
Dumitru Boldureanu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Saxena, Shivam | 2016-08-11 09:30:06 | BUG: Session getting disconnected while executing a function to create materialised views in PostgreSQL 9.6 |
| Previous Message | Martín Marqués | 2016-08-10 14:01:53 | Re: pg_dump doesn't dump new objects created in schemas from extensions |