Bug 128765 - Query Error caused by isc_dsql_prepare
Summary: Query Error caused by isc_dsql_prepare
Status: RESOLVED DUPLICATE of bug 117503
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
5.3 all versions
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-11-13 08:03 UTC by pTux
Modified: 2019-11-13 11:30 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description pTux 2019-11-13 08:03:39 UTC
Description:
I use LO 6.3.3.2.0+ (Build 2). When I try to execute a query, i receive the error message below: 

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

The Query: 
SELECT "Contatti"."Cognome" FROM "Contatti" WHERE "Cognome" LIKE '%' || :Cerca || '%'

Steps to Reproduce:
1. Open Database
2. Execute Query
3. Insert criteria

Actual Results:
I receive the reported error message.

Expected Results:
I expect to read the query output.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Versione: 6.3.3.2.0+
Build ID: 30(Build:2)
Thread CPU: 2; SO: Linux 5.3; Resa interfaccia: predefinito; VCL: gtk3; 
Versione locale: it-IT (it_IT.UTF-8); Lingua interfaccia: it-IT
Calc: threaded
Comment 1 pTux 2019-11-13 08:10:51 UTC
A similar bug was reported for forms: https://bugs.documentfoundation.org/show_bug.cgi?id=117053#c12
Comment 2 Alex Thurgood 2019-11-13 11:30:33 UTC
pTux : if you created your ODB file with an earlier version of LibreOffice, then your report is probably a DUP of bug 117503, in which case you should either create a new one in 6.3, and drag and drop your tables, forms, queries, reports, etc from the old to the new and save, or else run the macro within your ODB document that is to be found in comment 15 of bug 117503.

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