An empty array is erroneously returned

An empty array is erroneously returned

Postby baba » Mon 04 May 2009 20:21

Hello,

I have a table including :

"picts" BIGINT[] NOT NULL
another
"cc" TEXT[] NOT NULL

When there is no value, psql returns '{}'
For the picts, i get : "4919424291818982469"


The appli works for monthes without any problem.

Since i upgraded from 3.xx to 4.50, i get the problem.

To reproduce : create a table with array[] of bigint and TEXT
Put {} (no values). Fill a table : with Text you get out of bound in UTF8 conversion, with bigint[] the huge value "4919424291818982469".

Can you check this ?

I have to deliver, and i am locked.

BTW, i expected the new type PGSQLArray to simplify all of this...

BTW2 : The documentation give no clue about large_objects. I spent a day to find it by myself.

BAD !!

seb
baba
 
Posts: 22
Joined: Thu 14 Apr 2005 16:40

Postby Shalex » Tue 05 May 2009 13:29

We have reproduced the "Index was outside the bounds of the array" error. It is fixed now. Look forward to the next build of dotConnect for PostgreSQL. I will post here when it is available. We are working on the PgSqlLargeObject documentation.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby Shalex » Fri 22 May 2009 15:28

The new build of dotConnect for PostgreSQL 4.50.33 is available for download now.
It can be downloaded from http://www.devart.com/dotconnect/postgr ... nload.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=14911 .
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44

Postby LPCRoy » Fri 22 May 2009 19:36

does this new build fix any of the bugs I posted?
LPCRoy
 
Posts: 7
Joined: Mon 18 May 2009 20:45

Postby Shalex » Mon 25 May 2009 11:06

LPCRoy, the new build doesn't include the fixes of the bugs you have posted. We will notify you about the progress in your threads at our forum.
Shalex
Devart Team
 
Posts: 7654
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for PostgreSQL