Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Nishant Sharma <nishant(dot)sharma(at)enterprisedb(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql
Date: 2022-10-27 13:24:46
Message-ID: 643125.1666877086@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Nishant Sharma <nishant(dot)sharma(at)enterprisedb(dot)com> writes:
> We would like to share a proposal of a patch, where we have added order by
> clause in two select statements in src/test/regress/sql/insert.sql file and
> respective changes in src/test/regress/expected/insert.out output file.

> This would help in generating output in consistent sequence, as sometimes
> we have observed change in sequence in output.

Please be specific about the circumstances in which the output is
unstable for you. With zero information to go on, it seems about as
likely that this change is masking a bug as that it's a good idea.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2022-10-27 13:29:02 Re: Reducing duplicativeness of EquivalenceClass-derived clauses
Previous Message Zhang Mingli 2022-10-27 13:21:17 Re: Reducing duplicativeness of EquivalenceClass-derived clauses