non-integer id

[voltechs]

Rebuilding a table with non-integer id's doesn't work. Is there a workaround? I'm not sure why this is even an issue.

I had this happen twice. The first table was small enough I could convert to integer, and then back. After the table is 'rebuilt', non-integer id's and parent_id's work fine, but not prior to the rebuild.

My second table is much too massive to do by hand.

[voltechs]

Group Exists (0.5ms)  SELECT 1 FROM `groups` LEFT OUTER JOIN `groups` AS parent
ON `groups`.`parent_id` = parent.
WHERE (`groups`.`lft` IS NULL OR `groups`.`rgt` IS NULL OR `groups`.`lft` >= `groups`.`rgt` OR (`groups`.`parent_id` IS NOT NULL AND (`groups`.`lft` <= parent.`lft` OR `groups`.`rgt` >= parent.`rgt`))) LIMIT 1

ActiveRecord::StatementInvalid: Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`groups`.`lft` IS NULL OR `groups`.`rgt` IS NULL OR `groups`.`lft` >= `gr' at line 1: SELECT  1 FROM `groups` LEFT OUTER JOIN `groups` AS parent ON `groups`.`parent_id` = parent. WHERE (`groups`.`lft` IS NULL OR `groups`.`rgt` IS NULL OR `groups`.`lft` >= `groups`.`rgt` OR (`groups`.`parent_id` IS NOT NULL AND (`groups`.`lft` <= parent.`lft` OR `groups`.`rgt` >= parent.`rgt`))) LIMIT 1