1. enzo callegari
  2. Valentina Database ADK
  3. Mittwoch, Oktober 18 2017, 07:30 PM
  4.  Abonnieren via E-Mail
Hi,

we have a problem with the execution of a query on mysql and on mariadb.

The same query executed on the two database server has different result ( of course the table are the same on both database server ): the difference
is on the "order by" clause.

I think this different behavior is related to this post

https://mariadb.com/kb/en/library/why-is-order-by-in-a-from-subquery-ignored/

Anyone see this behavior ? how we can put the ORDER BY on the top-level SELECT as suggested in the post ?

Regards
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hi Enzo,

Is this query used in the report?
Please try to set sorting on that field in the report and not in the query, that way it will be on the top level.
Kommentar
There are no comments made yet.
enzo callegari Akzeptierte Antwort
Hi Sergey,

yes, the query is used in the report and your solution works like a charm.

Thank you!

Regards
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories