This is a limit-offset bug?
От
Emanuel Calvo Franco
Тема
This is a limit-offset bug?
Дата
Msg-id
f205bb120812260352l64e4e338vfd5029e3626ef7ab@mail.gmail.com
Список
Дерево обсуждения
This is a limit-offset bug? "Emanuel Calvo Franco" <postgres.arg@gmail.com>
Re: This is a limit-offset bug? Martijn van Oosterhout <kleptog@svana.org>
Re: This is a limit-offset bug? "Emanuel Calvo Franco" <postgres.arg@gmail.com>
Hi people,
Yesterday when i was making some commands on 8.3.5
(on Centos)
i found a rare behavior of limit offset.
Try in psql:
select * from foo limit 3; <- shows ok
select * from foo limit3; <- shows all rows
select * from foo offset1223raf3w4t4tgga; <- shows all rows
select * from foo limitsdfsdfaerfgsafqaweawe; <- shows all rows
select * from foo limit; <- this shows error ok
select * from foo limitt; ....
All the chars inmediatly continue the limit or offset commands
are ignored.
If this kind of problems there isn't a bug, sorry.
--
Emanuel Calvo Franco
Syscope Postgresql Consultant
ArPUG / AOSUG Member
В списке pgsql-general по дате отправления
От: Emanuel Calvo Franco
Дата: