Hi, yes, I’m still using rails 1.2.6, as I haven’t made the time to
when I try to do run tests using rake, it fails to initialize the
I create the database using migrations, and I wanted to index a text
field in mysql.
add_index command does not handle adding the index correctly, as mysql
requires a length for indexing a test field, for how much of the text
field to index.
so, in my migration I have a
Model.connection.execute(‘CREATE INDEX index_name ON table_name
( field1, field2, text_field(20) )’)
however, rails records that in the schema.rb as
add_index “table”, [“field1”,“field2”,“text_field”], :name =>
I don’t want to eliminate the index, as it gives me a considerable
speed increase when looking for an exact match in the text_field…