Revision 46724 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.spi/src/main/java/org/gvsig/fmap/dal/feature/spi/SQLBuilderBase.java

View differences:

SQLBuilderBase.java
2551 2551 
                            )
2552 2552 
                    );
2553 2553 
                }
2554 
                sqls.add(builder.toString());
2555 
            }
2556 
            for (ColumnDescriptor column : alters) {
2557 
                StringBuilder builder = new StringBuilder();
2558 
                builder.append("ALTER TABLE ");
2559 
                builder.append(this.table.toString(formatter));
2560 
                builder.append(" ALTER COLUMN ");
2561 
                builder.append(as_identifier(column.getName()));
2554 2562 
                if (column.getDefaultValue() == null) {
2555 2563 
                    if (column.allowNulls()) {
2556 
                        builder.append(" DEFAULT NULL");
2564 
                        builder.append(" SET DEFAULT NULL");
2557 2565 
                    } else {
2558 2566 
                        builder.append(" DROP DEFAULT");
2559 2567 
                    }
2560 2568 
                } else {
2561 
                    builder.append(" DEFAULT '");
2569 
                    builder.append(" SET DEFAULT '");
2562 2570 
                    builder.append(column.getDefaultValue().toString());
2563 2571 
                    builder.append("'");
2564 2572 
                }

Also available in: Unified diff