public void PqsqlDataReaderTest9()
{
mCmd.CommandText = @"select 1234567890123456789::int8, 0::oid, '00000000-0000-0000-0000-000000000000'::uuid, 47.11::float4, E'\\000\\001\\002\\003'::bytea, null as ""lastcol""";
using (PqsqlDataReader reader = mCmd.ExecuteReader())
{
Assert.IsTrue(reader.HasRows);
reader.Read();
long c0 = reader.GetInt64(0);
uint c1 = reader.GetOid(1);
Guid c2 = reader.GetGuid(2);
float c3 = reader.GetFloat(3);
long len = reader.GetBytes(4, 0, null, 0, 0);
Assert.AreEqual((long)4, len);
byte[] c4 = new byte[len];
long read = reader.GetBytes(4, 0, c4, 0, (int)len);
Assert.AreEqual(read, len);
Assert.AreEqual(1234567890123456789, c0);
Assert.AreEqual((uint)0, c1);
Assert.AreEqual(Guid.Empty, c2);
Assert.AreEqual((float)47.11, c3);
byte[] buf = { 0, 1, 2, 3 };
Assert.AreEqual(buf[0], c4[0]);
Assert.AreEqual(buf[1], c4[1]);
Assert.AreEqual(buf[2], c4[2]);
Assert.AreEqual(buf[3], c4[3]);
object last = reader[5];
Assert.AreEqual(DBNull.Value, last);
last = reader["lastcol"];
Assert.AreEqual(DBNull.Value, last);
reader.Close();
}
}
