SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.0.166 Pro] - PostgreSql - negative integers turn zero

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.0.166 Pro] - PostgreSql - negative integers turn zero
Author Message
michalk



Joined: 29 Aug 2014
Posts: 142

Post [SA 9.0.166 Pro] - PostgreSql - negative integers turn zero Reply with quote
Data grid of SQL Editor shows 0 (zero) instead of negative values for INTEGER column
Values for NUMERIC datatype are shown correctly.

Test Case:
Code:

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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
This bug has been logged with tracking number #SA0030056
Thu Nov 03, 2016 1:56 pm View user's profile Send private message
michalk



Joined: 29 Aug 2014
Posts: 142

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
michalk



Joined: 29 Aug 2014
Posts: 142

Post Reply with quote
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 View user's profile Send private message
michalk



Joined: 29 Aug 2014
Posts: 142

Post Reply with quote
I can confirm, this issue has been fixed in build 9.0.185
thank you
Mon Nov 21, 2016 10:53 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.