in lib/active_record/connection_adapters/abstract/schema_statements.rb there is a missing quote_table_name in line 286 (def remove_index): execute "DROP INDEX #{quote_column_name(index_name(table_name, options))} ON #{table_name}" so my "keys" table can get an index with "add_index" but can''t remove it (without tweaking) replacing it to execute "DROP INDEX #{quote_column_name(index_name(table_name, options))} ON #{quote_table_name(table_name)}" would help (and would be logical). Best regards Savar -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
see also: https://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/4300-remove_index-doesnt-quote-table_name#ticket-4300-3 On Mar 31, 12:36 am, Savar <ansidre...@gmail.com> wrote:> in lib/active_record/connection_adapters/abstract/schema_statements.rb > there is a missing quote_table_name in line 286 (def remove_index): > > execute "DROP INDEX #{quote_column_name(index_name(table_name, > options))} ON #{table_name}" > > so my "keys" table can get an index with "add_index" but can''t remove > it (without tweaking) > > replacing it to > > execute "DROP INDEX #{quote_column_name(index_name(table_name, > options))} ON #{quote_table_name(table_name)}" > > would help (and would be logical). > > Best regards > Savar-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.
You''ll want to add a test showing the failing case, and succeeding after your change. A table name of `index` or `on` or something. On Mar 31, 2010, at 5:03 AM, Savar wrote:> see also: > > https://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/4300-remove_index-doesnt-quote-table_name > #ticket-4300-3 > > On Mar 31, 12:36 am, Savar <ansidre...@gmail.com> wrote: >> in lib/active_record/connection_adapters/abstract/ >> schema_statements.rb >> there is a missing quote_table_name in line 286 (def remove_index): >> >> execute "DROP INDEX #{quote_column_name(index_name(table_name, >> options))} ON #{table_name}" >> >> so my "keys" table can get an index with "add_index" but can''t >> remove >> it (without tweaking) >> >> replacing it to >> >> execute "DROP INDEX #{quote_column_name(index_name(table_name, >> options))} ON #{quote_table_name(table_name)}" >> >> would help (and would be logical). >> >> Best regards >> Savar > > -- > You received this message because you are subscribed to the Google > Groups "Ruby on Rails: Core" group. > To post to this group, send email to rubyonrails- > core@googlegroups.com. > To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com > . > For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en > . >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Core" group. To post to this group, send email to rubyonrails-core@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-core+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-core?hl=en.