You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by rh...@apache.org on 2010/06/22 20:33:34 UTC
svn commit: r956970 -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestDbMetaData.java
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);
}