Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Conversation

@gaetansenn
Copy link
Contributor

@gaetansenn gaetansenn commented Dec 11, 2025

Scope

What's changed:

  • Use atomic ALTER TABLE statement for MySQL when changing primary keys in migration 20240204A-marketplace.ts

Tested Scenarios

  • Fresh install on MySQL 8 with sql_require_primary_key=ON (blackbox mysql-strict)
  • Migration up and down functions work correctly

Review Notes / Questions

  • Same pattern already used in other migrations

Checklist

  • Added or updated tests
  • Documentation PR created here or not required
  • OpenAPI package PR created here or not required

Fixes #26324

@linear
Copy link

linear bot commented Dec 11, 2025

Copy link
Member

@ComfortablyCoding ComfortablyCoding left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

This should be added as a schema helper so it can be reused in other migrations/locations.

Sample: #25280

@gaetansenn
Copy link
Contributor Author

This should be added as a schema helper so it can be reused in other migrations/locations.

Sample: #25280

Moved into the schema helper from this commit

api/src/database/helpers/schema/types.ts Outdated Show resolved Hide resolved
api/src/database/helpers/schema/dialects/mysql.ts Outdated Show resolved Hide resolved
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Migrations failing for mysql 8

3 participants

Morty Proxy This is a proxified and sanitized view of the page, visit original site.