[sqlalchemy] Re: Ordering results ina self-referential join

2008-05-06 Thread Michael Bayer
On May 6, 2008, at 1:43 PM, Moshe C. wrote: Hi, Node is an orm mapped class, which is self-referential. myquery = Node.query() myquery = myquery.join('parent', aliased=True) myquery = myquery.filter(Node.c.desc.like('%something')) myquery = myquery.order_by(Node.c.name) The last line

[sqlalchemy] Re: Ordering results ina self-referential join

2008-05-06 Thread Moshe C.
Both methods cause a crash (yes, on 0.4.5) . converting a tuple to a list in sqlalchemy/orm/query.py fixes it for one of the methods, for the other you need to do the opposite, convert a list to a tuple. File '/home/moshe/top/webapp/rma/rma/controllers/list.py', line 215 in list_sources

[sqlalchemy] Re: Ordering results ina self-referential join

2008-05-06 Thread Moshe C.
I couldn't create a simple test case, but I have analyzed the cause of the problem. The order_by() method is sent a list as an argument, but the argument 'criterion' becomes a tuple because of the def order_by(self, *criterion) syntax. in the case of if self._aliases_tail: , 'criterion' becomes

[sqlalchemy] Re: Ordering results ina self-referential join

2008-05-06 Thread Michael Bayer
thats really weird. I dont have time to check this now but i added ticket 1027 to confirm. On May 6, 2008, at 5:22 PM, Moshe C. wrote: I couldn't create a simple test case, but I have analyzed the cause of the problem. The order_by() method is sent a list as an argument, but the

[sqlalchemy] Re: Ordering results ina self-referential join

2008-05-06 Thread Michael Bayer
OK you got it in r4673, sorry youre hitting all these (kinda weird) On May 6, 2008, at 7:20 PM, Michael Bayer wrote: thats really weird. I dont have time to check this now but i added ticket 1027 to confirm. On May 6, 2008, at 5:22 PM, Moshe C. wrote: I couldn't create a simple