cockroachdb / cockroachdb/cockroach

sql: window functions next to SRFs behave differently from Postgres

Abierto
#93,386 1 comentario 0 reacciones 0 asignados Ver en GitHub
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

Consider the following example query, minimized from a more complex one in the `tsrf.sql` pg_regress file:

```
SELECT a, lag(a) OVER(), count(*) OVER(), generate_series(1,2) FROM (select 1) as x(a);
```

CockroachDB evaluates this differently from Postgres. According to the pg_regress test case, this is because SRFs should be computed after window functions: `-- SRFs are normally computed after window functions`

CRDB
```
root@localhost:26257/defaultdb> SELECT a, lag(a) OVER(), count(*) OVER(), generate_series(1,2) FROM (select 1) as x(a);

a | lag | count | generate_series
----+------+-------+------------------
1 | NULL | 2 | 1
1 | 1 | 2 | 2
(2 rows)
```

PG
```
jordan=# SELECT a, lag(a) OVER(), count(*) OVER(), generate_series(1,2) FROM (select 1) as x(a);
a | lag | count | generate_series
---+-----+-------+-----------------
1 | | 1 | 1
1 | | 1 | 2
(2 rows)
```

Jira issue: CRDB-22398

Guía de contribución

Abrir la guía de contribución

Evaluación

Este issue todavía no se ha evaluado.

Recibe los nuevos issues en tu correo

Un resumen breve de issues de GitHub para principiantes.