Re: [sqlalchemy] MSSQL OperationalError when offsetting and ordering by an aggregated column

2016-05-10 Thread Mike Bayer
On 05/10/2016 11:22 AM, Craig Weber wrote: Hello, I believe I've encountered a bug, but I wanted to verify it here before polluting the issue tracker. When I compile the following SQLAlchemy query for postgres, everything seems to work as expected; however, it fails for MSSQL. | |price_sum

[sqlalchemy] MSSQL OperationalError when offsetting and ordering by an aggregated column

2016-05-10 Thread Craig Weber
Hello, I believe I've encountered a bug, but I wanted to verify it here before polluting the issue tracker. When I compile the following SQLAlchemy query for postgres, everything seems to work as expected; however, it fails for MSSQL. price_sum = sqlalchemy.func.sum( table.c['Opportunity