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 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
Repro Arch Linux 64-bit, X11 Version: 24.2.0.0.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 Calc: threaded Built on 14 August 2023