Return-Path: Delivered-To: apmail-db-derby-commits-archive@www.apache.org Received: (qmail 93611 invoked from network); 26 Jun 2008 21:02:23 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Jun 2008 21:02:23 -0000 Received: (qmail 70120 invoked by uid 500); 26 Jun 2008 21:02:25 -0000 Delivered-To: apmail-db-derby-commits-archive@db.apache.org Received: (qmail 70045 invoked by uid 500); 26 Jun 2008 21:02:25 -0000 Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: Reply-To: "Derby Development" List-Id: Delivered-To: mailing list derby-commits@db.apache.org Received: (qmail 70028 invoked by uid 99); 26 Jun 2008 21:02:25 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Jun 2008 14:02:25 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 26 Jun 2008 21:01:43 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id E361723889C0; Thu, 26 Jun 2008 14:01:32 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r672029 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang: AnsiSignatures.java AnsiSignaturesTest.java Date: Thu, 26 Jun 2008 21:01:32 -0000 To: derby-commits@db.apache.org From: rhillegas@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20080626210132.E361723889C0@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: rhillegas Date: Thu Jun 26 14:01:32 2008 New Revision: 672029 URL: http://svn.apache.org/viewvc?rev=672029&view=rev Log: DERBY-3652: Add test cases for char and long varchar. Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignatures.java db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignaturesTest.java Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignatures.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignatures.java?rev=672029&r1=672028&r2=672029&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignatures.java (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignatures.java Thu Jun 26 14:01:32 2008 @@ -621,6 +621,46 @@ public static String varchar_String_String( Object a ) { return "-1"; } // + // CHAR + // + + // legal resolutions + public static String char_String_String( String a ) { return a; } + public static String char_String_String( byte a ) { return "-1"; } + public static String char_String_String( short a ) { return "-1"; } + public static String char_String_String( int a ) { return "-1"; } + public static String char_String_String( long a ) { return "-1"; } + public static String char_String_String( float a ) { return "-1"; } + public static String char_String_String( double a ) { return "-1"; } + public static String char_String_String( Byte a ) { return "-1"; } + public static String char_String_String( Short a ) { return "-1"; } + public static String char_String_String( Integer a ) { return "-1"; } + public static String char_String_String( Long a ) { return "-1"; } + public static String char_String_String( Float a ) { return "-1"; } + public static String char_String_String( Double a ) { return "-1"; } + public static String char_String_String( Object a ) { return "-1"; } + + // + // LONGVARCHAR + // + + // legal resolutions + public static String longvarchar_String_String( String a ) { return a; } + public static String longvarchar_String_String( byte a ) { return "-1"; } + public static String longvarchar_String_String( short a ) { return "-1"; } + public static String longvarchar_String_String( int a ) { return "-1"; } + public static String longvarchar_String_String( long a ) { return "-1"; } + public static String longvarchar_String_String( float a ) { return "-1"; } + public static String longvarchar_String_String( double a ) { return "-1"; } + public static String longvarchar_String_String( Byte a ) { return "-1"; } + public static String longvarchar_String_String( Short a ) { return "-1"; } + public static String longvarchar_String_String( Integer a ) { return "-1"; } + public static String longvarchar_String_String( Long a ) { return "-1"; } + public static String longvarchar_String_String( Float a ) { return "-1"; } + public static String longvarchar_String_String( Double a ) { return "-1"; } + public static String longvarchar_String_String( Object a ) { return "-1"; } + + // // Mixed types // public static long bigint__smallint_int_bigint_real_double Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignaturesTest.java URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignaturesTest.java?rev=672029&r1=672028&r2=672029&view=diff ============================================================================== --- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignaturesTest.java (original) +++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/AnsiSignaturesTest.java Thu Jun 26 14:01:32 2008 @@ -246,6 +246,21 @@ ( "varchar_String_String", "varchar( 10 )", new String[] { "varchar( 10 )" }, "'3.0'", "3.0" ); } + public void test_char_String_String() + throws Exception + { + declareAndRunFunction + ( "char_String_String", "char( 10 )", new String[] { "char( 10 )" }, "'3.0'", "3.0 " ); + } + + public void test_longvarchar_String_String() + throws Exception + { + // long varchar is not allowed as an argument type in a Derby routine + declareAndRunFunction + ( "longvarchar_String_String", "long varchar", new String[] { "varchar( 10 )" }, "'3.0'", "3.0" ); + } + public void test_bigint__smallint_int_bigint_real_double() throws Exception {