[DERBY-2516] Network Client allows execution of callable statement when one of the parameters is not set

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.3.1.4
• Fix Version/s: 10.10.1.1
• Component/s: Network Client
• Labels: derby_backport_reject_10_8 derby_triage10_8
• Urgency: Low
• Issue & fix info: Newcomer
• Bug behavior facts: Embedded/Client difference
• Assignee: Knut Anders Hatlen
• Reporter: Katherine Marsden
• Created: 02/Apr/07 23:46
• Updated: 03/Sep/14 08:31
• Resolved: 03/Jan/13 10:05

Description

If the second input parameter is set and the first is not. Client allows execution of the stored procedure. See the following code in LangProcedureTest.java with a reference to this bug.

op.clearParameters();
op.setString(2, "2");
try

{ // a not set op.execute(); fail("FAIL - a not set"); }

catch (SQLException sqle)

{ assertSQLState("07000", sqle); }

Issue Links

• is related to: DERBY-2461 Convert lang/procedure.java to junit
• relates to: DERBY-5945 Inappropriate error message when calling a procedure as a function (as if it had a return value)