Title: [701] trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_mssql.rb: fixed a bug in changing column defaults in ms sql
- Revision
- 701
- Author
- nolman
- Date
- 2007-08-23 12:59:57 -0400 (Thu, 23 Aug 2007)
Log Message
fixed a bug in changing column defaults in ms sql
Modified Paths
Diff
Modified: trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_mssql.rb (700 => 701)
--- trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_mssql.rb 2007-08-23 16:15:23 UTC (rev 700)
+++ trunk/activerecord-jdbc/lib/jdbc_adapter/jdbc_mssql.rb 2007-08-23 16:59:57 UTC (rev 701)
@@ -184,9 +184,9 @@
def change_column(table_name, column_name, type, options = {}) #:nodoc:
sql_commands = ["ALTER TABLE #{table_name} ALTER COLUMN #{column_name} #{type_to_sql(type, options[:limit])}"]
- if options[:default]
+ if options_include_default?(options)
remove_default_constraint(table_name, column_name)
- sql_commands << "ALTER TABLE #{table_name} ADD CONSTRAINT DF_#{table_name}_#{column_name} DEFAULT #{options[:default]} FOR #{column_name}"
+ sql_commands << "ALTER TABLE #{table_name} ADD CONSTRAINT DF_#{table_name}_#{column_name} DEFAULT #{quote(options[:default], options[:column])} FOR #{column_name}"
end
sql_commands.each {|c|
execute(c)
_______________________________________________
Jruby-extras-devel mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/jruby-extras-devel
