Re: [MonetDB-users] offset support?

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). Niels

------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl