<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:btomi96@gmail.com" title="Tamas Bunth <btomi96@gmail.com>"> <span class="fn">Tamas Bunth</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Base error after migrating to Firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120126">bug 120126</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Base error after migrating to Firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120126#c22">Comment # 22</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - Base error after migrating to Firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=120126">bug 120126</a>
from <span class="vcard"><a class="email" href="mailto:btomi96@gmail.com" title="Tamas Bunth <btomi96@gmail.com>"> <span class="fn">Tamas Bunth</span></a>
</span></b>
<pre>Hi,
(In reply to Tim from <a href="show_bug.cgi?id=120126#c13">comment #13</a>)
<span class="quote">> Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=145320" name="attach_145320" title="Base Database">attachment 145320</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=145320&action=edit" title="Base Database">[details]</a></span>
> 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'
> ------------------------</span >
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.
<span class="quote">>
> 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'</span >
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".</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>