cockroachdb / cockroachdb/cockroach
sql: infinite loop with recursive common table expression
オープン
C-bug
O-pg-regress
T-sql-queries
- 主要言語
- Go
- スター
- 32.5k
- フォーク
- 4.1k
- PR マージ指標
- PR 指標を取得中
説明
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
コントリビューションガイド
評価
この issue はまだ評価されていません。