View Issue Details

IDProjectCategoryView StatusLast Update
0000660bareos-coredirectorpublic2017-11-28 12:34
Reportermosi0815 Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
PlatformLinuxOSUbuntuOS Version14.04
Product Version15.2.3 
Summary0000660: MySQL DDL files use wrong syntax
DescriptionLet's take one table out of the create script for the database:

CREATE TABLE Device (
...
   MediaTypeId INTEGER UNSIGNED DEFAULT 0 REFERENCES MediaType,
...
);

This is not gonna work. MySQL silently ignores REFERENCES in column definitions.

From the manual:
"MySQL parses but ignores “inline REFERENCES specifications” (as defined in the SQL standard) where the references are defined as part of the column specification. MySQL accepts REFERENCES clauses only when specified as part of a separate FOREIGN KEY specification"

http://dev.mysql.com/doc/refman/5.7/en/create-table.html
Steps To ReproduceCreate the catalog in MySQL. Look at a DDL dump afterwards. The FKs are gone.
TagsNo tags attached.

Relationships

duplicate of 0000705 closed create_bareos_database fails on MySQL 5.7 

Activities

joergs

joergs

2017-11-28 12:34

developer   ~0002825

I marked this as a duplicate of 0000705, even so this ticket has been created earlier, as ticket 705 contains a patch for this problem.

Issue History

Date Modified Username Field Change
2016-05-18 12:21 mosi0815 New Issue
2016-10-07 12:25 joergs Relationship added related to 0000705
2017-11-28 12:33 joergs Relationship replaced duplicate of 0000705
2017-11-28 12:34 joergs Note Added: 0002825
2017-11-28 12:34 joergs Status new => closed
2017-11-28 12:34 joergs Resolution open => duplicate