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.
Download MariaDB 10.3.1
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.”
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/
Your email address will not be published. Required fields are marked *
MariaDB Developers Unconference patch review day - digging in to the InnoDB redo log #MariaDBinShenzhen
Great news for MariaDB and people using Azure. Hope to see Amazon join next - https://t.co/ah5El82ECc
https://t.co/FpKZxAtDFh: Microsoft joins the MariaDB Foundation as a Platinum level sponsor https://t.co/ndBsAiiyXQ
https://t.co/FpKZxAc2NJ: Presentations from the 2017 MariaDB Developers Unconference in Shenzhen https://t.co/TPaCGvP3Ok
Jun Su from Microsoft discussing challenges in hosting MySQL in the cloud environment, improvements that could be made #MariaDBinShenzhen
MariaDB Foundation sponsors:
2017 Copyright MariaDB Foundation • Powered by WordPress, MariaDB and Linux