Has many IN query gives wrong results

[solnic]

Entry.all( :tags => Tag.first ).size should equal Entry.all.select {|e| e.tags.include? Tag.first }.size

A complete example to illustrate the issue can be found at: https://gist.github.com/bdc83b7c7f8797517f03

---

Created by Robert Sköld - 2010-04-30 23:38:26 UTC

Original Lighthouse ticket: http://datamapper.lighthouseapp.com/projects/20609/tickets/1259

[solnic]

I can confirm this behaviour with edge dm-core.

This is due to a problem with how many to many queries are formed when conditions are present. This likely won’t be resolved before the 1.0.0 launch, but will be handled quite soon after.

by Dan Kubb (dkubb)

[solnic]

Now this query just blows up, here’s a standalone: https://gist.github.com/884915

by Piotr Solnica (solnic)