Open
Description
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
Labels
No labels