Author: tomdz
Date: Tue Nov  4 22:22:02 2008
New Revision: 711516

URL: http://svn.apache.org/viewvc?rev=711516&view=rev
Log:
Added unit test for DDLUTILS-195: Can not update a foreign key on a case sensetive MySql Database

Modified:
    db/ddlutils/trunk/src/test/java/org/apache/ddlutils/io/TestAlteration.java

Modified: db/ddlutils/trunk/src/test/java/org/apache/ddlutils/io/TestAlteration.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/test/java/org/apache/ddlutils/io/TestAlteration.java?rev=711516&r1=711515&r2=711516&view=diff
==============================================================================
--- db/ddlutils/trunk/src/test/java/org/apache/ddlutils/io/TestAlteration.java (original)
+++ db/ddlutils/trunk/src/test/java/org/apache/ddlutils/io/TestAlteration.java Tue Nov  4 22:22:02 2008
@@ -880,6 +880,62 @@
     }
 
     /**
+     * Tests the removal of a foreign key with camel case naming (DDLUTILS-195).
+     */
+    public void testDropCamelCaseFK()
+    {
+        final String model1Xml = 
+            "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+
+            "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+
+            "  <table name='Roundtrip1'>\n"+
+            "    <column name='Pk1' type='INTEGER' primaryKey='true' required='true'/>\n"+
+            "    <column name='Pk2' type='DOUBLE' primaryKey='true' required='true'/>\n"+
+            "  </table>\n"+
+            "  <table name='Roundtrip2'>\n"+
+            "    <column name='Pk' type='INTEGER' primaryKey='true' required='true'/>\n"+
+            "    <column name='Avalue1' type='DOUBLE' required='true'/>\n"+
+            "    <column name='Avalue2' type='INTEGER' required='true'/>\n"+
+            "    <foreign-key name='Rt1_To_Rt2' foreignTable='Roundtrip1'>\n"+
+            "      <reference local='Avalue2' foreign='Pk1'/>\n"+
+            "      <reference local='Avalue1' foreign='Pk2'/>\n"+
+            "    </foreign-key>\n"+
+            "  </table>\n"+
+            "</database>";
+        final String model2Xml = 
+            "<?xml version='1.0' encoding='ISO-8859-1'?>\n"+
+            "<database xmlns='" + DatabaseIO.DDLUTILS_NAMESPACE + "' name='roundtriptest'>\n"+
+            "  <table name='Roundtrip1'>\n"+
+            "    <column name='Pk1' type='INTEGER' primaryKey='true' required='true'/>\n"+
+            "    <column name='Pk2' type='DOUBLE' primaryKey='true' required='true'/>\n"+
+            "  </table>\n"+
+            "  <table name='Roundtrip2'>\n"+
+            "    <column name='Pk' type='INTEGER' primaryKey='true' required='true'/>\n"+
+            "    <column name='Avalue1' type='DOUBLE' required='true'/>\n"+
+            "    <column name='Avalue2' type='INTEGER' required='true'/>\n"+
+            "  </table>\n"+
+            "</database>";
+
+        createDatabase(model1Xml);
+
+        insertRow("Roundtrip1", new Object[] { new Integer(1), new Double(2.0) });
+        insertRow("Roundtrip2", new Object[] { new Integer(2), new Double(2.0), new Integer(1) });
+
+        alterDatabase(model2Xml);
+
+        assertEquals(getAdjustedModel(),
+                     readModelFromDatabase("roundtriptest"));
+
+        List beans1 = getRows("Roundtrip1");
+        List beans2 = getRows("Roundtrip2");
+
+        assertEquals(new Integer(1), beans1.get(0), "Pk1");
+        assertEquals(new Double(2.0), beans1.get(0), "Pk2");
+        assertEquals(new Integer(2), beans2.get(0), "Pk");
+        assertEquals(new Double(2.0), beans2.get(0), "Avalue1");
+        assertEquals(new Integer(1), beans2.get(0), "Avalue2");
+    }
+
+    /**
      * Tests removing a foreign key and an index that has the same name and same column.
      */
     public void testDropFKAndCorrespondingIndex()