Skip to content

MySQL example causes errors #302

Open
@foundryspatial-duncan

Description

@foundryspatial-duncan

When I try to run the example SQL dump, LittleBear_ODM_1.1.1_MySQL.sql, it throws some errors when adding the foreign keys:

Cannot add or update a child row: a foreign key constraint fails (`odmtest`.`#sql-1_4`, CONSTRAINT `FK_DataValues_OffsetTypes` FOREIGN KEY (`OffsetTypeID`) REFERENCES `offsettypes` (`OffsetTypeID`) ON DELETE NO ACTION ON UPDATE NO ACTION)

This is using specifically the gdevt/mysql-case-insensitive Docker image.
On a MySQL server that does have case sensitive table names, I got even more errors, but this one looks like it's caused by the datavalues table having a value of 0 for OffsetTypeID but the offsettypes table only has values for 1 and 2.

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