[DERBY-6035] Client and embedded drivers return different SQL state for unregistered parameter

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0, 10.6.1.0, 10.6.2.1, 10.7.1.1, 10.8.1.2, 10.8.2.2, 10.8.3.0, 10.9.1.0, 10.10.1.1
• Component/s: JDBC, SQL
• Labels: derby_triage10_11
• Urgency: Urgent
• Bug behavior facts: Embedded/Client difference
• Assignee: Unassigned
• Reporter: Dag H. Wanvik
• Created: 04/Jan/13 06:24
• Updated: 19/Jun/13 08:17

Description

Embedded returns 07004 (NEED_TO_REGISTER_PARAM), when the client uses 07000 (LANG_MISSING_PARMS), cf. this snippet from LangProcedureTest:

// Make sure we throw proper error with network server
// if params are not registered
assertCallError(
usingEmbedded() ? "07004" : "07000",
"call SQLC.SQLCONTROL3_0 (?, ?, ?, ?, ?, ?, ?)");