https://bugs.documentfoundation.org/show_bug.cgi?id=146757
Bug ID: 146757
Summary: Embedded Firebird ignores parameterized query input
(macOS Arm)
Product: LibreOffice
Version: 7.3.0.1 rc
Hardware: All
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
A simple embedded Firebird database file containing a table with time defined
fields is attached to this report.
Open the ODB file in LO Base.
Open the query "DepartureLaterThan"
Enter a time in the "dep" parameter field, e.g. 08:00
Press OK
The resulting grid view should display all entries with a departure time later
than 08:00 hours.
This parameterized query works correctly on
Version: 7.2.5.2 / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 8; OS: Mac OS X 12.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
However, when testing with
Version: 7.3.0.1 / LibreOffice Community
Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d
CPU threads: 8; OS: Mac OS X 12.1; UI render: Skia/Metal; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
The query fails completely, and instead displays all of the results in the
table on which the query operates.
The second query in the test ODB file contains no parameter, but rather a
direct value in the SQL against which to compare - this query executes
correctly and displays the correct resultset.
Steps to Reproduce:
See description above
Actual Results:
The parameter is ignored when executing the query on macOS Arm version.
Expected Results:
The parameter should execute/be parsed normally and return a resultset in
accordance with the parameter provided.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.3.0.1 / LibreOffice Community
Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d
CPU threads: 8; OS: Mac OS X 12.1; UI render: Skia/Metal; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
