https://bugs.documentfoundation.org/show_bug.cgi?id=155751
Bug ID: 155751
Summary: dBase: BETWEEN won't include first and last value in
queries
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 187802
--> https://bugs.documentfoundation.org/attachment.cgi?id=187802&action=edit
Extract the *.zip and start the database file …
Download the attached *.zip-file.
Extract and start the database file. Hope the connection to the dBase-file will
work.
Start the query.
It will show "ID" starting with 2, ending with 9.
Close the query, open the query for editing (will only work opening in
SQL-mode).
Have a look at the code:
SELECT "ID" FROM "table" WHERE "ID" BETWEEN '1' AND '10'
BETWEEN should start with '1' and end with '10'.
If you execute BETWEEN in internal HSQLDB and Firebird it will do so.
For dBase connections it will exclude start value and end value.
BETWEEN should give the same result as
SELECT "ID" FROM "table" WHERE "ID" >= 1 AND "ID" <= 10
This bug appears on all LO-versions here (oldest here: LO 5.1.5.2). It appears
also on AOO 4.1.8. Think it has been inherited from OOo.
See also:
https://ask.libreoffice.org/t/base-query-not-reading-table-with-between-statement/92299
--
You are receiving this mail because:
You are the assignee for the bug.
