Guest User

Untitled

a guest
Jul 16th, 2018
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. TableA
  2. has_and_belongs_to_many :table_b
  3.  
  4. TableB
  5. has_and_belongs_to_many :table_a
  6.  
  7. TableC is the join table of TableA and TableB
  8.  
  9. ---------------------------------------
  10. Arel 2.0.4 (Good query)
  11.  
  12. SELECT COUNT(DISTINCT "table_a"."id")
  13. FROM "table_a"
  14. LEFT OUTER JOIN "table_c" ON
  15. "table_c"."table_a_id" = "table_a"."id"
  16. LEFT OUTER JOIN "table_b" ON
  17. "table_b"."id" = "table_c"."table_b_id"
  18.  
  19. ---------------------------------------
  20. Arel 2.0.5 (Fucked-up query)
  21.  
  22. SELECT COUNT(DISTINCT "table_a"."id")
  23. FROM "table_a"
  24. LEFT OUTER JOIN "table_c" ON
  25. 'table_c' AND "table_c" AND 'table_a_id' AND "table_c"."table_a_id" AND 0 AND "table_a" AND 'id' AND "table_a"."id" AND
  26. "table_c"."table_a_id" = "table_a"."id"
  27. LEFT OUTER JOIN "table_b" ON
  28. 0 AND "table_b" AND 'id' AND "table_b"."id" AND 0 AND "table_c" AND 'table_b_id' AND "table_c"."table_b_id" AND
  29. "table_b"."id" = "table_c"."table_b_id"
Add Comment
Please, Sign In to add comment