On 10/03/2014 11:24 PM, Peter Goggin wrote:
While working through the documentation I appear to have found a problem.
The following query works:
SELECT "ID", "Title", "Pub_Year" FROM "Media"
It returns 8 rows.
The following query fails
SELECT "ID", "Title", "Pub_Year" FROM "Media" LIMIT 5
The error complains about 5 being an unexpected token.
I created the query in both design and sql view and get the same
result. I repeated with several tables and got the same result and
problem.
I found that if I used sort on a field then no matter where I created
the query (design or sql mode it worked)
The documentation implies that this is a problem from earlier versions
of the data base, prior to 4.1. and also the limit could only be set
in direct SQL mode. I can set the limit in both modes but as stated
an order field condition is rquired.My version is the one from the
ubuntu repository and claims to be version libreoffice-base
1:4.2.6.3-0ubuntu1. I presume this means it is 4.2.6.3 and therefore
should not have the LIMIT limitation.
If I need to load a later version of the data base where do I get it
from?
If this problem is a bug where do I report it?
Regards
Peter Goggin
I ran the same query without any problem using 4.2.6.3 that I
downloaded from the LibreOffice web site. I also use Ubuntu as my OS
(12.04) so yours should have worked.
A couple of possible problems though:
1) Did you download Media_with_Macros.odb or Media_without_Media.odb
and run create the query in one of these, or did you use the database
you created? (If the latter, there might be a problem with your
database.)
2) The LibreOffice distributed by Ubuntu has been modified from the
version distributed on the LibreOffice web site. This error could be caused
by a bug introduced by the modification process. This has been
known to happen down through the years and has happened in a variety of
distributions of Linux.
For #1, you should download the English version of the database
file mentioned in the Query chapter. (It probably does not matter which
one.) Create and run the query. If you still get the error, the problem
is with the Ubuntu version of LibreOffice.
For #2, I always remove the Ubuntu version of LibreOfficeusing
Synaptic first when I install a newer version of Ubuntu. Then I download
and install the versions including the help packs that I want from the
LibreOffice web site. The menu will only show the Ubuntu version unless
you do it in this order. Once the Ubuntu version is deleted, all version
installed from the LibreOffice web site appear in the menu.
Right now I have LibreOffice 4.2.6.3 and 4.3.2.2 installed, and I
use both versions for a variety of purposes including testing them for
how Base works in both of them. Specifically, I can check the problem
you have had with both versions or even 4.2.7.1.
Dan
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/documentation/
All messages sent to this list will be publicly archived and cannot be deleted
