Michael Erickson

sql: add SHOW STATISTICS WITH FORECAST

6

**sql/stats: replace eval.Context with tree.CompareContext** Most uses of eval.Context in the sql/stats package can actually be tree.CompareContext instead, so make the replacement. Release note: None **sql/stats: bump histogram version to...

sql/stats: remove statistics forecasting time horizon

2

When generating statistics forecasts, we must pick a time at which to forecast. To make forecasts deterministic, this time must be based on only the existing collected statistics for the...

update read committed docs around handling retries

6

Michael Erickson (michae2) commented: In 23.2, under read committed isolation, applications could still encounter spurious 40001 errors in rare cases, such as lease transfers. In 24.1, under read committed isolation,...

release note about sql.txn.upgraded_iso_level.count metric

2

Michael Erickson (michae2) commented: When upgrading from 23.2 to 24.1, cluster setting `sql.txn.read_committed_isolation.enabled` will be enabled by default, meaning transactions started with `BEGIN TRANSACTION ISOLATION LEVEL READ COMMITTED` will actually...

colexecerror: do not catch runtime panics in crdb_test builds

3

CatchVectorizedRuntimeError performs its stack-walking in order to catch *all* panics originating from within the vectorized execution engine, including runtime panics. The purpose of this is to limit the impact of...

ui: obtain redacted statement diagnostics bundles from the DB console

2

In 23.1 we added the ability to collect redacted statement diagnostics bundles using `EXPLAIN ANALYZE (DEBUG, REDACT)` which was tracked by https://github.com/cockroachdb/cockroach/issues/68570 and https://github.com/cockroachdb/cockroach/issues/98817. In order to make collection of...

With the new SFU implementation (`optimizer_use_lock_op_for_serializable`) we now simplify cardinality=0 input to norows, but we still add the lock on top. We should be able to simplify this to norows....

sql/stats: evict stats cache entry if user-defined types have changed

2

**sql: add defensive type check to sql.(\*optTableStat).init** In statistics builder we assume that the datums decoded from histogram upper bounds are comparable with datums in spans and constraints. If the...

sql: add locking to sql/row/kv_batch_fetcher.go trace message

2

In `sql/row/kv_batch_fetcher.go` there are trace messages that print the Scan or Get operation. We should add locking information to these for better observability of SELECT FOR UPDATE and other locking...