Re: [sqlalchemy] not the same number of columns in the 2 queries of the recursive request

2019-07-07 Thread Mike Bayer
On Sun, Jul 7, 2019, at 9:29 AM, Olivier SAINT-EVE wrote: > I created this recursive query: > `element0 = aliased(Territoire) sub_territories = session.query(element0, element0.id). \ filter(element0.id == 1). \ filter(element0.scale != 'Region'). \

[sqlalchemy] not the same number of columns in the 2 queries of the recursive request

2019-07-07 Thread Olivier SAINT-EVE
I created this recursive query: element0 = aliased(Territoire) sub_territories = session.query(element0, element0.id). \ filter(element0.id == 1). \ filter(element0.scale != 'Region'). \ cte(name='sub_territories', recursive=True) st_alias =