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
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 SQLA
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. We just switched over
to PostgreSQL with very little problem so it is no longer an issue.
Stay healthy Steve!
Brian
__
Brian Carpenter writes:
> However is there anything you guys can do to mitigate that issue
> with Mariadb?
Bottom line up front: In the meantime I'd say if you want to use
MariaDB you're going to have to sort the results yourself on the
client side. Sorry about that.
Goran's analysis is corre
Goran Terzic writes:
> 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.
Thank you for finding that, I never would have!
> https://mariadb.com/kb/
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
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.
___
Any online developers that can help out with this? It would be helpful.
Brian
___
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/
Any online developers that can help out with this? It would be helpful.
Brian
___
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/
15 matches
Mail list logo
