@Tim please provide us with a test ODB so that we can try and reproduce the problem.

I think it happens when in the query I have in one column File.* and also in another column the Field "Población" with sort or a criterion, but it only seems to happen with that Field!

Just for the test, would it be possible you change field name and remove the accent?
The goal is to know if it's an encoding pb.

Created attachment 145191 [details]
This Query works ok with "Población" field.

After this I'll send a similar Query where "Población" gives error.

Created attachment 145192 [details]
This one very similar to the previous doesn't work

AND YES! If I change "Población" field to "Poblacion", without accent, the one that didn't run works...!!!

And now I've changed the field back to "Población", with accent, and the Query works!

(In reply to Tim from comment #7)
> And now I've changed the field back to "Población", with accent, and the
> Query works!

It shows thqt the only pb is migration part which doesn’t take account encoding here.
Tamas: thought you might be interested in this one

Thanks!

Now in another Query with the same error, even if I delete and afterwards add again the field, keeps on giving the error!

It looks like as if something remains somewhere?

And again! If a change the Field name without accent, the Query works. Then I go back and put the Field with accent and the Query works!

It looks likes there is something behind...? It's not enough to delete the Column in the Query and pin up again the Field in a new column.

If I make a new Query exactly with the same fields, conditions..., it works ok!

Could you please attach an example ODB file with which the issue can be reproduced? (following the "Steps to Reproduce" part of the bug description)

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'
------------------------

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'

Putting this to NEW.
@Tim, do you also have the original ddbb before the migration ?

Created attachment 145480 [details]
ddbb before migrating

This is one of the errors after migrating:

SELECT "Iglesias".*, "Iglesias"."País" FROM "Iglesias" "Iglesias" WHERE "País" <> 'España' ORDER BY "País" ASC

It works if a put:
SELECT * FROM "Iglesias" WHERE "País" <> 'España' ORDER BY "País" ASC

On pc Debian x86-64 with master sources updated today, I tried to reproduce this.

I had this during Firebird migration:
Error code: 1

firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Iglesias failed
*Unknown columns in index SYS_FK_78
caused by
'ALTER TABLE "Iglesias" ADD CONSTRAINT SYS_FK_78 FOREIGN KEY("Denominaci\u00f3n") REFERENCES "Denominaciones"("ID")'

Then indeed I could reproduce the pb by trying "Iglesias_Coruña_Prov" query.

May be; but as "Denominación" was changed to "Denominaci\u00f3n" I had to then rename to have it right, and because in another case the name exceeded length permiten as it puts in more digits!

(In reply to Tim from comment #18)
> because in another case the name exceeded
> length permiten as it puts in more digits!

That behaviour is bug 116987 (field, table, or query name more than 30 chars)

The conversion of non-ASCII chars to a unicode equivalent and the placing of that unicode string instead of the original character is already known as bug (which I can't find at the moment), so in that regard, this report would be a duplicate of that bug.

I have created bug 121069, which may be the same as this bug but
showing up differently and earlier on Linux.

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".

(In reply to Tim from comment #6)
> AND YES! If I change "Población" field to "Poblacion", without accent, the
> one that didn't run works...!!!

This issue is already addressed here:
https://bugs.documentfoundation.org/show_bug.cgi?id=121469

and here:
https://bugs.documentfoundation.org/show_bug.cgi?id=121069