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 _______________________________________________ LibreOffice mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice
