Hi @ipazin,
Thanks again for the response.
We’re using MySQL 5.6.40. There haven’t been any changes to the database lately. It also seems like typical behavior of the node, it’s the same with all other TINYINT columns in other tables.
I’m working around this issue now by using CAST for the columns in my query but that shouldn’t be necessary and one must be aware that KNIME is altering data in this case…
Best
Rahul