SingleStore Flow Release Notes
On this page
Maintenance Release Changelog
SingleStore Ingest
2025/04/02 Version 4. 1_ b702
Fixes
-
Fixed delta load error in PostgreSQL for masked column
-
Clear out
.
files from spool directory for MySQLerr -
Support for the
JSON
data type in MySQL -
DATETIME(3)
now created to retain milliseconds for MySQL to SingleStore
2025/03/05 Version 4. 1_ b699
Features
-
Support for the JDBC database source (Snowflake).
Databases vary considerably and this driver has only been tested with Snowflake.
JDBC database source extracts do not support a CDC mechanism and are full extracts only. -
Enhancements to the PostgreSQL source driver
-
Array data type (inserted as JSON in SingleStore)
-
Custom data types
-
JSON
andJSONB
data types -
Column names that are reserved words
-
Table names with mixed case
-
Fixes
-
Fixed MySQL delta extract errors
Known Issues
-
Masked columns are not supported for PostgreSQL
-
The
BYTEA
data type is not handled correctly on PostgreSQL -
The
BIT(size)
data type is not handled correctly on MySQL -
The
TINYINT
/BIT
data type may show a mismatch on Sync Struct
2025/02/17 Version 4. 1_ b671
Fixes
-
Fix for MySQL delta extract errors
-
PostgreSQL user-defined data types are now supported
-
PostgreSQL extract of tables with reserved-word columns is now supported
2025/01/31 Version 4. 1_ b643
Features
-
Implemented a new licensing scheme which is based wholly on the destination SingleStore instance size
-
Added connection attributes to SingleStore connection
-
Added support for loading binary data.
Flow now uses Avro format internally. -
Mapped the Microsoft SQL Server type
DATETIME
toDATETIME(6)
Fixes
-
Sync Struct does not get false negatives when matching data types
-
Reserved words in column names are now handled
-
Fixes to loading deltas for history tables
Known Issues
-
Delta extracts can sometimes fail on MySQL
-
Timezone-based timestamps do not take the time zone into account
-
Masked columns can fail on PostgreSQL
-
Binary data may be ignored on PostgreSQL
-
MySQL
BIT(n)
data types are not handled correctly -
Rollback may not work as expected in some cases
-
Load message in the logs may show incorrect record counts
2025/01/21 Version 4. 0. 2_ b587
Features
-
Updated how reserved words are handled in column names, which can be done by either adding an underscore (default) or enclosing them in backticks
-
Increased the precision for
DATETIME
in the SQL Server input source
2024/12/24 Version 4. 0. 2_ b571
Features
-
Implemented data type mapping for all four sources
-
Primary key and shard key are automatically created on SingleStore
-
Removed extraneous sources from the drop-down list
Known Issues
-
Binary data not loaded
-
Timestamps with time zones are not converted to UTC
-
Masking columns may give load errors
-
Loading with history may fail in some cases
2024/12/03 Version 4. 0. 2_ b536
Features
-
Full extracts provide a detailed progress bar on the Dashboard
-
Default transfer type is now set to not keep history
-
PostgreSQL databases will now show tables in the
PUBLIC
schema
Fixes
-
Auto-selecting the primary key now works as expected
-
The Dashboard shows scheduled period for values under 1 minute
-
The Advanced tab for Destination now works as expected
-
Fixed the occasional null value error on startup
-
Changes in the underlying runtime metadata tables
SingleStore XL Ingest
2025/03/05 Version 2. 4_ b1257
Features
-
Support for the JDBC database source (Snowflake)
-
Enhancements to the PostgreSQL source driver
-
UUID column can be used for slicing
-
Array data type (added to SingleStore as JSON)
-
Custom data types
-
JSON
andJSONB
data types -
Column names that are reserved words
-
Table names with mixed case
-
2025/02/17 Version 2. 4_ b1227
Fixes
-
Reserved-word column names are now handled
2025/01/31 Version 2. 4_ b1224
Features
-
Implemented a new licensing scheme which is based wholly on the destination SingleStore instance size
-
Added connection attributes to SingleStore connection
-
Added support for loading binary data.
Flow now uses Avro format internally.
Fixes
-
Loads data for tables with masked columns
Known Issues
-
Timezone-based timestamps do not take the time zone into account
-
BLOB data is not extracted for Oracle
2025/01/21 Version 2. 3_ b1178
Features
-
Updated how reserved words are handled in column names, which can be done by either adding an underscore (default) or enclosing them in backticks
-
Increased the precision for
DATETIME
in the SQL Server input source
2024/12/24 Version 2. 3_ b1174
Features
-
Implemented data type mapping for all four sources
Known Issues
-
Binary data not loaded
-
Timestamps with time zones are not converted to UTC
-
Masking columns may give load errors
Last modified: April 2, 2025