AWS AmazonRDS documentation change
Summary
Updated documentation for Aurora Babelfish releases, including syntax support clarifications, GUC formatting changes, typo fixes, stability enhancements (e.g., NULL handling in PIVOT operator), numeric operation fixes, crash resolutions, and version label updates.
Security assessment
Changes focus on documentation improvements, syntax clarifications, and stability enhancements (e.g., crash fixes and numeric operation corrections). No explicit references to security vulnerabilities, CVEs, or security advisories are present. Crash fixes address stability but lack evidence of being security-related exploits.
Diff
diff --git a/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraBabelfish.Updates.md b/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraBabelfish.Updates.md index af9386aa2..0089c3db3 100644 --- a//AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraBabelfish.Updates.md +++ b//AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraBabelfish.Updates.md @@ -51,5 +51 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 17.5. For mo - * Added support for CREATE OR ALTER VIEW / ALTER VIEW syntax in Babelfish with the following limitations: - - * Can't be used on views that have INSTEAD-OF trigger attached. - - * Can't be used on views that have another view based on this view. + * Added CREATE OR ALTER VIEW / ALTER VIEW syntax support in Babelfish with few limitations. @@ -72 +68 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 17.5. For mo - * Added new GUCs “babelfishpg_tsql.apg_enable_correlated_scalar_transform” and “babelfishpg_tsql.apg_enable_subquery_cache” to control subquery optimization features in Babelfish. The new GUCs are ON by default. + * Added new GUCs `babelfishpg_tsql.apg_enable_correlated_scalar_transform` and `babelfishpg_tsql.apg_enable_subquery_cache` to control subquery optimization features in Babelfish. The new GUCs are `ON` by default. @@ -97 +93 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 17.5. For mo - * Fixed the issue “wrong varnullingrels” error could be reported incorrectly after subquery transformation. + * Fixed the issue `wrong varnullingrels` error could be reported incorrectly after subquery transformation. @@ -99 +95 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 17.5. For mo - * Fixed the issue that alter table will cause follow up cacade drop cmd failed to drop the database contain this table. + * Fixed the issue that alter table will cause follow up cascade drop command failed to drop the database contain this table. @@ -125 +121 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 17.5. For mo - * Transfer nullability and identity properties of columns in SELECT INTO statement to new table. These properites are only transferred if there is a single table in FROM clause of SELECT INTO and the column isn't part of expression in select into statements target list. + * Transfer nullability and identity properties of columns in SELECT INTO statement to new table. These properties are only transferred if there is a single table in FROM clause of SELECT INTO and the column isn't part of expression in select into statements target list. @@ -160 +156 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 17.5. For mo - * Fixed a crash in in resolve_numeric_typmod_from_exp for aggragate functions using *(all columns). + * Fixed a crash in `resolve_numeric_typmod_from_exp` for aggregate functions using *(all columns). @@ -345,5 +341 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 16.9. For mo - * Added support for CREATE OR ALTER VIEW / ALTER VIEW syntax in Babelfish with the following limitations: - - * Can't be used on views that have INSTEAD-OF trigger attached. - - * Can't be used on views that have another view based on this view. + * Added CREATE OR ALTER VIEW / ALTER VIEW syntax support in Babelfish with few limitations. @@ -366 +358 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 16.9. For mo - * Added new GUCs “babelfishpg_tsql.apg_enable_correlated_scalar_transform” and “babelfishpg_tsql.apg_enable_subquery_cache” to control subquery optimization features in Babelfish. The new GUCs are ON by default. + * Added new GUCs `babelfishpg_tsql.apg_enable_correlated_scalar_transform` and `babelfishpg_tsql.apg_enable_subquery_cache` to control subquery optimization features in Babelfish. The new GUCs are ON by default. @@ -391 +383 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 16.9. For mo - * Fixed the issue “wrong varnullingrels” error could be reported incorrectly after subquery transformation. + * Fixed the issue `wrong varnullingrels` error could be reported incorrectly after subquery transformation. @@ -419 +411 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 16.9. For mo - * Transfer nullability and identity properties of columns in SELECT INTO statement to new table. These properites are only transferred if there is a single table in FROM clause of SELECT INTO and the column isn't part of expression in select into statements target list. + * Transfer nullability and identity properties of columns in SELECT INTO statement to new table. These properties are only transferred if there is a single table in FROM clause of SELECT INTO and the column isn't part of expression in select into statements target list. @@ -456 +448 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 16.9. For mo - * Fixed a crash in in resolve_numeric_typmod_from_exp for aggragate functions using *(all columns). + * Fixed a crash in resolve_numeric_typmod_from_exp for aggragate functions using *(all columns). @@ -1294,0 +1287,28 @@ This release of Aurora Babelfish is provided with Aurora PostgreSQL 15.13. For m +**High Priority stability enhancements** + + * Fixed PIVOT operator to gracefully handle NULL entries in pivot column. + + * Fixed issue with result having incorrect scale in numeric/decimal addition and subtraction. + + * Fixed issue which causes incorrect result in arithmetic operations which results in numeric/decimal type. + + * Fixed an issue in round() function to ensure return types match input argument types. + + + + +**Additional improvements and enhancements** + + * Fixed the entry in `babelfish_schema_permissions` which was getting overridden if there were table and procedure with the same name. + + * Fixed an errors while fetching the object definition of tsql objects due to handling of few nodes in `sys.tsql_get_expr`. + + * Fixed the logic for numeric/decimal datatype typmod resolution in outer/inner queries. + + * Fixed case expression when one of the branch is NUMERIC and other is of EXACT NUMERIC. + + * Fixed a crash in `resolve_numeric_typmod_from_exp` for aggregate functions using *(all columns). + + + + @@ -3820 +3840 @@ Babelfish DB clusters running on Aurora PostgreSQL 13.7 or older versions can't - * Babelfish for Aurora PostgreSQL 1.5 (Deprecated) + * Babelfish for Aurora PostgreSQL 1.5 @@ -3835 +3855 @@ Babelfish DB clusters running on Aurora PostgreSQL 13.7 or older versions can't -### Babelfish for Aurora PostgreSQL 1.5 (Deprecated) +### Babelfish for Aurora PostgreSQL 1.5