Tuple-value comparisons generate incorrect queries

[fluffy-critter]

I have a lot of code where I'm trying to find values which are compared like tuples; for example, with an object Foo with fields a, b, and c, doing a comparison like

(left.a,left.b,left.c) < (right.a,right.b,right.c)

I can (clumsily, and error-proneily) do something like:

from pony import orm

r = model.Foo.get(id=5)
query = orm.select(q for q in model.Foo if
    q.field_a < r.field_a
    or (q.field_a == r.field_a and q.field_b < r.field_b)
    or (q.field_a == r.field_a and q.field_b == r.field_b and q.field_c < r.field_c))

but it would be nice to be able to instead just do:

query = orm.select(q for q in model.Foo if (q.field_a,q.field_b,q.field_c) < (r.field_a,r.field_b,r.field_c))

Pony successfully generates a query for that statement, but the resuling SQL is incorrect, in that it only compares field_c. For example (with a real, non-metasyntactic example):

>>> e=model.Entry.get(id=3982)
>>> orm.select(q for q in model.Entry if (q.local_date,q.id) < (e.local_date,e.id)).get_sql()
'SELECT "q"."id", "q"."file_path", "q"."category", "q"."status", "q"."utc_date", "q"."local_date", "q"."display_date", "q"."slug_text", "q"."entry_type", "q"."redirect_url", "q"."title", "q"."sort_title", "q"."entry_template"\nFROM "Entry" "q"\nWHERE "q"."id" < ?'

Using a lambda fares no better:

>>> model.Entry.select(lambda q: (q.local_date,q.id) < (e.local_date,e.id)).get_sql()
'SELECT "q"."id", "q"."file_path", "q"."category", "q"."status", "q"."utc_date", "q"."local_date", "q"."display_date", "q"."slug_text", "q"."entry_type", "q"."redirect_url", "q"."title", "q"."sort_title", "q"."entry_template"\nFROM "Entry" "q"\nWHERE "q"."id" < ?'

So, either the API allows a thing it shouldn't, or the implementation of that support is incorrect. Either way it'd be nice for it to work right.

[kozlovsky]

Thanks for reporting, should be fixed now

[fluffy-critter]

Thanks so much!