Return-Path: 
 <derby-dev-return-20047-apmail-db-derby-dev-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-derby-dev-archive@www.apache.org
Received: (qmail 24687 invoked from network); 5 May 2006 01:55:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 5 May 2006 01:55:52 -0000
Received: (qmail 22289 invoked by uid 500); 5 May 2006 01:55:51 -0000
Delivered-To: apmail-db-derby-dev-archive@db.apache.org
Received: (qmail 22262 invoked by uid 500); 5 May 2006 01:55:51 -0000
Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:derby-dev-help@db.apache.org>
List-Unsubscribe: <mailto:derby-dev-unsubscribe@db.apache.org>
List-Post: <mailto:derby-dev@db.apache.org>
List-Id: <derby-dev.db.apache.org>
Reply-To: <derby-dev@db.apache.org>
Delivered-To: mailing list derby-dev@db.apache.org
Received: (qmail 22253 invoked by uid 99); 5 May 2006 01:55:51 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 May 2006 18:55:51 -0700
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of m.v.lunteren@gmail.com
 designates 64.233.166.181 as permitted sender)
Received: from [64.233.166.181] (HELO py-out-1112.google.com) (64.233.166.181)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 May 2006 18:55:50 -0700
Received: by py-out-1112.google.com with SMTP id e30so675331pya
        for <derby-dev@db.apache.org>; Thu, 04 May 2006 18:55:30 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=i8OH0TotONnnqEiorI6a8GveyJwYdpRCWLgjcFOcGssWM0c448lpdbZZmjspC58oycAz6rg/X8WtpYcJsh0oiDMmF3ltDWCtqgELvh9RdTRHgfrqKZA7KUQAvoWwo55myup9RXdIOCc3CxVjQl3Lwt1+3T4HYYJk2mrBuuKUhnQ=
Received: by 10.35.18.4 with SMTP id v4mr16007pyi;
        Thu, 04 May 2006 18:55:29 -0700 (PDT)
Received: by 10.35.101.13 with HTTP; Thu, 4 May 2006 18:55:29 -0700 (PDT)
Message-ID: <c25576af0605041855n43d33d60yaf19090d54076bc8@mail.gmail.com>
Date: Thu, 4 May 2006 18:55:29 -0700
From: "Myrna van Lunteren" <m.v.lunteren@gmail.com>
To: derby-dev@db.apache.org
Subject: Re: [jira] Commented: (DERBY-7) Bug in NULLIF Function
In-Reply-To: <20060504203248.GC19866@localhost.localdomain>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_65604_33262617.1146794129917"
References: <979740866.1096332272139.JavaMail.apache@nagoya>
	 <17536823.1146764847834.JavaMail.jira@brutus>
	 <20060504203248.GC19866@localhost.localdomain>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_65604_33262617.1146794129917
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 5/4/06, Bernt M. Johnsen <Bernt.Johnsen@sun.com> wrote:

> The net result from the two mentioned commits is as far a I can see
> the diff below. Myrna: can you confirm?
>
> Index:
> java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultse=
t.java
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
> ---
> java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultse=
t.java
> (revision 399685)
> +++
> java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/resultse=
t.java
> (working copy)
> @@ -798,12 +798,9 @@
>                                try{
>                                row.append(s.getString(i));
>                                } catch(SQLException ex){
> -                                       if (ex.getSQLState().equals("2200=
5"))
> {
> -                                               if (s.getBytes(i) !=3D nu=
ll)
> -                row.append(new String(s.getBytes(i)));
> -                                               else
> -                row.append(s.getBytes(i));
> -                                       } else throw ex;
> +                                       if (ex.getSQLState
> ().equals("22005"))
> +                                               row.append("Invalid
> Conversion Error\n");
> +                                       else throw ex;
>                                }
>                        }
>                        row.append("}\n");


Hi Berndt,

I think that's it.

Myrna

------=_Part_65604_33262617.1146794129917
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div><span class=3D"gmail_quote">On 5/4/06, <b class=3D"gmail_sendername">B=
ernt M. Johnsen</b> &lt;<a href=3D"mailto:Bernt.Johnsen@sun.com">Bernt.John=
sen@sun.com</a>&gt; wrote:</span></div>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">The net result from the two ment=
ioned commits is as far a I can see<br>the diff below. Myrna: can you confi=
rm?
<br><br>Index: java/testing/org/apache/derbyTesting/functionTests/tests/jdb=
capi/resultset.java<br>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
<br>--- java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/re=
sultset.java&nbsp;&nbsp;&nbsp;&nbsp; (revision 399685)
<br>+++ java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/re=
sultset.java&nbsp;&nbsp;&nbsp;&nbsp; (working copy)<br>@@ -798,12 +798,9 @@=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; try{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; r=
ow.append(s.getString
(i));<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } catch(SQLException ex){<br>-&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; i=
f (ex.getSQLState().equals(&quot;22005&quot;)) {<br>-&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (s.getBytes
(i) !=3D null)<br>-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;row.append(new String(s.getBytes(i)=
));<br>-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else<br>-&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;row.append(s.getBytes(i));<br>-&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; } else throw ex;
<br>+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp; if (ex.getSQLState().equals(&quot;22005&quot;))<br>+&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; row.append(&quot;Invalid Conversion E=
rror\n&quot;);<br>+&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; else throw ex;
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp; row.append(&quot;}\n&quot;);</blockquote>
<div>&nbsp;</div>
<div>Hi Berndt, </div>
<div>&nbsp;</div>
<div>I think that's it.</div>
<div>&nbsp;</div>
<div>Myrna<br>&nbsp;</div>

------=_Part_65604_33262617.1146794129917--