Skip to content

Instantly share code, notes, and snippets.

@knowtheory
Created June 6, 2009 07:51
Show Gist options
  • Select an option

  • Save knowtheory/124763 to your computer and use it in GitHub Desktop.

Select an option

Save knowtheory/124763 to your computer and use it in GitHub Desktop.
MysqlError in 'behavior i expect out of an orm should be able to find things by properties on distant child models'
(mysql_errno=1066, sql_state=42000) Not unique table/alias: 'humans'
Query: SELECT "humans"."id", "humans"."first_name", "humans"."middle_name", "humans"."last_name" FROM "humans" INNER JOIN "ownerships" ON "pets"."id" = "ownerships"."pet_id" INNER JOIN "humans" ON "ownerships"."human_id" = "humans"."id" WHERE "pets"."name" = 'Bo' GROUP BY "humans"."id", "humans"."first_name", "humans"."middle_name", "humans"."last_name" ORDER BY "humans"."id"
/Library/Ruby/Gems/1.8/gems/dm-core-0.10.0/lib/dm-core/adapters/data_objects_adapter.rb:85:in `execute_reader'
/Library/Ruby/Gems/1.8/gems/dm-core-0.10.0/lib/dm-core/adapters/data_objects_adapter.rb:85:in `read'
/Library/Ruby/Gems/1.8/gems/dm-core-0.10.0/lib/dm-core/adapters/data_objects_adapter.rb:253:in `with_connection'
/Library/Ruby/Gems/1.8/gems/dm-core-0.10.0/lib/dm-core/adapters/data_objects_adapter.rb:81:in `read'
/Library/Ruby/Gems/1.8/gems/dm-core-0.10.0/lib/dm-core/repository.rb:145:in `read'
/Library/Ruby/Gems/1.8/gems/dm-core-0.10.0/lib/dm-core/collection.rb:982:in `lazy_load'
/Library/Ruby/Gems/1.8/gems/extlib-0.9.13/lib/extlib/lazy_array.rb:440:in `cmp?'
/Library/Ruby/Gems/1.8/gems/extlib-0.9.13/lib/extlib/lazy_array.rb:325:in `=='
SELECT "humans"."id", "humans"."first_name", "humans"."middle_name", "humans"."last_name"
FROM "humans"
INNER JOIN "ownerships" ON "pets"."id" = "ownerships"."pet_id"
INNER JOIN "humans" ON "ownerships"."human_id" = "humans"."id"
WHERE "pets"."name" = 'Bo'
GROUP BY "humans"."id", "humans"."first_name", "humans"."middle_name", "humans"."last_name"
ORDER BY "humans"."id"
SELECT `humans`.`id`, `humans`.`first_name`, `humans`.`middle_name`, `humans`.`last_name`
FROM `humans`
INNER JOIN `ownerships` ON `ownerships`.`human_id` = `humans`.`id`
INNER JOIN `pets` ON `pets`.`id` = `ownerships`.`pet_id`
WHERE `pets`.`name` = 'Bo'
GROUP BY `humans`.`id`, `humans`.`first_name`, `humans`.`middle_name`, `humans`.`last_name`
ORDER BY `humans`.`id`
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment