Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

2017-10-25 Thread Mike Bayer
On Wed, Oct 25, 2017 at 8:55 AM, Gijs Molenaar wrote: > > > Op vrijdag 20 oktober 2017 19:11:56 UTC+2 schreef Mike Bayer: >> >> On Thu, Oct 19, 2017 at 4:25 AM, Gijs Molenaar >> wrote: >> > >> > >> > Op donderdag 19 oktober 2017 03:10:21 UTC+2 schreef

Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

2017-10-25 Thread Gijs Molenaar
Op vrijdag 20 oktober 2017 19:11:56 UTC+2 schreef Mike Bayer: > > On Thu, Oct 19, 2017 at 4:25 AM, Gijs Molenaar > wrote: > > > > > > Op donderdag 19 oktober 2017 03:10:21 UTC+2 schreef Mike Bayer: > >> > >> On Wed, Oct 18, 2017 at 7:38 AM, Gijs Molenaar

Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

2017-10-20 Thread Mike Bayer
On Thu, Oct 19, 2017 at 4:25 AM, Gijs Molenaar wrote: > > > Op donderdag 19 oktober 2017 03:10:21 UTC+2 schreef Mike Bayer: >> >> On Wed, Oct 18, 2017 at 7:38 AM, Gijs Molenaar >> wrote: >> > hi! >> > >> > >> > Not sure if this a bug or something I

Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

2017-10-19 Thread Gijs Molenaar
Op donderdag 19 oktober 2017 03:10:21 UTC+2 schreef Mike Bayer: > > On Wed, Oct 18, 2017 at 7:38 AM, Gijs Molenaar > wrote: > > hi! > > > > > > Not sure if this a bug or something I should in my SQLAlchemy dialect, > but > > currently > > > > > > expr =

Re: [sqlalchemy] sqlalchemy.select().group_by(expr) doesn't use label of expression, while .order_by(expr) does

2017-10-18 Thread Mike Bayer
On Wed, Oct 18, 2017 at 7:38 AM, Gijs Molenaar wrote: > hi! > > > Not sure if this a bug or something I should in my SQLAlchemy dialect, but > currently > > > expr = (table.c.x + table.c.y).label('lx') > select([func.count(table.c.id), expr]).group_by(expr).order_by(expr)