Parameterized commands with double infinite values fail #337
Description
Npgsql is sending "Infinity" or "-Infinity" to the server instead of 'Infinity' or '-Infinity' (double quotes instead of single quotes), which causes the server to return "ERROR: 42703: column "infinity" does not exist."
To reproduce:
using (var connection = new NpgsqlConnection("..."))
{
connection.Open();
using (var command = new NpgsqlCommand("CREATE TABLE test (value DOUBLE PRECISION NOT NULL)", connection))
{
command.ExecuteNonQuery();
}
using (var command = new NpgsqlCommand(@"INSERT INTO test (value) VALUES (@value)", connection))
{
command.Parameters.AddWithValue("value", double.PositiveInfinity);
command.ExecuteNonQuery();
}
}
Metadata
Metadata
Assignees
Labels
No labels