cockroachdb / cockroachdb/cockroach
sql: ANALYZE hangs forever if run within a transaction that modifies the table it is analyzing
Abierto
C-bug
O-pg-regress
T-sql-queries
- Lenguaje dominante
- Go
- Estrellas
- 32.5k
- Forks
- 4.1k
- Métricas de merge de PR
- Métricas de PR pendientes
Descripción
The following sequence hangs forever. I guess we should ban ANALYZE in open transactions, or otherwise solve this, though it doesn't seem hugely important...
```
demo@127.0.0.1:26257/defaultdb> create table a (a int);
demo@127.0.0.1:26257/defaultdb> begin;
demo@127.0.0.1:26257/defaultdb OPEN> insert into a values(1);
demo@127.0.0.1:26257/defaultdb OPEN> analyze a;
```
Jira issue: CRDB-22399
Guía de contribución
Evaluación
Este issue todavía no se ha evaluado.