| Lists: | Postg토토 사이트 순위SQL : Postg토토 사이트 순위SQL 메일 링리스트 : 2015-11-12 12:19 이후 PGSQL-BUGS |
|---|
| From: | adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #13773: BigInt column right padding zero |
| Date: | 2015-11-12 12:19:07 |
| Message-ID: | 20151112121907.2644.59186@wrigleys.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토 사이트 순위SQL : Postg토토 사이트 순위SQL 메일 링리스트 : 2015-11-12 12:19 이후 PGSQL-BUGS |
The following bug has been logged on the website:
Bug reference: 13773
Logged by: Adolfo Cavalcante
Email address: adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br
PostgreSQL version: 9.4.5
Operating system: Linux Ubuntu
Description:
We have a Linux server running Postgresql 9.4 and a Java 6 client
application wich was using the JDBC driver postgresql-9.4-1204.jdbc4.jar.
After updating to postgresql-9.4-1205.jdbc4.jar driver, Bigint pk columns
are returning an extra zero at right. We insert 123 in the column, the
select returns 1230. It's important to say that this behavior is
intermittent. We saw at the version changelog that somethinq was changed in
the long->Bigint implementation, it may be a clue.
| From: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
|---|---|
| To: | adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #13773: BigInt column right padding zero |
| Date: | 2015-11-12 22:22:26 |
| Message-ID: | 56451122.7030809@archidevsys.co.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
On 13/11/15 01:19, adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br wrote:
> The following bug has been logged on the website:
>
> Bug reference: 13773
> Logged by: Adolfo Cavalcante
> Email address: adolfo-goncalves(dot)junior(at)serpro(dot)gov(dot)br
> PostgreSQL version: 9.4.5
> Operating system: Linux Ubuntu
> Description:
>
> We have a Linux server running Postgresql 9.4 and a Java 6 client
> application wich was using the JDBC driver postgresql-9.4-1204.jdbc4.jar.
> After updating to postgresql-9.4-1205.jdbc4.jar driver, Bigint pk columns
> are returning an extra zero at right. We insert 123 in the column, the
> select returns 1230. It's important to say that this behavior is
> intermittent. We saw at the version changelog that somethinq was changed in
> the long->Bigint implementation, it may be a clue.
>
>
Note that Java 6 is no longer publicly supported & Java 7 is approaching
EOL!!!
I suggest that you seriously consider upgrading to Java 8 for both
security & performance reasons - quite apart from all the shiny new
features.
Cheers,
Gavin