dbptk-developer
dbptk-developer copied to clipboard
MySQL-->Siard: lob-Type and folder in metadata, but not in content-folder
Description: A database with tables is exported from MySQL into .siard with dbptk. The table "Employees" contains the column "HireDate" and "Photo". In the metadata.xml of the .siard-file of the export "HireDate" and "Photo" are of type "Character Large Object", in each case with a lob-folder.
However, in the content-folder of the table "Employees" there are no lob-Folders containing the data of "HireDate" and "Photo" The data of "HireDate" and "Photo" is part of the table3.xml-file
--> Why does metadata.xml reference to lob-folders and data, when there is no lob folders and no lob-Data?
Steps required to reproduce the bug:
- Import 0_1-3_Northwind_simple_2022_07_10_dbptk_V06.zip as a .siard file in MySQL with dbptk
- Export the data from MySQL into 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.zip
- Compare the metadata.xml of "HireDate" and "Photo" with the content-folder of the table "Employees"
Attach the dbptk-app.log.txt file below. dbvtk.log
The import-file: 0_1-3_Northwind_simple_2022_07_10_dbptk_V06.zip
The export-file 2022_07_10_dbptk_V06_MySQL2SIARD_dbptk.zip
Visualisation of "HireDate" and "Photo" before export:
Visualisation of "HireDate" and "Photo" after export: