 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
michalk
Joined: 29 Aug 2014 Posts: 211
|
|
[SA 9.0.166 Pro] - PostgreSql - negative integers turn zero |
|
Data grid of SQL Editor shows 0 (zero) instead of negative values for INTEGER column
Values for NUMERIC datatype are shown correctly.
Test Case:
 |
 |
CREATE TABLE michalk.testneg4
(
id integer
);
INSERT INTO michalk.testneg4 (id) VALUES (-4),(4);
SELECT * FROM michalk.testneg4;
-- result:
-- 0
-- 4
|
SA 9.0.166 Pro (and previous v9 one too)
Database: Postgresql 9.2
SQL Editor 64bit
Native connection
|
|
Thu Nov 03, 2016 11:36 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Thank you very much for reporting this issue. I was able to reproduce it using very simple
SELECT -1::INT
With ODBC and ADO.NET connections it seems to work correctly.
|
|
Thu Nov 03, 2016 1:43 pm |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
This bug has been logged with tracking number #SA0030056
|
|
Thu Nov 03, 2016 1:56 pm |
|
 |
michalk
Joined: 29 Aug 2014 Posts: 211
|
|
|
|
Is fix for this issue scheduled for roll-out in near future? If yes, when it could be expected? thx
|
|
Thu Nov 10, 2016 10:03 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
Hi. We expect a new public build released sometime next week, but the exact date isn't yet known. Please use the ODBC interface for the time being. It doesn't seem to have such issues with data type conversions.
|
|
Thu Nov 10, 2016 10:08 am |
|
 |
michalk
Joined: 29 Aug 2014 Posts: 211
|
|
|
|
Yes I know. We prefer native connection over odbc for obvious reasons.
We are 100% OK with next week expectation. We are looking forward to.
Thank you.
|
|
Thu Nov 10, 2016 10:19 am |
|
 |
michalk
Joined: 29 Aug 2014 Posts: 211
|
|
|
|
I can confirm, this issue has been fixed in build 9.0.185
thank you
|
|
Mon Nov 21, 2016 10:53 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|