SingleStore Flow Release Notes

Maintenance Release Changelog

SingleStore Ingest

2026/09/15 Version 4.5.4_41dd1b10

Features
  • Added MariaDB source support.

  • Added support for MySQL BINARY and VARBINARY data types.

  • Added the XL skip-initial-extract table filter.

  • Preserved configured special characters in destination names, including hyphens.

  • Preserved shard keys and sort keys through schema evolution.

  • Fixed ClassNotFoundException on Linux by starting with java -jar instead of direct class reference.

Fixes
  • Hardened JDBC driver loading to prevent arbitrary class initialization.

  • Improved recovery when MySQL Fast CDC encounters a rejected binlog position.

  • Improved reliability when disk space is exhausted, preventing loss of CDC data and configuration corruption.

  • Improved performance when processing very large cells, including large JSON values.

  • Removed a destination setting that could unexpectedly stop CDC.

  • Prevented MySQL Fast dump data from accumulating when the scheduler is disabled.

  • Improved MySQL Fast CDC stability when acknowledgments are delayed.

2026/09/02 Version 4.5.3_8d19520d

Features
  • Queued Sync Struct and Sync New operations until an extract is in progress.

Fixes
  • Corrected run reports to use source-side counts.

  • Fixed PostgreSQL DELETE handling after a table mismatch, including tables with all-NULL primary keys.

  • Fixed false PostgreSQL column-mismatch errors after updates.

2026/08/27 Version 4.5.2_20903633

Features
  • Added a configurable PostgreSQL CDC catch-up window based on commit time.

  • Improved load reliability for large tables and out-of-memory conditions.

Fixes
  • Improved destination column-name handling when spaces are converted to underscores, while keeping names stable across subsequent changes.

  • Kept related partial-update operations together during update collapsing.

  • Made scheduler status consistent across /metrics and /status.

  • Fixed destination handling for MySQL ENUM values containing parentheses.

  • Prevented MySQL ENUM values from being interpreted as binary types.

  • Removed a stale MySQL ENUM startup warning.

  • Prevented duplicate primary keys when multiple updates occur in a single delta.

  • Improved recovery when the destination schema changes during XL onboarding.

  • Improved Reports UI alignment and tooltips.

2026/08/11 Version 4.5.1_770b588d

Fixes
  • Added SQL injection hardening through safer SQL handling.

  • Improved support for schema, table, column, and primary-key names containing hyphens, reserved words, or leading digits.

  • Improved upgrade compatibility for MySQL Fast.

  • Prevented concurrent loads from being incorrectly reported as failed.

  • Reported unconfigured sources as Stopped instead of Error.

  • Disabled rollback for PostgreSQL sources.

  • Improved MySQL handling of ZEROFILL columns during destination creation.

  • Fixed PostgreSQL delta errors involving commit timestamps without fractional seconds.

  • Prevented duplicate history rows for Oracle LOB/XML changes.

  • Improved PostgreSQL CDC parsing for values containing apostrophes and added more context to parse errors.

  • Improved XL onboarding reliability during concurrent CDC loads.

  • Allowed completed XL onboarding to be run again.

2026/07/23 Version 4.5.0_b9df345a

Features 

  • Added schema evolution support for PostgreSQL during CDC, including detection and application of column additions and removals.

  • Added schema evolution support for MySQL during CDC, including handling for column changes and ENUM value changes.

  • Added selected-table size and row-count statistics.

  • Improved Postgres and MySQL metrics.

Fixes 

  • Fixed a MySQL binlog column mismatch issue that could occur when multiple table-map events share a transaction.

  • Fixed a destination connection leak during CDC polling.

  • Fixed an issue where delta changes could appear as Full Extract after Sync New Tables.

  • Fixed 0-row tables so they are marked No Change and the progress timer stops.

2026/04/30 Version 4.4.2_38b8f072

Features 

  • Tables with no primary key no longer produce errors and are skipped during delta extracts with a warning message. This applies to Oracle Full Extract, Oracle Log Miner, MySQL Fast Extractor, and Postgres drivers.

  • Added support for full extract on SingleStore as a source database (non-production preview).

  • ENUM data type in Postgres is now converted to VARCHAR(256) in the destination table.

  • UI now displays timestamps according to the browser's locale settings.

