dbptk-developer icon indicating copy to clipboard operation
dbptk-developer copied to clipboard

SIARD --> MySQL: Empty Table in case of <type>BIT(1)

Open ibbenz opened this issue 1 year ago • 0 comments

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:

  1. Load the attached .siard-file in MySQL
  2. Open the "products"-table, it will be empty.
  3. Replace BIT(1) in metadata.xml with BOOLEAN
  4. Load the adapted .siard-file in MySQL
  5. The "products"-table is now filled with values.

Attach the dbptk-app.log.txt file below. dbvtk.log

The empty table: BIT_Empty_Table

The .siard-file 0_1-3_Northwind_simple_2022_07_10_dbptk_V06b.zip

ibbenz avatar Aug 12 '22 06:08 ibbenz