Processing Skew 924 Avoiding an Extreme Skew Warning 924 Checking for and Terminating Overflowed Backends 925 Steps 925 Viewing Metadata Information about Database Objects 926 Viewing the Last Operation Functions 1588 Table 8. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost silent bool]]) boolean Returns the result of JSON path predicate check for the specified JSON value. Only the first item of the result is taken into account. If the result is not Boolean, then null is returned

Processing Skew 1144 Avoiding an Extreme Skew Warning 1144 Checking for and Terminating Overflowed Backends 1145 Logging Statements that Cause Overflowed Subtransactions 1146 Viewing Metadata Information backend process latch during the backend initialization with backend teardown, which could cause backends to fail with latch already owned by pid. N/A Resolves CVE-2023-5869: Buffer overrun from integer backend process latch during the backend initialization with backend teardown, which could cause backends to fail with latch already owned by pid. 371708 Resolves an issue with a race condition between

Processing Skew 1112 Avoiding an Extreme Skew Warning 1112 Checking for and Terminating Overflowed Backends 1113 Logging Statements that Cause Overflowed Subtransactions 1114 Viewing Metadata Information specified to provide the directory. 16356 The gpcheckperf utility was changed to ensure that the result set for the list of hosts displayed for network tests matches the results from earliear versions 12818 Resolved an issue where GPORCA generated a Nested Look Join (NLJ) plan with an incorrect result. 15311 Resolved an issue where GPORCA generated incorrect results when using Left Outer Join (LOJ)

Processing Skew 1127 Avoiding an Extreme Skew Warning 1128 Checking for and Terminating Overflowed Backends 1128 Logging Statements that Cause Overflowed Subtransactions 1129 Viewing Metadata Information retained after reorganizing. Query Processing 14303 Resolved an issue where GPORCA generated a wrong result for a query on a partitioned table when the query evaluated different types of predicates at the append-only auxiliary tables. 13739 Resolves an issue where Greenplum Database returned a wrong result or silently errored out when a subplan contained a SharedScan and the subplan’s parent Plan included

Functions 796 Table 7. JSON Processing Functions Function Return Type Description Example Example Result json_array_length(json) jsonb_array_length(jsonb) int Returns the number of elements in the outermost to identical column names in the target row type. JSON type coercion for these functions might not result in desired values for some types. JSON fields that do not appear in the target row type will be omitted Processing Skew 1093 Avoiding an Extreme Skew Warning 1094 Checking for and Terminating Overflowed Backends 1094 Logging Statements that Cause Overflowed Subtransactions 1095 Viewing Metadata Information

Processing Skew 1089 Avoiding an Extreme Skew Warning 1089 Checking for and Terminating Overflowed Backends 1090 Logging Statements that Cause Overflowed Subtransactions 1091 Viewing Metadata Information append-only auxiliary tables. 13739 Resolves an issue where Greenplum Database returned a wrong result or silently errored out when a subplan contained a SharedScan and the subplan's parent Plan included to help users query for suboverflowed backends. Users can use segment id and process id information reported in the view to terminate the offending backends, thereby preventing degradation of performance

generate_series functions, and Index Only Scan plans. 12228 : Resolves generation of faulty plans that could result in segfault on indexed tables. The issue occurred when path nodes with bottleneck locus types (Entry results. Specifically, for operations involving a SEQUENCE function on the replicated table, the result was not guaranteed to be identical across different segments. This issue was resolved by identifying plan for a subquery that has GROUPING SETS. 10794 - Resource Groups : Resolves an issue where the result of a query on pg_resgroup_get_status(NULL:oid) could not be saved to a table. 10376 - Query Execution

results. Specifically, for operations involving a SEQUENCE function on the replicated table, the result was not guaranteed to be identical across different segments. This issue was resolved by identifying plan for a subquery that has GROUPING SETS. 10794 - Resource Groups : Resolves an issue where the result of a query on pg_resgroup_get_status(NULL:oid) could not be saved to a table. 10376 - Query Execution (which cannot be analyzed) if an external table was part of a table partition hierarchy. This would result in the failure ERROR: unsupported table type when performing partitioned table operations that use

results. Specifically, for operations involving a SEQUENCE function on the replicated table, the result was not guaranteed to be identical across different segments. This issue was resolved by identifying the SQL_ASCII encoding regardless of the locale settings (deprecated since 6.0). This choice may result in misbehavior of character-string functions when data that is not encoding-compatible with the greenplum_path.sh file. The greenplum_path.sh from the previous release might contain updates that were the result of installing those extensions. VMware Greenplum v6.17 Documentation VMware, Inc. 221 Or if you

aggregate function (special aggs) would cause a PANIC. 32123, 13265 : Resolves an issue where the result of an UPDATE query that included a NOT IN operator identified that one row was updated, when in an inefficient query plan for a query that included a common table expression (CTE) and where the result set was used more than once. 181647276 : Resolves an issue where Greenplum Database crashed when generate_series functions, and Index Only Scan plans. 12228 : Resolves generation of faulty plans that could result in segfault on indexed tables. The issue occurred when path nodes with bottleneck locus types (Entry