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:
Category:MySQL Server: DDL Severity:S4 (Feature request)
Version:5.7 OS:Any
Assigned to: CPU Architecture:Any

[27 Aug 2020 8:37] Shane Bester
Request to implement sql_require_primary_key in 5.7 too.

How to repeat:
[27 Aug 2020 9:28] Eddy Ng
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.
[3 Sep 2020 11:11] Truphone DBA
That would be a great adition to 5.7