Lighthouse has a new layout.
Prefer the old one? Return to the old layout,
and switch back any time from the link at the top of each page.
This project is archived and is in readonly mode.
Schema dump does not honor Sub_Part column
#779
Indexing some fields (text, blob) requires a SubPart field to be set in the Index table. Unfortunately rake db:schema:dump ignores this field and creates a simple addindex in the schema. When the test database tries to use a simple index, it fails because MySQL requires the Sub_part be set.
My recommended fix is to include an extra option in the addindex command to include Subparts.
example of error failing (name is a text field):
ryan@rtmlap:~/bs$ rake test:units
(in /home/ryan/bs)
rake aborted!
Mysql::Error: BLOB/TEXT column 'name' used in key specification without a key length: CREATE INDEX taggings ON tags (id, name)
Expected index creation to be:
CREATE INDEX taggings ON tags (id, name(30))
Reported by Ryan Mulligan ·
August 7th, 2008 @ 11:03 PM
