Bug 122515 - Firebird: Parameters cannot be used in query
Summary: Firebird: Parameters cannot be used in query
Status: RESOLVED DUPLICATE of bug 117589
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.0.1 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-01-06 09:05 UTC by Helmut Leininger
Modified: 2019-01-06 17:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Embedded Firebird DB, migrated from HSQLDB (1.01 MB, application/vnd.sun.xml.base)
2019-01-06 09:05 UTC, Helmut Leininger 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Helmut Leininger 2019-01-06 09:05:05 UTC 
Created attachment 148069 [details]
Embedded Firebird DB, migrated from HSQLDB

Version: 6.2.0.1 (x64)
Build-ID: 0412ee99e862f384c1106d0841a950c4cfaa9df1
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; VCL: win; 
Gebietsschema: de-AT (de_AT); UI-Sprache: de-DE
Calc: threaded

When using parameters for a query an SQL error "column unknown" for the parameter is issued.

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -206
*Column unknown
*VORNAME
*At line 1, column 163
caused by
'isc_dsql_prepare'

Steps to reproduce:
1) open the database
2) select query "Name und Vorname"
3) fill in some values and hit Ok
Comment 1 Drew Jensen 2019-01-06 17:08:43 UTC 
This is known issue with the migration assistant.

The workaround (fix) is simple enough however and details on that are contained in the comments of the earlier issue (referenced here)

*** This bug has been marked as a duplicate of bug 117589 ***