Re: variation of row_number with parallel

2020-04-13 Thread Rajkumar Raghuwanshi
On Tue, Apr 14, 2020 at 9:39 AM Pavel Stehule wrote: > > > út 14. 4. 2020 v 5:59 odesílatel Rajkumar Raghuwanshi < > rajkumar.raghuwan...@enterprisedb.com> napsal: > >> Hi, >> >> I have observed row_number() is giving different results when query >> executed in parallel. is this expected w.r.t pa

Re: variation of row_number with parallel

2020-04-13 Thread Pavel Stehule
út 14. 4. 2020 v 5:59 odesílatel Rajkumar Raghuwanshi < rajkumar.raghuwan...@enterprisedb.com> napsal: > Hi, > > I have observed row_number() is giving different results when query > executed in parallel. is this expected w.r.t parallel execution. > > CREATE TABLE tbl1 (c1 INT) partition by list (

variation of row_number with parallel

2020-04-13 Thread Rajkumar Raghuwanshi
Hi, I have observed row_number() is giving different results when query executed in parallel. is this expected w.r.t parallel execution. CREATE TABLE tbl1 (c1 INT) partition by list (c1); CREATE TABLE tbl1_p1 partition of tbl1 FOR VALUES IN (10); CREATE TABLE tbl1_p2 partition of tbl1 FOR VALUES