An empty array is erroneously returned

baba · Post by **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

Shalex · Post by **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 · Post by **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 .

LPCRoy · Post by **LPCRoy** » Fri 22 May 2009 19:36

does this new build fix any of the bugs I posted?

Shalex · Post by **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.