##// END OF EJS Templates
SQLServer: rule is a reserved keyword (#12713)....
Jean-Philippe Lang -
r10869:dd7d54b3a1d7
parent child
Show More
@@ -62,8 +62,8 class WorkflowRule < ActiveRecord::Base
62 else
62 else
63 transaction do
63 transaction do
64 delete_all :tracker_id => target_tracker.id, :role_id => target_role.id
64 delete_all :tracker_id => target_tracker.id, :role_id => target_role.id
65 connection.insert "INSERT INTO #{WorkflowRule.table_name} (tracker_id, role_id, old_status_id, new_status_id, author, assignee, field_name, rule, type)" +
65 connection.insert "INSERT INTO #{WorkflowRule.table_name} (tracker_id, role_id, old_status_id, new_status_id, author, assignee, field_name, #{connection.quote_column_name 'rule'}, type)" +
66 " SELECT #{target_tracker.id}, #{target_role.id}, old_status_id, new_status_id, author, assignee, field_name, rule, type" +
66 " SELECT #{target_tracker.id}, #{target_role.id}, old_status_id, new_status_id, author, assignee, field_name, #{connection.quote_column_name 'rule'}, type" +
67 " FROM #{WorkflowRule.table_name}" +
67 " FROM #{WorkflowRule.table_name}" +
68 " WHERE tracker_id = #{source_tracker.id} AND role_id = #{source_role.id}"
68 " WHERE tracker_id = #{source_tracker.id} AND role_id = #{source_role.id}"
69 end
69 end
General Comments 0
You need to be logged in to leave comments. Login now