20.2 Release Backports Request List

[isaactwong]

Possible backports for the 20.2 release.

Please include a backport requests in this ticket for discussion by the release triage team. If you have an issue that is a release blocker please add the "release-blocker" label and it will be surfaced to the release triage team.

General

AppDev

• sql: include partial index predicates in pg_catalog and pg builtins release-20.2: sql: include partial index predicates in pg_catalog and pg builtins  #54076

BulkIO

• cli: add deprecation notice to dump CLI command release-20.2: cli: add deprecation notice to dump CLI command #54061
• parser: fix drop schedule help message release-20.2: parser: fix drop schedule help message #54375
• backupccl: change CREATE SCHEDULE output name column to label release-20.2: backupccl: change CREATE SCHEDULE output name column to label #54397
• backupccl: add more backup telemetry release-20.2: backupccl: add more backup telemetry #54863
• backupccl: add scheduled backup telemetry release-20.2: backupccl: add scheduled backup telemetry #54864

AdminUI (Observability)

Spatial

• geoindex,invertedidx...: add bounding box to inverted column release-20.2: geoindex,invertedidx,rowexec,encoding,...: add bounding box to invert… #54128
• release-20.2: backport ST_S2Covering release-20.2: backport ST_S2Covering #54433
• release-20.2: backport various standalone geospatial builtins release-20.2: backport various standalone geospatial builtins #54436
• invertedidx: don't do *types.T pointer comparison (bug fix) release-20.2: invertedidx: don't do *types.T pointer comparison #54540

Server / UI

• support opt-in non-TLS SQL client conns in secure clusters release-20.2: support opt-in non-TLS SQL client conns in secure clusters #54198
• release-20.2: keys: avoid creating invalid utf-8 sequences in logs release-20.2: keys: avoid creating invalid utf-8 sequences in logs #54272

KV

• server: always create a liveness record before starting up release-20.2: server: always create a liveness record before starting up #54212

SQL Features

• make statement_timeout respect implicit transactions (sql: ensure auto-retrying transactions respect the statement_timeout #53968)
• make Copy slurp extra bytes release-20.2: sql: slurp bytes when receiving big CopyIn message #54187
• search_path can be set to something invalid and error message is inaccurate release-20.2: sql: improve error message when an un-qualified object can't be resolved #54192
• release-20.2: sql: support UPDATE ONLY syntax release-20.2: sql: support UPDATE ONLY syntax #54426
• release-20.2: sql: allow CONNECTION LIMIT syntax for CREATE DATABASE release-20.2: sql: allow CONNECTION LIMIT syntax for CREATE DATABASE #54421

SQL Schema

• sql: non-public schema tables can have zone cfgs release-20.2: sql: non-public schema tables can have zone cfgs #54849
• schema: meta issue for missing metrics schema: meta issue for missing metrics #52078
• sql/catalog: SchemaDescriptor should have a Validate method sql/catalog: SchemaDescriptor should have a Validate method #53439
• sql/catalog: implement log redaction on sqlbase types sql/catalog: implement log redaction on sqlbase types #51239
• sql: gate potentially unsafe schema changes behind sql_safe_updates sql: gate potentially unsafe schema changes behind sql_safe_updates #51863
• sqlbase: TableDescriptor.Validate is incomplete sqlbase: TableDescriptor.Validate is incomplete #50854
• sql: writing new descriptors to system.descriptor from SQL is not possible sql: writing new descriptors to system.descriptor from SQL is not possible #50948
• sql: fix DROP COLUMN bug which ignores containing indexes release-20.2: sql: fix DROP COLUMN bug which ignores containing indexes #54262
• sql: fix adding constraints in same transaction as table release-20.2: sql: fix adding constraints in same transaction as table #54287

SQL Execution

• release-20.2: sql: make multi-tenancy errors report to telemetry release-20.2: sql: make multi-tenancy errors report to telemetry #54341
• multitenancy: implement SHOW/CANCEL QUERIES/SESSIONS for tenants release-20.2: sql/multitenancy: implement SHOW/CANCEL QUERIES/SESSIONS #54336
• sql: disable interleaved joins by default release-20.2: sql: disable interleaved joins by default #54162
• colflow: catch expected panics in an edge case release-20.2: colflow: catch expected panics in an edge case #54404
• ui: s/"query"/"statement"/ in sessions page release-20.2: ui: s/"query"/"statement"/ in sessions page #54850

SQL Optimizer

• opt: add transformation rule to convert left join to inner join release-20.2: opt: add transformation rule to convert left join to inner join #54110
• opt: add transformation rule to convert anti join to left join release-20.2: opt: add transformation rule to convert anti join to left join #54471
• sql: emit more tracing events from the stats cache release-20.2: sql: emit more tracing events from the stats cache #54190 - very low risk change, may help debugging; backported to 20.1.x as well
• sql: add placeholder values to the statement diagnostics bundle release-20.2: sql: add placeholder values to the statement diagnostics bundle #54220 - backported to 20.1.x as well
• sql: add telemetry for partial indexes release-20.2: sql: add telemetry for partial indexes #54474
• opt: generate lookup joins on partial indexes release-20.2: opt: generate lookup joins on partial indexes #54362
• unwrap explain.Node in ConstructScanBuffer release-20.2: opt: unwrap explain.Node in ConstructScanBuffer #54419 - fixes a regression that results in an internal error
• opt: fix st_distance -> st_dwithin rule to cast distance param as float opt: fix st_distance -> st_dwithin rule to cast distance param as float #54366 - fixes a panic/internal error in new functionality

Storage

Performance Regressions

[ajwerner]

@JuanLeon1 @isaactwong is this still useful?

[celiala]

Closing, as we've released 20.2, and currently have a different process for reviewing/approving backport requests