https://bugs.freedesktop.org/show_bug.cgi?id=85707
Bug ID: 85707
Summary: NOT BETWEEN query not working when LibreOffice is in
Spanish
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Created attachment 108736
--> https://bugs.freedesktop.org/attachment.cgi?id=108736&action=edit
sample database
Hello, I want to report a severe bug that need to be fixed urgently.
The problem occur when designing a query in the design view.
If you put in criteria NOT BETWEEN, it won't work. However, if you change the
user interface to English, then NOT BETWEEN works fine.
This probably is happening due a bad programming, because when you use
LibreOffice in Spanish, it translate the operators, so LIKE is translated to
COMO and so on... (COMO = LIKE in Spanish).
I guess that there is a defective programming in NOT BETWEEN because when you
apply it in Spanish the result you get is this.
Exactly you get this error:
Estado de SQL: HY000
Código de error: 1000
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
The steps to reproduce the bug are as follows:
1. Start LibreOffice
2. Change the interface settings to Spanish, go to Tools... Options... Languaje
Settings... select for User interface: Spanish (Spain) select for Locale
setting: Spanish (Spain)
3. Open Base
4. Create a table with 2 fields for example: Name and Age, where Name is a TEXT
VARCHAR field and AGE is an INTEGER field.
5. Introduce some data... for example: John 20, Mike 10, David 12... etc. etc.
6. Finally, go to Queries and in the Design View add that table, drag and drop
the Age field and try to apply a NOT BETWEEN command in Criteria. You'll see it
is translated to NO ENTRE... when you run the query, you'll get for sure the
SQL error...
However if the Interface is set up as English USA and Locale Setting as English
USA you won't get the result and NOT BETWEEN work fine...
As a result of this very critical bug, any user from the Spanish community can
create queries using NOT BETWEEN
I ask please, for an urgent revision of this bug, people cannot work... because
they cannot filter data in queries...
Please, fix it.
I am attaching also a sample database if you want to make some tests
Please, remember always to set up the user interface and locale settings to
Spanish (Spain)
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
