db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rhille...@apache.org
Subject svn commit: r709161 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GeneratedColumnsTest.java
Date Thu, 30 Oct 2008 14:07:34 GMT
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 )"
              );
         
         //



Mime
View raw message