SingleStore Flow Release Notes

Maintenance Release Changelog

SingleStore Ingest

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

  • 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/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: February 7, 2025

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