[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[5955] trunk/sql12/fw/src/main/java/net/ sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java

[<man...@us...>]

Revision: 5955
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=5955&view=rev
Author:   manningr
Date:     2010-11-06 20:27:58 +0000 (Sat, 06 Nov 2010)

Log Message:
-----------
Fixed dialect bug which manifested itself when the child index is created after creating a FK (quotes around the column name that is constrained by the FK)

Modified Paths:
--------------
    trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java

Modified: trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java
===================================================================
--- trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java	2010-11-06 17:39:55 UTC (rev 5954)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java	2010-11-06 20:27:58 UTC (rev 5955)
@@ -583,6 +583,9 @@
 			ckIndexValuesMap.put(ST_TABLE_NAME_KEY, localTableName);
 		}
 
+		// MySQL disallows quoted column identifiers when dropping a column.
+		prefs.setQuoteColumnNames(false);		
+		
 		return DialectUtils.getAddForeignKeyConstraintSQL(fkst, fkValuesMap, ckIndexSt, ckIndexValuesMap,
 			localRefColumns, qualifier, prefs, this);
 	}


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.