From: | Cyril Champier <cyril(dot)champier(at)doctolib(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Default ordering option |
Date: | 2019-07-23 15:43:01 |
Message-ID: | CAJaA8VcZCkBZeEMt45g-YR7c6ScHbB3PNURt6Z7AWZuuvX5umA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
In this documentation
<https://www.postgresql.org/docs/9.1/queries-order.html>, it is said:
> If sorting is not chosen, the rows will be returned in an unspecified
> order. The actual order in that case will depend on the scan and join plan
> types and the order on disk, but it must not be relied on.
I would like to know if there is any way to change that to have a "real"
random behaviour.
My use case:
At Doctolib, we do a lot of automatic tests.
Sometimes, people forgot to order their queries. Most of the time, there is
no real problem on production. Let say, we display a user list without
order.
When a developer writes a test for this feature, he will create 2 users A
and B, then assert that they are displayed "[A, B]".
99% of the time the test will be ok, but sometimes, the displayed list will
be "[B,A]", and the test will fail.
One solution could be to ensure random order with an even distribution, so
that such failing test would be detected quicker.
Is that possible? Maybe with a plugin?
Thanks,
Cyril
From | Date | Subject | |
---|---|---|---|
Next Message | Perumal Raj | 2019-07-23 16:03:54 | Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6 |
Previous Message | Perumal Raj | 2019-07-23 14:51:57 | Re: pg_upgrade : 9.X to 11.X issue CentoOS 7.6 |