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

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

Revision: 6270
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6270&view=rev
Author:   manningr
Date:     2011-05-24 00:54:29 +0000 (Tue, 24 May 2011)

Log Message:
-----------
Ingres 2006 R3 doesn't support altering column nullability.

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-05-24 00:42:29 UTC (rev 6269)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java	2011-05-24 00:54:29 UTC (rev 6270)
@@ -246,7 +246,11 @@
 	 */
 	public boolean supportsAlterColumnNull()
 	{
-		return true;
+		// I see this on Ingres 2006 R3 when altering a column to be not null
+		// com.ingres.gcf.util.SqlEx: ALTER TABLE: invalid change of attributes on an ALTER COLUMN
+		//   at com.ingres.gcf.jdbc.DrvObj.readError(DrvObj.java:844)
+		//   at com.ingres.gcf.jdbc.JdbcStmt.readError(JdbcStmt.java:2412)
+		return false;
 	}
 
 	/**


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