cockroachdb / cockroachdb/cockroach
sql: infinite loop with recursive common table expression
Ouverte
C-bug
O-pg-regress
T-sql-queries
- Langage dominant
- Go
- Étoiles
- 32.5k
- Forks
- 4.1k
- Métriques de merge des PR
- Métriques de PR en attente
Description
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
Guide de contribution
Ouvrir le guide de contribution
Évaluation
Cette issue n'a pas encore été évaluée.