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.