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

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

Revision: 6162
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6162&view=rev
Author:   manningr
Date:     2011-02-21 21:35:10 +0000 (Mon, 21 Feb 2011)

Log Message:
-----------
Don't add the default clause if the null clause is not also added.

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

Modified: trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java
===================================================================
--- trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java	2011-02-21 21:25:17 UTC (rev 6161)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java	2011-02-21 21:35:10 UTC (rev 6162)
@@ -416,10 +416,18 @@
 		SqlGenerationPreferences prefs)
 	{
 		ArrayList<String> result = new ArrayList<String>();
-		boolean addDefaultClause = true;
+		boolean addDefaultClause = false;
 		boolean supportsNullQualifier = false;
 		boolean addNullClause = false;
 
+		// In Ingres2006, these work:
+		// ALTER TABLE test1 ADD "nullint" integer 
+		// ALTER TABLE test1 ADD "nullint" integer not null with default
+		// 
+		// This doesn't:
+		// ALTER TABLE test1 ADD "nullint" integer with default
+		
+		
 		String sql =
 			DialectUtils.getAddColumSQL(column,
 				this,


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