Errors when ordering by multiple fields of a model in SQLAlchemy 1.0.2

[elvismacak]

when using sqlalchemy 1.0.2 as described in requirements, it cause lots of bug.

the following code runs ok in sqlalchemy 0.9.8, but error in 1.0.2

session.query(Computer).join(Person).order_by('person.age').order_by('person.name').count()
session.query(Computer).join(Person).order_by('person.age').join(Person).order_by('person.name').count()

as my commit 9b06b95, i check it before join to fix the multiple join error, but meet other bugs(also caused by the sqlalchemy 1.0.2).

finally, i rollback the sqlalchemy to 0.9.8, but it's still an import bug.

[jonafato]

@elvis-macak There were quite a few bug fixes made after SQLAlchemy 1.0.0 was released. Do you still have the same issues with the current stable version (1.0.5)?

[jfinkels]

Yes, please check a more recent version of SQLAlchemy (i.e. later than 1.0.2). If your problems are solved, then I will increase the minimum version requirement of SQLAlchemy.

[jfinkels]

This should be fixed by commit 64a5711.