Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_LTS-13
• Babelfish extensions modified for WiltonDB WILTON_3_LTS-18
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_09_26-1
• wdb_config 1.0.3

Fixes:

• fix the error when the procedure is called with an empty table-valued parameter (#97)

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_LTS-13
• Babelfish extensions modified for WiltonDB WILTON_3_LTS-17
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.3

Notable changes:

• security patches and bugfixes from upstream PostgreSQL 15.9 and 15.10
• fix to the problem with time, datetime2 and datetimeoffset precision handling and the bcp utility (#91)

To upgrade the existing DB cluster run the installer and then run the following on Postgres connection:

ALTER EXTENSION "babelfishpg_common" UPDATE TO '3.3.6';
ALTER EXTENSION "babelfishpg_tsql" UPDATE TO '3.3.3';

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_LTS-12
• Babelfish extensions modified for WiltonDB WILTON_3_LTS-16
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.3

WARNING: THIS UPDATE IS NOT COMPATIBLE WITH DB CLUSTERS FROM PREIVIOUS WILTONDB VERSIONS

This update includes breaking changes implemented to fix the #2987 problem. Because of this there is no update path from version 11.15.1 - new DB cluster must be created. On Windows this is done automatically - default installation directory is changed to C:\Program Files\WiltonDB Software\wiltondb_3_lts.

For full list of changes see the commit history in WILTON_3_LTS branch in engine and extensions repositories.

Changes:

• Tinyint data type implementation (#53)

TODO: document other changes.

PRE-RELEASE, CAN ONLY BE USED WITH A NEWLY CREATED DB CLUSTER

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_3-11
• Babelfish extensions modified for WiltonDB 3.3-WILTON_3_3
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.2

Changes:

• tinyint implementation as a TYPE instead of a DOMAIN draft 1 (#53)

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_3-11
• Babelfish extensions modified for WiltonDB 3.3-WILTON_3_3
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.2

Changes:

• Allow windows auth users with spaces in domain name (#58)

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_3-11
• Babelfish extensions modified for WiltonDB 3.3-WILTON_3_3
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.2

Changes:

• Support 1-to-1 match of OS users do DB logins with SSPI (#18)

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_3-11
• Babelfish extensions modified for WiltonDB 3.3-WILTON_3_3
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.2

Bugfixes:

• use UUID as a suffix for a temporary view created in sp_describe_first_result_set procedure (#23)

Contents:

• PostgreSQL modified for Babelfish 15.4-WILTON_3_3-11
• Babelfish extensions modified for WiltonDB 3.3-WILTON_3_3-15
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.2

Bugfixes:

• CHECK CONSTRAINTS hint support with bcp and related fixes (#2628)
• query parameters of type binary(8) are no longer confused with rowversion type (#24)
• resolve correct INFORMATION_SCHEMA views in T-SQL inline blocks (#28)

Changes:

• Windows authentication support with SSPI (#18)
• support adding backtraces to error messages in server log if debuginfo files available in <install_dir>/symbols directory. wiltondb3.3_debug_11.15.1.msi installer is provided that includes debuginfo files files. Note, running server with backtraces enabled may be up to 1.5 times slower than normal runs.

• PostgreSQL modified for Babelfish 15.4-WILTON_3_3-10
• Babelfish extensions modified for WiltonDB 3.3-WILTON_3_3
• pg_hint_plan REL15_1_5_1_WILTON-1
• tds_fdw v2.0.3-wilton
• system_stats v2.1
• PostgreSQL Windows dependencies 2024_06_23-1
• wdb_config 1.0.2

Changes:

• support adding backtraces to error messages if debuginfo is availbale