Open Source Contributions

Fix TRIM/RTRIM on CHAR stripping real trailing content, not just padding

Traced a SQL correctness bug, where TRIM and RTRIM on CHAR values stripped real trailing content, back through eight years of git history to a leftover trimTrailingSpaces() call. A first redesign that deleted the affected overloads was caught in review as a regression under legacy coercion, so the merged fix keeps all six overloads and removes only the two stray calls, with a test covering the legacy path.

Accept LONG as an alias for BIGINT in CAST expressions

Users of Druid's native engine write CAST(x AS LONG) since LONG is the native engine's name for its 64 bit integer type, but the SQL parser only recognized BIGINT and rejected the same cast with a parse error. Added LONG as a grammar level alias inside the CAST/SAFE_CAST/TRY_CAST production, producing the same type BIGINT already produces, without introducing a new column type or touching the shared DDL grammar.

Pass usedforsecurity=False on non-security md5 calls for FIPS hosts

Fixed a FIPS-compliance crash caused by unflagged MD5 usage across id generation, batch fingerprinting, and hash-based partitioning/sampling, adding usedforsecurity=False at every non-security call site without changing a single existing digest.

Pin UTF-8 encoding on filesystem-backed store reads

Fixed a locale-dependent bug where store values and the project YAML were written as UTF-8 but read back using whatever encoding the process's ambient locale resolved to, crashing on non-UTF-8 hosts (mainly Windows). Pinned encoding="utf-8" on every affected read/write path and added tests that force a non-UTF-8 locale to prove the fix.

Support .python-version file for plugin installs

Added a fallback so Meltano picks up a project's .python-version file (the same convention used by pyenv and uv) when choosing which Python to use for plugin virtual environments, without overriding any explicit plugin or project-level setting.

Add full_log option to suppress the diff table in equality errors

Added an opt-in full_log parameter to suppress the full row-by-row diff table in DataFrame equality failures, useful when comparing large DataFrames whose diffs would otherwise flood test output.