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

database migration error #88

Description

@jackyzy823

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions