[Libreoffice-bugs] [Bug 140713] New: Error if I do a Time query in LibreOffice Base [Critical]

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140713

            Bug ID: 140713
           Summary: Error if I do a Time query in LibreOffice Base
                    [Critical]
           Product: LibreOffice
           Version: 7.1.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: faizanrizwan1 at gmail.com

Description:
I created a table in which I wanted to find the records which have a Departure
Time more than 10:00:00. When I try that in LibreOffice Base Query Editor I
enter: > '10:00:00: in the criterion, but when I ran the query it gave me this
error:

firebird_sdbc error:
*conversion error from string "10:00:00.000000000"
caused by
'isc_dsql_fetch'

This is the SQL for it:

SELECT "Flight number" FROM "Table1" WHERE "Notes" = 'Passengers only' AND
"Departure time" > '10:00:00.000000000'

See, the problem here is that Base is automatically adding trailer zeros in
front of the time I have specified. 

Please fix this. There shouldn't be such a big in such a simple thing.

Steps to Reproduce:
1. Make a field and sets its data type as "Time"
2. Fill in some time values for the database.
3.Make a query in which you compare the times, e.g. finding the record which
has the time more than 10:00.

Actual Results:
SELECT "Flight number" FROM "Table1" WHERE "Notes" = 'Passengers only' AND
"Departure time" > '10:00:00.000000000'

Expected Results:
It should have found the single record which satisfied the criterion.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.1.0.3 (x64) / LibreOffice Community
Build ID: f6099ecf3d29644b5008cc8f48f42f4a40986e4c
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_US); UI: en-GB
Calc: CL

-- 
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/20210228/515d38b3/attachment.htm>