MySQL Bugs: #105788: Feature Request: Allow UDFs on CHECK contraints

Bug #105788	Feature Request: Allow UDFs on CHECK contraints
Submitted:	3 Dec 2021 10:46	Modified:	3 Dec 2021 11:36
Reporter:	Rúben Ferreira	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:	8.0.27	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Currently MySQL is lagging behind on data integrity compared to many others SQL DBMS. MariaDB and PostgreSQL currently supports UDFs on CHECK constraints, which allows a custom set of validation rules. There are many others CHECK limitations, however UDFs should resolve most of them. 
I really hope that MySQL take one key aspect of data (data integrity) more seriously, since this should be treated on the database layer.

How to repeat:
N/A

Hello Rúben Ferreira,

Thank you for the reasonable feature request!

regards,
Umesh