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 2008/10/30 15:07:34 UTC
svn commit: r709161 -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java
Author: rhillegas
Date: Thu Oct 30 07:07:34 2008
New Revision: 709161
URL: http://svn.apache.org/viewvc?rev=709161&view=rev
Log:
DERBY-3931: Make generated columns tests independent so that they will run smoothly on platforms which run the test cases in reverse alphabetical order.
Modified:
db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java
Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java?rev=709161&r1=709160&r2=709161&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java Thu Oct 30 07:07:34 2008
@@ -618,6 +618,20 @@
goodStatement
(
conn,
+ "create function f_bt_minus\n" +
+ "(\n" +
+ " a int\n" +
+ ")\n" +
+ "returns int\n" +
+ "language java\n" +
+ "deterministic\n" +
+ "parameter style java\n" +
+ "no sql\n" +
+ "external name 'org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.minus'\n"
+ );
+ goodStatement
+ (
+ conn,
"create function triggerReports()\n" +
"returns TABLE\n" +
" (\n" +
@@ -661,7 +675,7 @@
goodStatement
(
conn,
- "create table t1_trig( a int, b int generated always as ( f_minus(a) ), c int )\n"
+ "create table t1_trig( a int, b int generated always as ( f_bt_minus(a) ), c int )\n"
);
goodStatement
(
@@ -834,7 +848,21 @@
goodStatement
(
conn,
- "create table t1_for( a int, b int generated always as ( f_minus(a) ) primary key, c int )"
+ "create function f_bfk_minus\n" +
+ "(\n" +
+ " a int\n" +
+ ")\n" +
+ "returns int\n" +
+ "language java\n" +
+ "deterministic\n" +
+ "parameter style java\n" +
+ "no sql\n" +
+ "external name 'org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsTest.minus'\n"
+ );
+ goodStatement
+ (
+ conn,
+ "create table t1_for( a int, b int generated always as ( f_bfk_minus(a) ) primary key, c int )"
);
goodStatement
(
@@ -849,7 +877,7 @@
goodStatement
(
conn,
- "create table t4_for( a int, b int generated always as ( f_minus(a) ) references t3_for( b ), c int )"
+ "create table t4_for( a int, b int generated always as ( f_bfk_minus(a) ) references t3_for( b ), c int )"
);
//