Release Summary
This is a minor release of the community.mysql collection.
This changelog contains all changes to the modules and plugins in this collection that have been made after the previous release.
Minor Changes
- mysql_info - adds the count of tables for each database to the returned values. It is possible to exclude this new field using the db_table_count exclusion filter. (#691)
Bugfixes
- mysql_user,mysql_role - The sql_mode ANSI_QUOTES affects how the modules mysql_user and mysql_role compare the existing privileges with the configured privileges, as well as decide whether double quotes or backticks should be used in the GRANT statements. Pointing out in issue 671, the modules mysql_user and mysql_role allow users to enable/disable ANSI_QUOTES in session variable (within a DB session, the session variable always overwrites the global one). But due to the issue, the modules do not check for ANSI_MODE in the session variable, instead, they only check in the GLOBAL one.That behavior is not only limiting the users' flexibility, but also not allowing users to explicitly disable ANSI_MODE to work around such bugs like https://bugs.mysql.com/bug.php?id=115953. (#671)