npgsql - Npgsql2: [#1010780] Reduce use of utility queries for function

From: fxjr(at)pgfoundry(dot)org (User Fxjr)
To: pgsql-committers(at)postgresql(dot)org
Subject: npgsql - Npgsql2: [#1010780] Reduce use of utility queries for function
Date: 2010-03-22 02:43:20
Message-ID: 20100322024320.8321C10715C9@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

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

[#1010780] Reduce use of utility queries for function calls (CommandType.StoredProcedure). Thanks Noah Misch for tests. Patch (2 of 2):

2010-03-18 Noah Misch <noah.misch @nospam@ channeladvisor.com>

* src/Npgsql/NpgsqlCommand.cs (GetClearCommandText): Do not call
`CheckFunctionHasOutParameters'.
(CheckFunctionNeedsColumnDefinitionList): Check return type and presence
of OUT, INOUT, and TABLE arguments.
(CheckFunctionHasOutParameters): Delete method.
* testsuite/noninteractive/NUnit20/CommandTests.cs
(StatementOutputParameters): Test a multi-row result set.
(ReturnSetofRecord): New method.

[#1010779] Respect CommandTimeout in first function call w/ string parameter. Added test cases. Thanks Noah Misch for tests.

Modified Files:
--------------
Npgsql2/src/Npgsql:
NpgsqlCommand.cs (r1.50 -> r1.51)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/src/Npgsql/NpgsqlCommand.cs?r1=1.50&r2=1.51)
Npgsql2/testsuite/noninteractive/NUnit20:
CommandTests.cs (r1.38 -> r1.39)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/testsuite/noninteractive/NUnit20/CommandTests.cs?r1=1.38&r2=1.39)
Npgsql2/testsuite/noninteractive:
add_functions.sql (r1.5 -> r1.6)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/npgsql/Npgsql2/testsuite/noninteractive/add_functions.sql?r1=1.5&r2=1.6)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Meskes 2010-03-22 07:41:21 pgsql: Fixed ECPG regression test to make sure it uses absolute paths
Previous Message User Fxjr 2010-03-22 02:23:49 npgsql - Npgsql2: [#1010780] Reduce use of utility queries for function