MySQL Bugs: #100651: request to implement sql_require_primary

Bug #100651	request to implement sql_require_primary_key in 5.7
Submitted:	27 Aug 2020 8:37
Reporter:	Shane Bester (Platinum Quality Contributor)	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DDL	Severity:	S4 (Feature request)
Version:	5.7	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Request to implement sql_require_primary_key in 5.7 too.

How to repeat:
see:
 https://bugs.mysql.com/bug.php?id=69845

I am having the same issue as well. How could we restrict non-primary key table creation since GROUP_REPLICATION 5.7 requirement is to have primary key in all tables?
User/apps might sometimes created the table without primary key and we need a function/feature to restrict/block this.

That would be a great adition to 5.7