Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of nirmal070125@gmail.com
 designates 209.85.216.179 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:date:message-id:subject:from:to:content-type;
        b=KJCdB6YEWvJO25dBhzQH43y/lQsQsNOULJ/m06k3iNhZBwKaiRngx2uonCiknyfBpN
         lND6Bj1GNbgq95/U7LG+eibtZUtF33kJ9G78i8JesGVRATLGsS/dOrHXO0UDs43MMAsu
         Vdn25HH1ws34amg3B/J003YEHSeJPqF6AHp+0=
MIME-Version: 1.0
Date: Wed, 1 Sep 2010 20:42:55 +0530
Message-ID: <AANLkTik_OhTqO63+nhBw18YUfO7bQbhA3+SshW7u9+aR@mail.gmail.com>
Subject: Supporting nanoseconds resolution in an insertion
From: Nirmal Fernando <nirmal070125@gmail.com>
To: derby-dev@db.apache.org
Content-Type: multipart/alternative; boundary=001636164a2bd443d3048f3421b9

--001636164a2bd443d3048f3421b9
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

While referring to DateTimeTest I found the following test case [1].
I think we should allow up to nanoseconds, but I am wondering whether
it's not the ISO format.

Is it ok to change this test case?

A help is highly appreciated.

Thanks.

[1]
/**
     *  Don't allow more than microseconds in ISO format: cloudscape
rejects.
     */
    public void testISOFormat_MoreThanMicroseconds() throws SQLException{
        Statement st = createStatement();

        assertStatementError("22007", st, "insert into ts (ts1) values "
                + "('2003-03-05-17.05.43.999999999')");

        assertStatementError("22007", st, " insert into ts (ts1) values "
                + "('2003-03-05-17.05.43.999999000')");

        st.close();
    }
-- 
Best Regards,
Nirmal

C.S.Nirmal J. Fernando
Department of Computer Science & Engineering,
Faculty of Engineering,
University of Moratuwa,
Sri Lanka.

--001636164a2bd443d3048f3421b9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All,<div><br></div><div>While referring to DateTimeTest I found the foll=
owing test case [1].</div><div>I think we should allow up to nanoseconds, b=
ut I am wondering whether=A0</div><div>it&#39;s not the ISO format.=A0</div=
>
<div><br></div><div>Is it ok to change this test case?</div><div><br></div>=
<div>A help is highly appreciated.</div><div><br></div><div>Thanks.</div><d=
iv><br></div><div>[1]</div><div><div>/**</div><div>=A0=A0 =A0 * =A0Don&#39;=
t allow more than microseconds in ISO format: cloudscape rejects.</div>
<div>=A0=A0 =A0 */</div><div>=A0=A0 =A0public void testISOFormat_MoreThanMi=
croseconds() throws SQLException{</div><div>=A0=A0 =A0 =A0 =A0Statement st =
=3D createStatement();</div><div>=A0=A0 =A0 =A0 =A0</div><div>=A0=A0 =A0 =
=A0 =A0assertStatementError(&quot;22007&quot;, st, &quot;insert into ts (ts=
1) values &quot;</div>
<div>=A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0+ &quot;(&#39;2003-03-05-17.05.43.99=
9999999&#39;)&quot;);</div><div><br></div><div>=A0=A0 =A0 =A0 =A0assertStat=
ementError(&quot;22007&quot;, st, &quot; insert into ts (ts1) values &quot;=
</div><div>=A0=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0+ &quot;(&#39;2003-03-05-17.05=
.43.999999000&#39;)&quot;);</div>
<div><br></div><div>=A0=A0 =A0 =A0 =A0st.close();</div><div>=A0=A0 =A0}</di=
v>-- <br>Best Regards,<br>Nirmal<br><br>C.S.Nirmal J. Fernando<br>Departmen=
t of Computer Science &amp; Engineering,<br>Faculty of Engineering,<br>Univ=
ersity of Moratuwa,<br>
Sri Lanka.<br>
</div>

--001636164a2bd443d3048f3421b9--