Problem with using 'whereOr' and 'and' in same select query

[vaneyck]

It seems that sugar orm doesn't nest OR operations properly. For example, in this code the and operation interferes with the whereOr

    Select.from(Message.class)
        .whereOr(Condition.prop("delivery_status").eq(DeliveryStatus.SENT),
        Condition.prop("delivery_status").eq(DeliveryStatus.FAILED))
        .and(Condition.prop("synced").eq(0))
        .list();

The result query would be

    delivery_status == SENT || ( delivery_status == FAILED && synced == 0)

[whoshuu]

Interesting find. Will take a closer look at this behavior within the next week.