FYIReporting RDLDesigner executes select commands containing limit clauses
using ExecuteReader(CommandBehavior.SchemaOnly)
This causes npgsql ExecuteReader to add LIMIT 0 clause to statement sent to
PostgreSQL.
npgsql generates invalid SELECT statement.
Any idea how to fix this ?
Andrus.
Code to reproduce:
using System.Data;
using Npgsql;
class Program {
static void Main() {
Npgsql.NpgsqlConnection conn = new NpgsqlConnection(
"ENCODING=UNICODE;SERVER=localhost;DATABASE=postgres;" +
"USER ID=postgres");
conn.Open();
IDbCommand cmd = new Npgsql.NpgsqlCommand(
"select * from pg_tables limit 1", conn);
cmd.ExecuteReader(CommandBehavior.SchemaOnly);
}
}
Observed:
Message="ERROR: 42601: syntax error at or near \"limit\""
ErrorSql="select * from pg_tables limit 1 limit 0;"
_______________________________________________
Mono-list maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-list
