db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r956970 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java
Date Tue, 22 Jun 2010 18:33:34 GMT
Author: rhillegas
Date: Tue Jun 22 18:33:33 2010
New Revision: 956970

URL: http://svn.apache.org/viewvc?rev=956970&view=rev
Log:
DERBY-4659: Add regression test for getFunctionColumns() for functions with BOOLEAN arguments.

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java?rev=956970&r1=956969&r2=956970&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java
Tue Jun 22 18:33:33 2010
@@ -75,6 +75,9 @@ public class TestDbMetaData extends Base
         s.execute("CREATE FUNCTION DUMMY4 ( X VARCHAR(128), Y INTEGER ) "+
                   "RETURNS INTEGER PARAMETER STYLE JAVA NO SQL LANGUAGE "+
                   "JAVA EXTERNAL NAME 'java.some.func'");
+        s.execute("CREATE FUNCTION DUMMY5 ( X BOOLEAN ) "+
+                  "RETURNS BOOLEAN PARAMETER STYLE JAVA NO SQL LANGUAGE "+
+                  "JAVA EXTERNAL NAME 'java.some.func'");
     }
 
     private static Test baseSuite(String name) {
@@ -145,6 +148,7 @@ public class TestDbMetaData extends Base
         { null, "APP", "DUMMY2", "java.some.func", FUNCTION_NO_TABLE_VALUE, GENERIC_NAME
},
         { null, "APP", "DUMMY3", "java.some.func", FUNCTION_NO_TABLE_VALUE, GENERIC_NAME
},
         { null, "APP", "DUMMY4", "java.some.func", FUNCTION_NO_TABLE_VALUE, GENERIC_NAME
},
+        { null, "APP", "DUMMY5", "java.some.func", FUNCTION_NO_TABLE_VALUE, GENERIC_NAME
},
         { null, "SYSCS_UTIL", "SYSCS_CHECK_TABLE",
           "org.apache.derby.catalog.SystemProcedures.SYSCS_CHECK_TABLE",
           FUNCTION_NO_TABLE_VALUE, GENERIC_NAME },
@@ -353,6 +357,14 @@ public class TestDbMetaData extends Base
               "INTEGER", new Integer(10), new Integer(4), new Integer(0),
               new Integer(10), new Integer(1), null, null, new Integer(2),
               "YES", GENERIC_NAME, new Integer(2), new Integer(1) },
+            { null, "APP", "DUMMY5", "", new Integer(4), new Integer(16),
+              "BOOLEAN", new Integer(1), new Integer(1), null,
+              null, new Integer(1), null, null, new Integer(0),
+              "YES", GENERIC_NAME, new Integer(1), new Integer(-1) },
+            { null, "APP", "DUMMY5", "X", new Integer(1), new Integer(16),
+              "BOOLEAN", new Integer(1), new Integer(1), null,
+              null, new Integer(1), null, null, new Integer(1),
+              "YES", GENERIC_NAME, new Integer(1), new Integer(0) },
         };
         JDBC.assertFullResultSet(rs, expectedRows, false);
     }
@@ -379,6 +391,10 @@ public class TestDbMetaData extends Base
               "INTEGER", new Integer(10), new Integer(4), new Integer(0),
               new Integer(10), new Integer(1), null, null, new Integer(0),
               "YES", GENERIC_NAME, new Integer(2), new Integer(-1) },
+            { null, "APP", "DUMMY5", "", new Integer(4), new Integer(16),
+              "BOOLEAN", new Integer(1), new Integer(1), null,
+              null, new Integer(1), null, null, new Integer(0),
+              "YES", GENERIC_NAME, new Integer(1), new Integer(-1) },
         };
         JDBC.assertFullResultSet(rs, expectedRows, false);
     }



Mime
View raw message