always return relationships in same order regardless of table parameter order; add some simple relationship unit tests

git-svn-id: https://svn.code.sf.net/p/jackcess/code/jackcess/trunk@269 f203690c-595d-4dc9-a70b-905162fa7fd2

1 files changed, 12 insertions, 2 deletions

diff --git a/src/java/com/healthmarketscience/jackcess/Database.java b/src/java/com/healthmarketscience/jackcess/Database.java
index be2587b..6d510df 100644
--- a/src/java/com/healthmarketscience/jackcess/Database.java
+++ b/src/java/com/healthmarketscience/jackcess/Database.java
@@ -488,10 +488,20 @@ public class Database
       _relationships = readTable(TABLE_SYSTEM_RELATIONSHIPS,
                                  _relationshipsPageNumber);
     }
-    
-    if(ObjectUtils.equals(table1.getName(), table2.getName())) {
+
+    int nameCmp = table1.getName().compareTo(table2.getName());
+    if(nameCmp == 0) {
       throw new IllegalArgumentException("Must provide two different tables");
     }
+    if(nameCmp > 0) {
+      // we "order" the two tables given so that we will return a collection
+      // of relationships in the same order regardless of whether we are given
+      // (TableFoo, TableBar) or (TableBar, TableFoo).
+      Table tmp = table1;
+      table1 = table2;
+      table2 = tmp;
+    }
+      
 
     List<Relationship> relationships = new ArrayList<Relationship>();
     Cursor cursor = createCursorWithOptionalIndex(