Re: [MonetDB-users] offset support?

27 Nov 2007

      On Nov 27, 2007 2:33 PM, Niels Nes  wrote:
...
On Tue, Nov 27, 2007 at 11:52:23AM -0700, m h wrote:
...
On Nov 26, 2007 10:51 AM, m h  wrote:
...
On Nov 26, 2007 10:47 AM, Fabian Groffen  wrote:
...
On 26-11-2007 10:40:53 -0700, m h wrote:
...
Is there support for OFFSET in queries?
It used to be there.  Have you tried select bla offset 2 limit 3 instead
already?
You mean this?
sql>SELECT query_users.user_id, query_users.user_name
more>FROM query_users ORDER BY query_users.user_id
more>OFFSET 2 LIMIT 3 ;
!syntax error, unexpected LIMIT, expecting INTERSECT or EXCEPT or
UNION in: "select query_users.user_id, query_users.user_name
!from query_users order by query_users.user_id
!offset 2 limit"
Timer     892.177 msec 0 rows
It appears that the "ORDER BY" is throwing things off.  Bug?
This bug is fixed now. Both the case with and with out order by gave
wrong results. It needed some work in the optimizer which was push 'renumber'
statements down the tree which doesn't work with offsets.
(only available from cvs tho).
WOW!

That was quick.

Thanks much