[SYNCOPE-1662] Leverage MariaDB JSON type

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 3.0.7, 4.0.0
• Component/s: core
• Labels: jpa mariadb persistence
• Assignee: Unassigned
• Reporter: Francesco Chicchiriccò
• Created: 30/Jan/22 07:41
• Updated: 21/Dec/23 15:30

Description

Similar to SYNCOPE-1395 for PostgreSQL and SYNCOPE-1401 for MySQL, enhance the JPA layer by empowering MariaDB JSON datatype for user, group and any object attributes.

Issue Links

• links to: [CONJ-954] Type java.time.OffsetDateTime not supported type
• links to: [MCOL-4976] NULL values from JSON NESTED PATH with JSON column
• links to: [MCOL-4977] CREATE VIEW AS SELECT involving JSON column requires root privileges