Components
Modification to how MongoDB Component Handles Boolean Values
The MongoDB Component now writes the Boolean value false as 0 instead of an empty string. This change was made to allow null and false to be differentiated in data sources with a nullable Boolean column.
The latest version of the MongoDB data source has altered its behavior when writing Boolean values to Keboola Connection Storage. The change involves writing the Boolean value false as 0 instead of an empty string.
Previously, the behavior was as follows:
truehandled as"1"falsehandled as""nullhandled as""
The current behavior is as follows:
truehandled as"1"falsehandled as"0"nullhandled as""
This modification is necessary because, in a data sources with a nullable Boolean column, it was impossible to differentiate between null and false.