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.
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:
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
datavaluestable having a value of 0 forOffsetTypeIDbut theoffsettypestable only has values for 1 and 2.