Limit - New Database feature

[Lionel Elie Mamane]

On Tue, Jun 11, 2013 at 08:53:36AM +0200, Thomas Hackert wrote:
> On Montag, 10. Juni 2013 21:06 Zolnai Tamás wrote:
> thanks, Alex, to bringing my problem to this list :)

> > Thanks for the note. I looked up the thread on german discuss
> > list. The problem is not that "doesn't insert the required WHERE
> > clause before the LIMIT" (it sounds like adding a criteria on GUI
> > and this criteria not inserted into the select statement before
> > the limit clause while running), but hsqldb does not support
> > queries like "select * from table limit y". In hsqldb's concept we
> > have to use a WHERE or an ORDER BY clause before LIMIT or at least
> > a Table alias.

> But should this not be mentioned in the help to "SQL;LIMIT clause"

No, please don't document work-arounds to HSQLDB limitations /
unexpected disambiguation, especially since we can work around it in
code automatically here.

-- 
Lionel