Bug 125856 - FIREBIRD: MIGRATION: Parameters in queries aren't working
Summary: FIREBIRD: MIGRATION: Parameters in queries aren't working
Status: RESOLVED DUPLICATE of bug 117589
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.0.0.beta1+
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-11 13:50 UTC by Robert Großkopf
Modified: 2019-06-11 17:07 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Open the query "Abfrage_Locate_0" - parameter won't work (49.51 KB, application/vnd.oasis.opendocument.database)
2019-06-11 13:50 UTC, Robert Großkopf 		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 Robert Großkopf 2019-06-11 13:50:20 UTC 
Created attachment 152104 [details]
Open the query "Abfrage_Locate_0" - parameter won't work

Open the attached database.
Macros could be ignored - has nothing to do with macros.
Open the query "Abfrage_Locate_0".
You will be asked for a parameter for "Suchtext".
Write down "test" here and press OK.

An error appears:
*Column unknown
*SUCHTEXT

Expected behaviour: Parameters should work like they work with the internal HSQLDB.

All tested with 
Version: 6.3.0.0.beta1
Build-ID: a187af327633f5f00363be5131bd21a13e0f1a7b
CPU-Threads: 6; BS: Linux 4.12; UI-Render: Standard; VCL: gtk3; 
Gebietsschema: de-DE (de_DE.UTF-8); UI-Sprache: de-DE
Calc: threaded
Comment 1 Julien Nabet 2019-06-11 16:54:04 UTC 
Dup of tdf#117589
Comment 2 Julien Nabet 2019-06-11 16:54:36 UTC 
(In reply to Julien Nabet from comment #1)
> Dup of tdf#117589

Sorry, I forgot "?"
So would it be a dup?
Comment 3 Drew Jensen 2019-06-11 17:00:37 UTC 
(In reply to Julien Nabet from comment #2)
> (In reply to Julien Nabet from comment #1)
> > Dup of tdf#117589
> 
> Sorry, I forgot "?"
> So would it be a dup?

I would think it is a duplicate, given that if you replace the named parameter (:sometext) in the example query with "?" then it works as expected.
Comment 4 Drew Jensen 2019-06-11 17:07:18 UTC 
Also, creating a new Base file with firebird sdbc using 6.3 beta the named parameter function is working, so it is just the setting from migration that needs fixing it seems.

marking as duplicate.

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