[Libreoffice-bugs] [Bug 140713] Error if I do a Time query in LibreOffice Base [Critical]
bugzilla-daemon at bugs.documentfoundation.org
bugzilla-daemon at bugs.documentfoundation.org
Thu Sep 23 10:26:58 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=140713
--- Comment #5 from Alex Thurgood <iplaw67 at tuta.io> ---
No repro with
Version: 7.1.5.2 / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
1) Created an embedded Firebird ODB file (attached)
2) Manually created a table called "Timetable" in the GUI table editor
3) This table had 3 fields :
- an ID field (INT) autoincrement primary key
- a departure time field (HOUR/Time)
- an arrival time field (HOUR/Time)
4) Entered some sample data into the Timetable table
5) Created and saved a manual SQL query with a parameter, saved as
"DepartureLaterThan"
The query is as follows:
SELECT * FROM "Timetable" WHERE "departure" > :dep
6) Execute the query, enter a departure time, e.g. 07:30
7) Correct query results displayed - no error
--
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210923/3215fa1f/attachment.htm>
More information about the Libreoffice-bugs
mailing list