Problem with UnpreparedExecute and Decimal value

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Yavanosta
Posts: 2
Joined: Tue 15 May 2012 16:23

Problem with UnpreparedExecute and Decimal value

Post by Yavanosta » Tue 15 May 2012 16:29

Hi all, there is problem with dotconnect for postgresql

Product: dotConnect for PostgreSQL
Product Version: 5.80 Express
OS Version: Windows 7
Platform: x64

I have a table with numeric(32) column. This column contains value "79228162514264337593543950334". Then i execute next code:
using (var connection = new PgSqlConnection(connectionString))
{
connection.Open();
var c = connection.CreateCommand();
c.UnpreparedExecute = true;
c.CommandText = @"SELECT propdecimal FROM test;";


using (IDataReader dr = c.ExecuteReader())
{
dr.Read();
var value = dr.GetDecimal(0);
}
}

And value variable contains "1918751186264337593543950334". If i execute this query without c.UnpreparedExecute = true; then everything goes fine.

Server version: "PostgreSQL 9.1.3, compiled by Visual C++ build 1500, 64-bit"

Is it bug?

Yavanosta
Posts: 2
Joined: Tue 15 May 2012 16:23

Re: Problem with UnpreparedExecute and Decimal value

Post by Yavanosta » Wed 16 May 2012 11:44

I've get response from support. This bug is fixed and will be available for download soon.

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Problem with UnpreparedExecute and Decimal value

Post by Pinturiccio » Wed 23 May 2012 14:28

The new build of dotConnect for PostgreSQL 6.0 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://forums.devart.com/viewtopic.php?t=24182

Post Reply