Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


Hi Alex,

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.

In case of mysql, Base appends a table alias automatically to the select
statement (read on the german list). I don't sure this appending's aim is
to avoid this problem or not, but can use for hsqldb too.

Lionel,
I found a driver property with name "AppendTableAliasInSelect" which seems
to be responsible for appending alias. It is used only in generating
statement in QueryDesignView.cxx, so I think it can be used wihtout any
problem. I can't test whether it works yet, I'm compiling by now, but it
seems to me it works as its name suggests. So if you don't have any
objection to it or don't have a better solution than I solve the problem in
this way.


Best regards,
Tamás

2013/6/10 Alexander Thurgood <alex.thurgood@gmail.com>

Le 19/01/13 03:46, Lionel Elie Mamane a écrit :

Hi all,

FYI, there is a report/discussion on the German discuss list that this
functionality fails with hsqldb embedded databases and current 4.1 beta2
because it doesn't insert the required WHERE clause before the LIMIT
operator.

The functionality is reported to work correctly with a msyql db.


Alex


_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice


Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.