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 Po
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
On Wed, Apr 1, 2020, at 10:19 AM, Abhilash Raj wrote:
> 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
Thank you everyone for looking into this.
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/
SqlAlchemy generated query for getting m
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
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://S
Alphabetically in regards to email address.
We are using MySQL on the development server instead of Postgresql. We tried
different versions of SQLAlchemy as well. Same results.
___
Mailman-Developers mailing list -- mailman-developers@python.org
To unsu
goran.ter...@gmail.com writes:
> I got list of members in order of creation.
>
> I tried same thing on another server, and I got members ordered
> alphabetically.
What do you mean by "alphabetically"? "Alphabetically on display
name" is a plausible interpretation, but in fact Mailman 3 orde
Just to add some additional information:
1. List owners/moderators are being sorted alphabetically. Just not list
members/users.
2. Mailing Lists are being sorted alphabetically. Just not list members/users.
3. Using MySQL as the backend database.
___