On 4/1/20 3:41 PM, brian_carpen...@emwd.com wrote:
Abhilash Raj wrote:
Find Member's API, but if the roster API is returning non-sorted list, I think 
I agree
with Steve here, I don't see anything wrong in the Mailman code.
So you disagree with Goran's findings here? We just switched over to Postgresql 
and the alphabetically sorting is now working. So I agree with Goran's 
statement:

  "Looks like the problem is that  SQLAlchemy is generating query with 'order
by' part inside nested subquery, which is not supported by mariadb."

https://mariadb.com/kb/en/why-is-order-by-in-a-from-subquery-ignored/
_______________________________________________
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

Actually I stand corrected. Abhilash is correct. Nothing wrong with Mailman's code. However is there anything you guys can do to mitigate that issue with Mariadb?

--
Please let me know if you need further assistance.

Thank you for your business. We appreciate our clients.
Brian Carpenter
EMWD.com

--
EMWD's Knowledgebase:
https://clientarea.emwd.com/index.php/knowledgebase

EMWD's Community Forums
http://discourse.emwd.com/

_______________________________________________
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

Reply via email to