Mark Sapiro writes: > On 4/2/20 1:05 PM, brian_carpen...@emwd.com wrote:
> > https://mariadb.com/kb/en/why-is-order-by-in-a-from-subquery-ignored/ > > is saying it is not a bug so I doubt SQLAlchemy will think it is. > > My take is a bit different. MariaDB is saying this is not a MariaDB bug. > They would say that it is a SQLAlchemy bug in that in this case, the > SQLAlchemy generated query should put the ORDER BY clause on the outer > SELECT and not on the sub-query. Yup, my take is the same. @mailman-developers I will do some research to find out if SQLAlchemy is aware of this already, or maybe has documented it as a limitation with appropriate ways to deal with it in user code. But it's definitely reportable against SQLAlchemy if MariaDB is right about the SQL standard (trust but verify on that one too :-). Steve _______________________________________________ Mailman-Developers mailing list -- mailman-developers@python.org To unsubscribe send an email to mailman-developers-le...@python.org https://mail.python.org/mailman3/lists/mailman-developers.python.org/ Mailman FAQ: https://wiki.list.org/x/AgA3 Security Policy: https://wiki.list.org/x/QIA9
