search

gouthambs / Flask-Blogging

A Markdown Based Python Blog Engine as a Flask Extension.
http://flask-blogging.readthedocs.org/en/latest/
MIT License
688 stars 159 forks source link

re-applies ordering after the join in get_posts #120

Closed raoulsullivan closed 6 years ago

raoulsullivan commented 6 years ago

@gouthambs this fixes the issue I introduced in https://github.com/gouthambs/Flask-Blogging/pull/119. Root cause was that the MySQL DB engine didn't preserve the ordering from the first table when doing a left join, unlike postgres and sqlite. Solution was to re-apply the ordering on the joined data.

Apologies for breaking master!

gouthambs commented 6 years ago

Thanks for the quick response.