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 2014/01/06 17:46:49 UTC

svn commit: r1555911 - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java

Author: rhillegas
Date: Mon Jan  6 16:46:49 2014
New Revision: 1555911

URL: http://svn.apache.org/r1555911
Log:
DERBY-6446: Filter an unwanted schema name which may turn up in query results depending on the order that tests run: derby-6446-01-aa-filterUnwantedSchema.diff

Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java?rev=1555911&r1=1555910&r2=1555911&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/GrantRevokeDDLTest.java Mon Jan  6 16:46:49 2014
@@ -433,7 +433,7 @@ public final class GrantRevokeDDLTest ex
         
         rs = st_satConnection.executeQuery(
             " select SCHEMANAME, AUTHORIZATIONID from sys.sysschemas where schemaname not "
-            + "like 'SYS%' ORDER BY SCHEMANAME");
+            + "like 'SYS%' and schemaname not like 'TEST_DBO%' ORDER BY SCHEMANAME");
         
         expColNames = new String [] {"SCHEMANAME", "AUTHORIZATIONID"};
         JDBC.assertColumnNames(rs, expColNames);
@@ -898,7 +898,7 @@ public final class GrantRevokeDDLTest ex
             " create schema authorization testSchema");
         
         rs = st.executeQuery(
-            " select SCHEMANAME, AUTHORIZATIONID from sys.sysschemas order by SCHEMANAME");
+            " select SCHEMANAME, AUTHORIZATIONID from sys.sysschemas where schemaname not like 'TEST_DBO%' order by SCHEMANAME");
         
         expColNames = new String [] {"SCHEMANAME", "AUTHORIZATIONID"};
         JDBC.assertColumnNames(rs, expColNames);