Skip to content
This repository has been archived by the owner on Dec 14, 2022. It is now read-only.

database migration error #88

Open
jackyzy823 opened this issue Apr 18, 2022 · 0 comments
Open

database migration error #88

jackyzy823 opened this issue Apr 18, 2022 · 0 comments

Comments

@jackyzy823
Copy link

migration with new database (from v0.3.1)

just using docker-compose.yaml
diesel_migration raise error:

thread 'main' panicked at 'called `Result::unwrap()` on an `Err` value: HandlerError { kind: MigrationErrorDb("Failed with: You have an error in your SQL syntax; check the
 manual that corresponds to your MySQL server version for the right syntax to use near \'DELIMITER $$\nDROP PROCEDURE IF EXISTS `create_index` $$\nCREATE PROCEDURE `create\' at line 4"), backtrace:    0: pushb
ox::db::run_embedded_migrations

I think it may be related to DELIMITER can be only used in mysql cli but not SQL file.

Related Issue: diesel-rs/diesel#2622.

migration with exists database
since the name/timestamp 2018-03-28-211330_create_users_table not changed , so the up.sql will not be executed by diesel_migration again.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant