On Wed, Apr 1, 2020, at 10:10 AM, Stephen J. Turnbull wrote: > Brian Carpenter writes: > > On 4/1/20 9:22 AM, Stephen J. Turnbull wrote: > > > > Do you have the same version of the same DBMS backend in both? > > > Same version of SQLAlchemy? > > > > Alphabetically in regards to email address. > > OK. Thanks for confirming. > > What REST endpoint are you using? http://SERVER:PORT/3.1/members? > Or http://SERVER:PORT/3.1/lists/LIST-POST/roster/member? > (SERVER, PORT, and LIST-POST are specific to your installation. > SERVER:PORT is likely localhost:9001, and LIST-POST is the posting > address of the list being queried.) > > > We are using MySQL on the development server instead of Postgresql. We > > tried different versions of SQLAlchemy as well. Same results. > > Do you mean you have MySQL on one server, and PostgreSQL on another, > and only one is misbehaving? If so, which one? > > At this point, I can't see anything wrong with the Mailman code. > Maybe somebody else will.
The relevant code is here[1], I think, I haven't dug deeper. The order defined in the group is basically: order = (Member.list_id, Address.email, Member.role) [1]: https://gitlab.com/mailman/mailman/-/blob/master/src/mailman/model/subscriptions.py#L79 Th > _______________________________________________ > 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 > -- thanks, Abhilash Raj (maxking) _______________________________________________ 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