Empty migrations cause errors

[janpio]

I created an empty migration accidentally with migrate dev --create-only. Next time I ran that command, it tried to apply all existing migrations (including the empty one), and that cause this error:

C:\Users\Jan\Documents\throwaway\pscaleMigrationTable>npx prisma migrate dev --create-only
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma
Datasource "db": MySQL database "migration-table" at "127.0.0.1:50155"

Error: P3006

Migration `20210709211128_foo2` failed to apply cleanly to the shadow database. 
Error:
Database error
Error querying the database: Server error: `ERROR HY000 (1105): query was empty'
   0: sql_migration_connector::flavour::mysql::sql_schema_from_migration_history
             at migration-engine\connectors\sql-migration-connector\src\flavour\mysql.rs:337
   1: sql_migration_connector::validate_migrations
             at migration-engine\connectors\sql-migration-connector\src\lib.rs:322
   2: migration_core::api::DevDiagnostic
             at migration-engine\core\src\api.rs:89

(This is against PlanetScale, might be specific to them)

[tomhoule]

I think I've seen this error elsewhere in tests. If the database doesn't like empty queries/empty migrations, should we do something about it? The error message is already pretty clear, and I don't think we should silently ignore these.

[Jolg42]

Could be MySQL specific

[dosubot]

Hi, @janpio. I'm Dosu, and I'm helping the Prisma ORM team manage their backlog. I'm marking this issue as stale.

Issue Summary:

• You reported an error when applying an empty migration with migrate dev --create-only using a MySQL database on PlanetScale.
• The error message "query was empty" occurs when applying the migration to the shadow database.
• @tomhoule noted similar errors in tests and questioned the need for action due to the clear error message.
• @Jolg42 suggested the issue might be specific to MySQL.

Next Steps:

• Could you confirm if this issue is still relevant with the latest version of Prisma ORM?
• If the issue is still relevant, please comment to keep the discussion open; otherwise, it will be automatically closed in 14 days.

Thank you for your understanding and contribution!