Skip to content

Changelog

All notable changes to the Snowflake extension are documented here.

2.5.0 (unreleased)

Added

  • PG18 support: added a PG18 test configuration and adjusted the Docker build to skip LLVM bitcode compilation on PG18.

Changed

  • Adopted three-digit (MAJOR.MINOR.PATCH) versioning. The extension version is now 2.5.0.

Fixed

  • Fixed dump/restore of snowflake-converted sequences. convert_sequence_to_snowflake() previously left MAXVALUE at (old last_value + 1), but snowflake.nextval() bypasses MAXVALUE and writes snowflake-sized values, so pg_dump could emit a setval() that failed to restore. Sequences are now converted with AS bigint MAXVALUE 9223372036854775807, and sequences converted by earlier versions are auto-repaired on upgrade. (SUP-140)
  • Fixed the SQL command used to convert sequences to Snowflake.

Security / CI

  • Pinned GitHub Actions to full commit SHAs to harden against supply chain attacks.
  • Removed shell=True and shell-injection risks from test runner and helper subprocess calls; use shlex.split() for correct argument tokenization.
  • Fixed a SQL injection warning and a missing parameter in execute_sqlite_query, and suppressed Bandit B603 warnings on internal test helper subprocess calls.
  • Fixed the Dockerfile ARG handling for newer BuildKit versions.
  • Updated the copyright year to 2026.