Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 16586 invoked from network); 3 Feb 2006 23:08:31 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 3 Feb 2006 23:08:31 -0000 Received: (qmail 95027 invoked by uid 500); 3 Feb 2006 23:08:30 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 94795 invoked by uid 500); 3 Feb 2006 23:08:29 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 94786 invoked by uid 99); 3 Feb 2006 23:08:29 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Feb 2006 15:08:29 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: local policy) Received: from [192.18.98.34] (HELO brmea-mail-3.sun.com) (192.18.98.34) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Feb 2006 15:08:28 -0800 Received: from phys-mpk-1 ([129.146.11.81]) by brmea-mail-3.sun.com (8.12.10/8.12.9) with ESMTP id k13N88Qj026646 for ; Fri, 3 Feb 2006 16:08:08 -0700 (MST) Received: from conversion-daemon.mpk-mail1.sfbay.sun.com by mpk-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) id <0IU400901W2W2H@mpk-mail1.sfbay.sun.com> (original mail from David.Vancouvering@Sun.COM) for derby-dev@db.apache.org; Fri, 03 Feb 2006 15:08:08 -0800 (PST) Received: from [129.150.27.185] (vpn-129-150-27-185.SFBay.Sun.COM [129.150.27.185]) by mpk-mail1.sfbay.sun.com (iPlanet Messaging Server 5.2 HotFix 1.24 (built Dec 19 2003)) with ESMTP id <0IU400B0PW9F39@mpk-mail1.sfbay.sun.com> for derby-dev@db.apache.org; Fri, 03 Feb 2006 15:08:03 -0800 (PST) Date: Fri, 03 Feb 2006 15:08:02 -0800 From: "David W. Van Couvering" Subject: Re: Paging Lance: format of empty result set In-reply-to: <43E3E0AF.60404@sbcglobal.net> To: derby-dev@db.apache.org Message-id: <43E3E252.3070408@sun.com> MIME-version: 1.0 Content-type: multipart/mixed; boundary="Boundary_(ID_FfBqHUoQp61/yMxNlt5mpQ)" X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) References: <43E3D8F3.80203@sun.com> <43E3D9AA.4080301@apache.org> <43E3DE27.8060202@sun.com> <43E3E0AF.60404@sbcglobal.net> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N This is a multi-part message in MIME format. --Boundary_(ID_FfBqHUoQp61/yMxNlt5mpQ) Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7BIT OK, I will do my best to match *exactly* what is expected. I will look at some of the existing stuff to use as a pattern. However, I will have to leave it to you or whomever does the ODBC tests to make sure it works for ODBC. David Army wrote: > > David W. Van Couvering wrote: > >> OK, thanks. I hadn't considered the RS metadata. > > > Just a note that the result set metadata should match the defined > results _exactly_. Returning an int where a short is expected, or a > char where a varchar is expected, or a nullable column where a "not > null" column is expected, etc. etc. can cause existing applications a > lot of problems--see DERBY-107. Our JDBC tests might not catch it, but > my past experience is that ODBC applications (esp. Microsoft ones like > Access) will throw a fit if something is even slightly off... > > Army > --Boundary_(ID_FfBqHUoQp61/yMxNlt5mpQ) Content-type: text/x-vcard; charset=utf-8; name=david.vancouvering.vcf Content-transfer-encoding: 7BIT Content-disposition: attachment; filename=david.vancouvering.vcf begin:vcard fn:David W Van Couvering n:Van Couvering;David W org:Sun Microsystems, Inc.;Database Technology Group email;internet:david.vancouvering@sun.com title:Senior Staff Software Engineer tel;work:510-550-6819 tel;cell:510-684-7281 x-mozilla-html:TRUE version:2.1 end:vcard --Boundary_(ID_FfBqHUoQp61/yMxNlt5mpQ)--