Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql
Date
Msg-id 643125.1666877086@sss.pgh.pa.us
Whole thread Raw
In response to [PROPOSAL] : Use of ORDER BY clause in insert.sql  (Nishant Sharma <nishant.sharma@enterprisedb.com>)
Responses Re: [PROPOSAL] : Use of ORDER BY clause in insert.sql  (Amul Sul <sulamul@gmail.com>)
List pgsql-hackers
Nishant Sharma <nishant.sharma@enterprisedb.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



pgsql-hackers by date:

Previous
From: Zhang Mingli
Date:
Subject: Re: Reducing duplicativeness of EquivalenceClass-derived clauses
Next
From: Tom Lane
Date:
Subject: Re: Reducing duplicativeness of EquivalenceClass-derived clauses