[DERBY-211] Network Server returns no result sets for a procedure call that returns no result

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.1.1.0
• Component/s: Network Server
• Labels: derby_triage10_9
• Urgency: Normal
• Issue & fix info: Newcomer
• Bug behavior facts: Deviation from standard, Embedded/Client difference
• Assignee: Unassigned
• Reporter: Katherine Marsden
• Created: 11/Apr/05 10:19
• Updated: 02/May/13 02:29

Description

For a call of a procedure with no dynamic results embedded
Cloudscape returns a one result, an update count of zero. However, using the network server no results are returned. We should be consistent.

To reproduce
See call za() in lang/procedure.java test.

Issue Links

• blocks: DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.
• is depended upon by: DERBY-5091 Derby Test and Fix 2011 GSoC Project
• is duplicated by: DERBY-4362 Client returns -1 on Statement.getUpdateCount when a procedure is called, embedded returns 0.
• relates to: DERBY-1314 Differences between client and embedded when invoking stored procedures using Statement.executeUpdate()
• relates to: DERBY-449 importing data using SYSCS_UTIL.SYSCS_IMPORT_DATA generates wrong message