db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: (DERBY-822 followup) Server prefetch when QRYROWSET is 0 (zero)?
Date Fri, 30 Jun 2006 02:38:51 GMT
> Long story short someone who works with the client pointed out that the 
> client is sending a QRYROWSET of size "0" when it sends the OPNQRY 

Hi Army,

Page 698 of V.3 says:

   A QRYROWSET value of zero on the OPNQRY and EXCSQLSTT commands instructs
   the server to return no rows with the OPNQRYRM for the cursor or result
   set. A QRYROWSET value of zero on the CNTQRY command is invalid for
   non-rowset cursors and results in the application server generating a
   SYNTAXRM with a SYNERRCD value of '15'x (reserved value not allowed).

I'd say that our current behavior, as you describe it, seems wrong; we should
not be returning any rows when the client has set QRYROWSET to 0 on OPNQRY.

I think that we should modify the server code for 10.2 so that:

  - on OPNQRY and EXCSQLSTT, we only return rows if QRYROWSET is > 0.
  - on CNTQRY, we throw a syntax exception if QRYROWSET is 0

I'm quite interested to hear what others think about this.



View raw message