Primary Key required on tables
- Dominant language
- No language data
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
## Bug Report
**Current Behavior**
When using a clustered SQL environment, installation fails due to missing primary keys on the database tables.
```
Unable to create or change a table without a primary key, when the system variable 'sql_require_primary_key' is set Add a primary key to the table or unset this variable to avoid this message. Note that tables without a primary key can cause performance problems in row-based replication, so please consult your DBA before changing this setting.
```
This issue seems to be present on any percona and clustered database
CC : @luceos
Contributor guide
Research direction
Start by reproducing installation in a clustered or Percona SQL environment with sql_require_primary_key enabled, then inspect the database table creation used during installation. Done means installation completes without the missing-primary-key error and every created table satisfies the environment's primary-key requirement.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100