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

            Bug ID: 166329
           Summary: Creating a user entry variable in a query results in
                    an error. This worked on HSQLDB but fails after having
                    converted to firebird embedded
           Product: LibreOffice
           Version: 25.2.2.2 release
          Hardware: x86-64 (AMD64)
                OS: macOS (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: [email protected]
          Reporter: [email protected]

Description:
When using a user entry field for a filter criteria results in a failure (i.e
using :InputField). Th parameter entry box is displayed, but then fails with
the following:

The data content could not be loaded
firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*INPUTFIELD
*At line 1, column 944
caused by
'isc_dsql_prepare'

This worked when the database was HSQLDB but now fails after converting to
firebird embedded.

Filter works when entering text in the criterion field

Steps to Reproduce:
1. entering a user input (i.e. :InputField) in the "Criterion" field on the
query consistency produces the above error
2.
3.

Actual Results:
error as above

Expected Results:
query should execute as documented


Reproducible: Always


User Profile Reset: Yes

Additional Info:
None, failure as described above

Version: 25.2.2.2 (AARCH64) / LibreOffice Community
Build ID: 7370d4be9e3cf6031a51beef54ff3bda878e3fac
CPU threads: 8; OS: macOS 15.5; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to