[#MDEV-30896] Feature Request: Converting NEW and OLD rows in triggers to JSON

[MDEV-30896] Feature Request: Converting NEW and OLD rows in triggers to JSON Created: 2023-03-21 Updated: 2023-03-21
Status:	Open
Project:	MariaDB Server
Component/s:	Triggers
Fix Version/s:	None

Type:

Task

Priority:

Major

Reporter:

Markus Peter

Assignee:

Unassigned

Resolution:

Unresolved

Votes:

Labels:

None

Description

It would be great for e.g. auditing purposes, if it were possible, to convert NEW and OLD in triggers to a JSON string with something like JSON_OBJECT(OLD) or JSON_OBJECT(NEW) - or a new function.

Similar bug report (by others) for MySQL: https://bugs.mysql.com/bug.php?id=89366

In PostgeSQL, row_to_json(NEW) would work.

Generated at Thu Feb 08 10:19:42 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.

[MDEV-30896] Feature Request: Converting NEW and OLD rows in triggers to JSON Created: 2023-03-21 Updated: 2023-03-21