[HACKERS] generate_series regression 9.6->10 - Mailing list pgsql-hackers

From Paul Ramsey
Subject [HACKERS] generate_series regression 9.6->10
Date
Msg-id CACowWR0AMyUt5fwtvuDqWyYNdp-hQJj9XqSxJR6YM9sKWov=_w@mail.gmail.com
Whole thread Raw
Responses Re: [HACKERS] generate_series regression 9.6->10  (Andres Freund <andres@anarazel.de>)
Re: [HACKERS] generate_series regression 9.6->10  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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. 

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] GSoC 2017: Foreign Key Arrays
Next
From: Christoph Berg
Date:
Subject: Re: [HACKERS] 10beta1 sequence regression failure on sparc64