Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 95CD8633A4B
	for <pgsql-committers-postgresql.org@mail.postgresql.org>;
	Sat, 13 Jun 2009 02:57:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 41278-03
	for <pgsql-committers-postgresql.org@mail.postgresql.org>;
	Sat, 13 Jun 2009 02:56:56 -0300 (ADT)
Received: from pgfoundry.org (pgfoundry.org [200.46.204.130])
	by mail.postgresql.org (Postfix) with ESMTP id 989E76338A6
	for <pgsql-committers@postgresql.org>;
	Sat, 13 Jun 2009 02:56:58 -0300 (ADT)
Received: from maia.hub.org (unknown [200.46.204.183])
	by pgfoundry.org (Postfix) with ESMTP id 12A0E1072163
	for <pgsql-committers@postgresql.org>;
	Sat, 13 Jun 2009 05:56:58 +0000 (UTC)
Received: from pgfoundry.org ([200.46.204.130])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024)
	with ESMTP id 55845-10 for <pgsql-committers@postgresql.org>;
	Sat, 13 Jun 2009 02:56:56 -0300 (ADT)
Received: by pgfoundry.org (Postfix, from userid 1181)
	id 61291107215F; Sat, 13 Jun 2009 05:56:56 +0000 (UTC)
MIME-Version: 1.0
To: pgsql-committers@postgresql.org
Subject: npgsql - Npgsql2: [#1010652] Command checker for output vars is using
X-Mailer: activitymail 1.26, http://search.cpan.org/dist/activitymail/
X-PgFoundry: npgsql -
Content-Type: text/plain; charset=utf-8
Message-Id: <20090613055656.61291107215F@pgfoundry.org>
Date: Sat, 13 Jun 2009 05:56:56 +0000 (UTC)
From: fxjr@pgfoundry.org (User Fxjr)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.629 tagged_above=0 required=5 tests=AWL=0.129,
	URI_NOVOWEL=0.5
X-Spam-Level: 
X-Archive-Number: 200906/204
X-Sequence-Number: 37408

Log Message:
-----------

[#1010652] Command checker for output vars is using not performing query.
Npgsql was adding a cast which was causing the query analyzer to use a full table scan instead of using the index. Now, Npgsql adds the proper cast. Thanks Adriaan van Kekem for analyzes and bug report.

Modified Files:
--------------
    Npgsql2/src/Npgsql:
        NpgsqlCommand.cs (r1.40 -> r1.41)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlCommand.cs?r1=1.40&r2=1.41)
    Npgsql2/src/NpgsqlTypes:
        NpgsqlDbType.cs (r1.13 -> r1.14)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/NpgsqlTypes/NpgsqlDbType.cs?r1=1.13&r2=1.14)
        NpgsqlTypesHelper.cs (r1.27 -> r1.28)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/NpgsqlTypes/NpgsqlTypesHelper.cs?r1=1.27&r2=1.28)