Fixes 

  • Fixed issues with loading NULL values for INT and DATE data types from Oracle source databases.

  • Fixed display of long table names in the UI to prevent truncation.

Known Issues 

  • Some data types are not handled correctly when using SingleStore as a source database.

2026/04/02 Version 4.4.0 (7385e0f)

Features 

  • Added support for MySQL Fast Extractor (Currently in Preview).

  • Added support for BIT(n) datatype in MySQL.

  • Connection UI enhancements – Simplified connection setup by removing the Confirm Password field for all source drivers and the Database name field for SingleStore.

Fixes 

  • Fixed an issue that caused data containing backslashes to be processed incorrectly.

  • Fixed an issue where refreshing the UI resulted in a whitelabel error page.

Known Issues 

  • Invalid dates are loaded as 1970-01-01 in MySQL.

2026/02/19 Version 4.3.5 (4112eaa)

Features 

  • Unsupported datatypes are highlighted in the UI and tables with these types can no longer be selected

  • Added support for partitioned tables in Postgres

  • Invalid dates in MySQL (like year 0000) are converted to supported values

  • The test connection for Postgres provides more detailed information

  • The BOOL / BOOLEAN type in MySQL and Postgres is now created as TINYINT(1)

  • NUMERIC in Postgres is now created as DECIMAL(65,30)

  • Added support for the ENUM type in MySQL

Fixes 

  • Record count in loading logs now reflects the actual value

Known Issues 

  • Some data types may erroneously appear as unsupported

2025/12/11 Version 4.3.0 (7d351cf)

Features 

  • Added support for Salesforce as a source

Fixes 

  • Updates made based on latest vulnerability tests

  • The license is now displayed in units rather than GB

  • Updates made to replace schema with database in reference to SingleStore

  • Updated the Snowflake driver

Known Issues 

  • Compound columns in Salesforce are not supported

  • Sync struct may show a mismatch for integer columns in Salesforce

  • CDC Delete may not be captured for some tables in Salesforce

  • The Snowflake driver may produce errors. The recommended workaround is to include the following JDBC options:

    &JDBC_QUERY_RESULT_FORMAT=JSON&CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX=true&DISABLE_GCS_DEFAULT_CREDENTIALS=true

2025/11/21 Version 4.2.1 (ef8b557)

Features 

  • Re-themed the UI to closely align with SingleStore's brand

  • Added SSL support for MySQL

  • PostgreSQL TEXT[] arrays are now handled as JSON in SingleStore

  • The test connection for MySQL no longer displays an "Unable to Parse" error for basic credential-related issues

  • Suppressed extraneous messages on console on startup

2025/09/13 Version 4.1.7(9f09aa2)

Features 

  • Added ability to suppress Table Structure Sync in use cases where the destination tables are manually created

  • Added support for Where condition for Oracle Full Extracts

  • Table and columns using reserved words will be retained by default

Fixes 

  • Null values in JSON columns are correctly handled for Postgres

Known Issues 

  • Dropped columns in the source are not detected on structure sync

  • Some structure sync operations may fail without indication of error

2025/09/03 Version 4.1.6 (a8a074a)

Fixes 

  • Fixed the "Queue Full" error in MySQL Continuous Mining

  • The binlog now reconnects after exiting due to network errors in MySQL Continuous Mining

  • Added support for license-free trial use

  • Removed deprecated AWS options in the UI

  • Fixed an issue where only the first transaction in a batch was processed for MySQL Continuous Mining

2025/08/20 Version 4.1.4 (00d0934)

Features 

  • Added support for non-production free license

Fixes 

  • Nulls and zero length strings loaded with no change

  • Fixed out-of-memory error for MySQL full extracts

  • Subsequent transactions in a batch are no longer ignored

  • Added handling for table and column names using reserved words

2025/06/04 Version 4.1_b875

Features 

  • Added support for SingleStore as a source to the Any Database driver

  • Real-time CDC for MySQL - Added a new dropdown “Continuous” to MySQL

  • Added support for multi-tenant databases

Fixes 

  • More consistent display of tables in databases without a schema (or database)

2025/05/08 Version 4.1_b804

Features 

  • Added support for MongoDB (private preview only)

  • Added support for Where clause for Snowflake source

