dbptk-developer
dbptk-developer copied to clipboard
SIARD --> MySQL: Empty Table in case of <type>BIT(1)
Description: BIT(1)-Datatype in metadata.xml of a .siard will result in an empty table after uploading the .siard in MySQL. Replacing BIT(1) with BOOLEAN in metadata.xml solves the issue. Is it possible to adapt dbptk-Desktop that way that it accepts BIT(1) too? --> no interferring with metadata.xml will be necessary.
Steps required to reproduce the bug:
- Load the attached .siard-file in MySQL
- Open the "products"-table, it will be empty.
- Replace BIT(1) in metadata.xml with BOOLEAN
- Load the adapted .siard-file in MySQL
- The "products"-table is now filled with values.
Attach the dbptk-app.log.txt file below. dbvtk.log
The empty table:
The .siard-file 0_1-3_Northwind_simple_2022_07_10_dbptk_V06b.zip