[Libreoffice-bugs] [Bug 120126] Base error after migrating to Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

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

Tamas Bunth <btomi96 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED

--- Comment #22 from Tamas Bunth <btomi96 at gmail.com> ---
Hi,

(In reply to Tim from comment #13)
> Created attachment 145320 [details]
> Base Database
> 
> Executing the following queries within the data base I get the errors...
> 
> AAHH_Ga_Consello
> 
> firebird_sdbc error:
> *Dynamic SQL Error
> *SQL error code = -104
> *Invalid usage of boolean expression caused by 'isc_dsql_prepare'
> ------------------------

That is because the query named AAHH_Ga_Consello tries to compare a BOOLEAN
type with a number (Firebird uses BYTE for the literal '-1' to be exact).

That is not allowed using Firebird. It seems to be allowed with HSQLDB, but it
seems to be undocumented.

I think there is nothing to fix here.

> 
> Ctas_CoAhEs_50_Dat
> Ctas_CoAhEs_51-100_Dat
> Ctas_CoAhEs_101_Dat
> Ctas_CoAhEs_NO_Dat
> Iglesias_Coruña_Prov
> Iglesias_Galicia
> 
> firebird_sdbc error:
> *Dynamic SQL Error
> *SQL error code = -204
> *Ambiguous field name between a field and a field in the select list with
> name
> *Población caused by 'isc_dsql_prepare'
> ----------------------------------------
> 
> Iglesias_Extranjero
> 
> firebird_sdbc error:
> *Dynamic SQL Error
> *SQL error code = -204
> *Ambiguous field name between a field and a field in the select list with
> name
> *País caused by 'isc_dsql_prepare'

You have queried the column named 'País' twice here. Once with 'Iglesias.*' and
you also queried it explicitly.

After that the criterion "<> 'España'" results in ambigousity, because the DBMS
cannot determine which 'País' field is referenced.

Based on the comments above, I closed the bug as "NOTABUG".

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190131/c9603a2f/attachment.html>