generate_series regression 9.6->10

From: Paul Ramsey <pramsey(at)cleverelephant(dot)ca>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: generate_series regression 9.6->10
Date: 2017-05-24 17:09:19
Message-ID: CACowWR0AMyUt5fwtvuDqWyYNdp-hQJj9XqSxJR6YM9sKWov=_w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The behaviour of generate_series seems to have changed a little, at least
in conjunction w/ CTEs. Under 9.6 (and prior) this query returns 2127 rows,
with no nulls:

with
ij as ( select i, j from generate_series(1, 10) i, generate_series(1, 10)
j),
iijj as (select generate_series(1, i) as a, generate_series(1, j) b from ij)
select a, b from iijj;

Under 10, it returns only 715 rows, with many nulls.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christoph Berg 2017-05-24 17:09:21 Re: 10beta1 sequence regression failure on sparc64
Previous Message Robert Haas 2017-05-24 15:12:12 Re: GSoC 2017: Foreign Key Arrays