mbleigh/acts-as-taggable-on — Issue #205: Oracle OCIError: ORA-00972: identifier is too long
Author: frugardc
Created: 2011-11-28 14:38:09+00:00
State: open

Sad but true, Oracle has a 30 character limit in table names and aliases, so any tag that is kind of long, or on a long table name, will bomb using the current scheme for creating aliases

OCIError: ORA-00972: identifier is too long: SELECT COUNT(*) FROM "LOCATIONS" JOIN taggings locations_taggings_healthcareexchange_965 ON locations_taggings_healthcareexchange_965.taggable_id = locations.id AND locations_taggings_healthcareexchange_965.taggable_type = 'Geocode' AND locations_taggings_healthcareexchange_965.tag_id = 10021