Page 1 of 1

An empty array is erroneously returned

Posted: Mon 04 May 2009 20:21
by baba
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

Posted: Tue 05 May 2009 13:29
by Shalex
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.

Posted: Fri 22 May 2009 15:28
by Shalex
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 .

Posted: Fri 22 May 2009 19:36
by LPCRoy
does this new build fix any of the bugs I posted?

Posted: Mon 25 May 2009 11:06
by Shalex
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.