Fixes 

  • Handled database and table names with hyphens. Hyphen changed to an underscore in the destination

  • When history is stored, all timestamps will be in UTC

  • Vector data type extracted and saved as JSON in Postgres

  • Fixed Issues with Rollback

Known Issues 

  • Timestamp with Timezone datatypes is not converted to UTC

2025/04/02 Version 4.1_b702

Fixes 

  • Fixed delta load error in PostgreSQL for masked column

  • Cleared out .err files from spool directory for MySQL

  • Added 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 

  • Added 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 and JSONB 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 

  • Fixed MySQL delta extract errors

  • Added support for PostgreSQL user-defined data types

  • Added support for PostgreSQL extract of tables with reserved-word columns

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 to DATETIME(6)

Fixes 

  • Sync Struct does not get false negatives when matching data types

  • Handled reserved words in column names

  • Fixed 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

2026/09/15 Version 2.6.4_41dd1b10

Features
  • Added preview support for SingleStore-to-SingleStore XL full extract.

  • Added the skip-initial-extract table filter.

  • Added MariaDB source support and MySQL binary-type support.

  • Preserved configured special characters in destination names, including hyphens.

Fixes
  • Improved security when loading database drivers.

  • Improved performance when processing very large cells.

  • Prevented configuration corruption when disk space is exhausted.

2026/09/02 Version 2.6.3_8d19520d

Fixes
  • Fixed UUID slicing so rows with high UUID values are not omitted.

2026/08/27 Version 2.6.2_20903633

Fixes
  • Improved destination column-name handling when spaces are converted to underscores, while keeping names stable across subsequent changes.

  • Improved recovery when the destination schema changes during XL onboarding.

  • Added support for SingleStore source tables without primary keys.

  • Fixed MySQL partitioned-table extract paths.

2026/07/23 Version 2.6.0-b9df345a

Features 

  • Improved large-table onboarding so a large table can be onboarded without halting ongoing CDC.

  • Added XL-Ingest table status summary with Running and Scheduled states.

Fixes 

  • Fixed XL-Ingest handling for PostgreSQL BC, infinity, and -infinity temporal values.

  • Fixed XL-Ingest deletes for composite primary keys in SingleStore.

2026/04/30 Version 2.5.1_38b8f072

Features 

  • Added support for transfers of tables without primary keys.

  • Extracts are automatically paused when available disk space falls below 50 GB.

  • When source or destination session count is set to 0, the sessions are stopped.

  • When a slice is transferred, a JSON line is logged providing comprehensive statistics for the transfer.

Fixes 

  • Fixed out of memory issues that occurred when more than 2,000 slices were submitted.

  • Fixed handling of special characters including carriage return, new line, tab, and vertical bar.

  • The table name column in the UI is now resizable.

  • Fixed handling of invalid dates from Oracle source databases.

2026/04/02 Version 2.4.6_7385e0f

Features 

  • Added support for MySQL Fast Extractor (Currently in Preview)

  • Added support for UUID as a slicing column for Postgres

  • Added Multi-tenant support for Postgres

2026/02/19 Version 2.4.5_4112eaa

Features 

  • UI refreshed to reflect the SingleStore style

  • The BOOL / BOOLEAN type in MySQL and Postgres is now created as TINYINT(1)

  • NUMERIC in Postgres is now created as DECIMAL(65,30)

Fixes 

  • Fixed errors on loading BIT data type

2025/12/12 Version 2.4.3_7d351cf

Fixes 

  • Implemented changes based on latest vulnerability testing

2025/03/05 Version 2.4_b1257

Features 

  • Added 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 and JSONB data types

    • Column names that are reserved words

    • Table names with mixed case

2025/02/17 Version 2.4_b1227

Fixes 

  • Handled reserved-word column names

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 

  • Added support for loading 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

ControlRoom

2025/05/06 Version 43-b8

Known Issues 

  • Minor cosmetic issues on dashboard

  • No details are shown for an XL Ingest instance

Last modified:

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined
  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined
  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
    --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
    --bundle undefined \
    --new-bundle-format -
    Verified OK

Try Out This Notebook to See What’s Possible in SingleStore

Get access to other groundbreaking datasets and engage with our community for expert advice.