MariaDB 10.3.1 now available
The MariaDB project is pleased to announce the availability of MariaDB 10.3.1, the 2nd alpha release in the MariaDB 10.3 series. See the release notes and changelogs for details.
Release Notes Changelog What is MariaDB 10.3?
MariaDB APT and YUM Repository Configuration Generator
Thanks, and enjoy MariaDB!
Hi Guys, we’ve been having some problems with GROUP BY and I think someone that wrote mysql is responsible, so please, shed some light over here. We’re dieing to find out the truth behind the following sentence.
In your documentation, you wrote this “The server is free to choose any value from each group, so unless they are the same, the values chosen are indeterminate.”
https://dev.mysql.com/doc/refman/5.7/en/group-by-handling.html
Someone, unrelated to us, made some investigations https://kristiannielsen.livejournal.com/6745.html .
Is it safe to have GROUP BY in a subselect and ORDER BY on the results of the subselect? (keeping in mind that ONLY_FULL_GROUP_BY is disabled?)
Thanks so much.
If I understand what you mean, yes, the values are indeterminate, (and in practice determined by the order of the records, which can change), so you can’t rely on the results. I suggest providing more details about your problems, table structure and query and asking this on IRC or on the mailing list: https://mariadb.com/kb/en/the-mariadb-library/resources/