deepfryed,

> i'm using dm-core/next

You can use dm-core/master now if you wish.  I merged them together a
few days ago.

> SELECT "id", "name", "type", "code", "country" FROM "books" WHERE
> "type" = 'fiction' AND ("code" = '1' AND "country" = 'au') OR ("code"
> = '2' AND "country" = 'au') ORDER BY "id"
>
> which is incorrect.

That's the SQL query I would expect to see generated from that query.
What were you expecting?

DM should work fine with relationships between non-key properties.
Although the general convention is for the child side (the one that
defines the belongs_to) that the FK would be pointing to the parent
PK.  It's not strictly enforced anywhere, but it is the default way
models are related.

I updated the example a tiny bit to see better logger output, and
remove some redundant options, and I ended up with:

  http://pastie.org/607983

It returns what I would expect, 1 matching book for the first author,
and 0 for the second.  Do you think this is wrong?

--

Dan
(dkubb)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"DataMapper" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/datamapper?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to