Created
August 15, 2015 17:33
-
-
Save gintsgints/dafe9dc89a861b872dd0 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
foreign key with fields specified | |
Auto commit:true Exec: ===== SELECT "User"."id", "User"."name", "User"."createdAt", "User"."updatedAt", "Projects"."id" AS "Projects.id", "Projects"."name" AS "Projects.name", "Projects"."createdAt" AS "Projects.createdAt", "Projects"."updatedAt" AS "Projects.updatedAt", "Projects.user_projects"."createdAt" AS "Projects.user_projects.createdAt", "Projects.user_projects"."updatedAt" AS "Projects.user_projects.updatedAt", "Projects.user_projects"."project_id" AS "Projects.user_projects.projectId", "Projects.user_projects"."user_id" AS "Projects.user_projects.userId" FROM "Users" "User" LEFT OUTER JOIN ("user_projects" "Projects.user_projects" INNER JOIN "Projects" "Projects" ON "Projects"."id" = "Projects.user_projects"."project_id") ON "User"."id" = "Projects.user_projects"."user_id" WHERE "User"."id" IN (1)===== end of code | |
Got error: Error: ORA-00972: identifier is too long | |
3) should correctly get associations even after a child instance is deleted | |
√ should correctly get associations when doubly linked (780ms) | |
Auto commit:true Exec: ===== SELECT "Group"."id", "Group"."groupName", "Group"."createdAt", "Group"."updatedAt", "Users"."id" AS "Users.id", "Users"."name" AS "Users.name", "Users"."createdAt" AS "Users.createdAt", "Users"."updatedAt" AS "Users.updatedAt", "Users.group_users"."createdAt" AS "Users.group_users.createdAt", "Users.group_users"."updatedAt" AS "Users.group_users.updatedAt", "Users.group_users"."user_id" AS "Users.group_users.userId", "Users.group_users"."group_id" AS "Users.group_users.groupId", "Users.Projects"."id" AS "Users.Projects.id", "Users.Projects"."name" AS "Users.Projects.name", "Users.Projects"."createdAt" AS "Users.Projects.createdAt", "Users.Projects"."updatedAt" AS "Users.Projects.updatedAt", "Users.Projects.user_projects"."createdAt" AS "Users.Projects.user_projects.createdAt", "Users.Projects.user_projects"."updatedAt" AS "Users.Projects.user_projects.updatedAt", "Users.Projects.user_projects"."project_id" AS "Users.Projects.user_projects.projectId", "Users.Projects.user_projects"."user_id" AS "Users.Projects.user_projects.userId" FROM "Groups" "Group" LEFT OUTER JOIN ("group_users" "Users.group_users" INNER JOIN "Users" "Users" ON "Users"."id" = "Users.group_users"."user_id") ON "Group"."id" = "Users.group_users"."group_id" LEFT OUTER JOIN ("user_projects" "Users.Projects.user_projects" INNER JOIN "Projects" "Users.Projects" ON "Users.Projects"."id" = "Users.Projects.user_projects"."project_id") ON "Users"."id" = "Users.Projects.user_projects"."user_id" WHERE "Group"."id" IN (1)===== end of code | |
Got error: Error: ORA-00972: identifier is too long | |
4) should be able to handle nested includes properly |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment