if id is string hierarchies table can't update

[philsmy]

We use uuid's (strings) as our primary key. When inserting a first child we get an error. It looks to me like it is expecting the descendant_id to be 0.

Trying to add a child we get this:

  (0.3ms)  BEGIN
  SQL (0.4ms)  INSERT INTO `event_paths` (`created_at`, `id`, `name`, `parent_id`, `type`, `updated_at`) VALUES ('2014-01-31 13:00:53', '8a056cfd-1eff-4e5d-9c9f-e45364215ad5', '6 Nations Qualifier', 0, 'TournamentStage', '2014-01-31 13:00:53')
   (0.2ms)  SELECT GET_LOCK('closure_tree', 0), 1391173253.393158
  SQL (0.2ms)  INSERT INTO `event_path_hierarchies` (`ancestor_id`, `descendant_id`, `generations`) VALUES ('8a056cfd-1eff-4e5d-9c9f-e45364215ad5', '8a056cfd-1eff-4e5d-9c9f-e45364215ad5', 0)
   (46.1ms)   INSERT INTO `event_path_hierarchies`
 (ancestor_id, descendant_id, generations)
 SELECT x.ancestor_id, '8a056cfd-1eff-4e5d-9c9f-e45364215ad5', x.generations + 1
 FROM `event_path_hierarchies` x
 WHERE x.descendant_id = 0

Mysql2::Error: Truncated incorrect DOUBLE value: '8a056cfd-1eff-4e5d-9c9f-e45364215ad5':             INSERT INTO `event_path_hierarchies`
              (ancestor_id, descendant_id, generations)
            SELECT x.ancestor_id, '8a056cfd-1eff-4e5d-9c9f-e45364215ad5', x.generations + 1
            FROM `event_path_hierarchies` x
            WHERE x.descendant_id = 0

[philsmy]

Never mind. The issue was in the model we had not change parent_id to be a string.
Leaving this here in case others stumble too.