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

@jackyzy823

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.

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