From 10f53ae8f131b33ac9319cf13c735e3c4372ea15 2024-09-09 12:53:36
From: Branko Majic <branko@majic.rs>
Date: 2024-09-09 12:53:36
Subject: [PATCH] MAR-218: Enable case-sensitive column name handling for database privileges:

- This will become a new default in the next major release of the
  community.mysql collection.
- Gets rid of the Ansible mysql_user module warning.

---

diff --git a/roles/database/tasks/main.yml b/roles/database/tasks/main.yml
index 228bed06ce65ebb30fbb89950a55bffe4973aa76..3b72d7d0ad3fb680f3c8ec84373eb5c53fe78e18 100644
--- a/roles/database/tasks/main.yml
+++ b/roles/database/tasks/main.yml
@@ -13,6 +13,7 @@
     priv: "{{ db_name }}.*:ALL"
     state: present
     login_unix_socket: "/var/run/mysqld/mysqld.sock"
+    column_case_sensitive: true
 
 - name: Enable backup
   ansible.builtin.include_tasks: backup.yml