dave-csc commented on issue #6646: URL: https://github.com/apache/hop/issues/6646#issuecomment-3945047182
Summing up what I discovered: - the field in Hop is always defined as a boolean - in Hop 2.17 the Table output transform tries to insert its value as `Y`/`N`: this causes an Oracle error if the destination column is a numeric type (`NUMBER`, `INTEGER`, etc.) - in Hop 2.16 the Table output tries to insert it as `0`/`1`: this doesn't cause Oracle errors, because a number can be safely written in `CHAR`/`VARCHAR` columns, too To test, just link a **Data grid** with a boolean field to a **Table output**, that writes in a table with a column (of different types, see above) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
