Hi,
I found an issue with the DB loader where Boolean Data (true/false) is wrongly uploaded to a MySQL DB. All Boolean values are stored as “true”. Doing the same thing with DB writer everything works fine, though I don’t think that it is a problem with MySQL-drivers.
Hello ActionAndi,
we were able to reproduce the problem and are sorry about the inconveniences it caused you. I have created a bug report (internal number AP-16888) for this. We will fix this problem as soon as possible. I will keep you posted.
Bye
Tobias
Is it possible ask for a new feature or enhanced node behavior?
Usually I use an auto-incremented column as primary key, though I do not have to care about it by myself. Unfortunately the DB Loader Node complains as the number of columns does not match with the input table. Is there any chance to let the node check if a column is auto-incremented?
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'test_load' AND EXTRA like '%auto_increment%'
Hello ActionAndi,
the problem with the boolean values has been fixed with version 4.4 of the KNIME Analytics Platform which has just been released.
I have also opened another ticket for the auto-increment columns (AP-17127) and will keep you posted on this as well.
Bye
Tobias