Problem with UnpreparedExecute and Decimal value
Posted: 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?
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?