cockroachdb / cockroachdb/cockroach
sql: infinite loop with recursive common table expression
Aperta
C-bug
O-pg-regress
T-sql-queries
- Lingua principale
- Go
- Stelle
- 32.5k
- Fork
- 4.1k
- Metriche di merge delle PR
- Metriche PR in attesa
Descrizione
The following query causes CockroachDB to loop forever delivering results to the client:
```
WITH RECURSIVE x (n) AS (SELECT 1 UNION ALL SELECT count(*) FROM x) SELECT * FROM x;
```
Postgres rejects this query outright:
```
jordan=# WITH RECURSIVE x (n) AS (SELECT 1 UNION ALL SELECT count(*) FROM x) SELECT * FROM x;
ERROR: aggregate functions are not allowed in a recursive query's recursive term
LINE 1: ...ITH RECURSIVE x (n) AS (SELECT 1 UNION ALL SELECT count(*) F...
```
Jira issue: CRDB-22287
Guida per i contributori
Apri la guida per i contributori
Valutazione
Questa issue non è ancora stata valutata.