https://bugs.documentfoundation.org/show_bug.cgi?id=120126
Tamas Bunth <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Resolution|--- |NOTABUG
Status|NEW |RESOLVED
--- Comment #22 from Tamas Bunth <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
