db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From to...@apache.org
Subject svn commit: r410249 - /db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlBuilder.java
Date Tue, 30 May 2006 11:57:05 GMT
Author: tomdz
Date: Tue May 30 04:57:05 2006
New Revision: 410249

URL: http://svn.apache.org/viewvc?rev=410249&view=rev
Log:
Fix for DDLUTILS-109

Modified:
    db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlBuilder.java

Modified: db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlBuilder.java
URL: http://svn.apache.org/viewvc/db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlBuilder.java?rev=410249&r1=410248&r2=410249&view=diff
==============================================================================
--- db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlBuilder.java (original)
+++ db/ddlutils/trunk/src/java/org/apache/ddlutils/platform/mssql/MSSqlBuilder.java Tue May
30 04:57:05 2006
@@ -110,7 +110,7 @@
         printAlwaysSingleQuotedIdentifier(tableName);
         println(")");
         println("BEGIN");
-        println("  DECLARE @tablename nvarchar(60), @constraintname nvarchar(60)");
+        println("  DECLARE @tablename nvarchar(256), @constraintname nvarchar(256)");
         println("  DECLARE refcursor CURSOR FOR");
         println("  SELECT object_name(objs.parent_obj) tablename, objs.name constraintname");
         println("    FROM sysobjects objs JOIN sysconstraints cons ON objs.id = cons.constid");
@@ -426,7 +426,6 @@
         }
     }
 
-
     /**
      * Processes the addition of a column to a table.
      * 
@@ -481,7 +480,7 @@
         String tableName = getTableName(change.getChangedTable());
 
         println("BEGIN");
-        println("  DECLARE @tablename nvarchar(60), @constraintname nvarchar(60)");
+        println("  DECLARE @tablename nvarchar(256), @constraintname nvarchar(256)");
         println("  DECLARE refcursor CURSOR FOR");
         println("  SELECT object_name(objs.parent_obj) tablename, objs.name constraintname");
         println("    FROM sysobjects objs JOIN sysconstraints cons ON objs.id = cons.constid");
@@ -530,7 +529,7 @@
             String columnName = getColumnName(sourceColumn);
 
             println("BEGIN");
-            println("  DECLARE @tablename nvarchar(60), @constraintname nvarchar(60)");
+            println("  DECLARE @tablename nvarchar(256), @constraintname nvarchar(256)");
             println("  DECLARE refcursor CURSOR FOR");
             println("  SELECT object_name(objs.parent_obj) tablename, objs.name constraintname");
             println("    FROM sysobjects objs JOIN sysconstraints cons ON objs.id = cons.constid");



Mime
View raw message