[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