aws-samples / aws-samples/aws-database-migration-samples
MySql script not idempotent
Open
- Dominant language
- PLpgSQL
- Stars
- 185
- Forks
- 215
- PR merge metrics
- No merged PRs in 30d
Description
Running `aws-database-migration-samples/mysql/sampledb/v1/install-rds.sql` failed due to [this bug]. Fixing it was simple enough, but re-running required a number of changes since the scripts are not idempotent. Ideally, there'd be a `DROP TABLE IF EXISTS table_name;` before each `CREATE TABLE`, and `DROP USER IF EXISTS` before the dms_user is created.
Contributor guide
Assessment
This issue has not been assessed yet.