Обсуждение: [pgAdmin4] Invalid field order in "Data Output"

Hi,

When I execute query like this:
   SELECT generate_series(0, 999)   ORDER BY 1 ASC;

On first page I see rows 0-49, on second page 999-950 descending!,
last - 99-50 descending!

Should be:
- first page 0-49
- second 50-99
- next 100-149
- etc.
- page number 20: 950-999

Tested on:
- Fedora 24 x64 (commit 035066bd; Tue, 9 Aug 2016 15:23:24),
PostgreSQL 9.2, 9.3, 9.5
- Windows 7 x64; Pgadmin4 1.0-beta3; PostgreSQL 9.6beta4


Regards,
Krzysztof Otręba

On 8/12/16 at 7:51 AM, Krzysztof Otręba wrote:

>Hi,
>
>When I execute query like this:
>
>SELECT generate_series(0, 999)
>ORDER BY 1 ASC;
>
>On first page I see rows 0-49, on second page 999-950 descending!,
>last - 99-50 descending!
>
>Should be:
>- first page 0-49
>- second 50-99
>- next 100-149
>- etc.
>- page number 20: 950-999
>
>Tested on:
>- Fedora 24 x64 (commit 035066bd; Tue, 9 Aug 2016 15:23:24),
>PostgreSQL 9.2, 9.3, 9.5
>- Windows 7 x64; Pgadmin4 1.0-beta3; PostgreSQL 9.6beta4
>
>
>Regards,
>Krzysztof Otręba
>
>
Ditto, and similar ordering problems also happen when the
underlying field type is text derived from a table as opposed to
a generated numeric sequence.

PostgreSQL 9.4.5 on x86_64-apple-darwin
OSX 10.11.6

Regards
Gavan Schneider