Created attachment 187802 [details]
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 220.127.116.11). It appears also on AOO 4.1.8. Think it has been inherited from OOo.
Arch Linux 64-bit, X11
Version: 18.104.22.168.alpha0+ (X86_64) / LibreOffice Community
Build ID: 518fa99dd7693d64a53e404a065090aedc0002b1
CPU threads: 8; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Built on 14 August 2023