Limit+Offset query wrong result in Postgres 9.0.3 ?

From: urkpostenardr <urkpostenardr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Limit+Offset query wrong result in Postgres 9.0.3 ?
Date: 2012-10-12 02:55:33
Message-ID: CAELx_2MChX7HJZgKcYWOoSp0az00iad8sCmzfx2gv5jRh-pKGw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is this bug in Postgres ?
If yes, is it fixed in latest release ?
Second query should return 2 rows instead of 1 ?

create table t(i int);
insert into t values(1);
insert into t values(2);
insert into t values(3);
pgdb=# select i from t order by i limit 9223372036854775806 offset 1;
select i from t order by i limit 9223372036854775806 offset 1;
i
2
3
(2 rows)
pgdb=# select i from t order by i limit 9223372036854775807 offset 1;
select i from t order by i limit 9223372036854775807 offset 1;
i
2
(1 row)
pgdb=#

My server Version is postgres (PostgreSQL) 9.0.3

Thanks in advance!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2012-10-12 03:30:27 Re: Expensive log_line_prefix ?
Previous Message Raghavendra 2012-10-12 02:41:24 Re: Postgres DB Migration from 8.3 to 9.1