Description:
Opening the "2 Amps to Volts-High by Series"
    By main "Queries", right click and choose "Edit"
        In view, changed 134 to '134'
            Message: Warning    The entered criterion cannot be compared with this field.
        Remove 134 from Series and hit enter.
            <Edit><Run Query> results in all records
        Add 134 to Series and hit enter.
            <Edit><Run Query> results in just 134 Series records.
        Query Design <Save >
    Double left click on query name "2 Amps to Volts-High by Series"
        Message: The data content could not be loaded.
                        Error code: 1
      <More>       firebird_sdbc error:
                        *Dynamic SQL Error
                        *SQL error code = -104
                        *Invalid usage of boolean expression
                        caused by
                        'isc_dsql_prepare'

By main "Queries", right click and choose "Edit in SQL view..."
        Remove AND "Amps"."Series" = '134'
            <Edit><Run Query> results in all records
        Add AND "Amps"."Series" = '134'
            <Edit><Run Query> results in just 134 Series records.
        Remove Add AND "Amps"."Series" = '134' and add Add AND "Amps"."Series" = 134
            <Edit><Run Query> results in just 134 Series records.
Saved the query in multiple states
When ever I save the Query and double left click from main Query window on "2 Amps to Volts-High by Series"
    Results in error message:
        <More>       firebird_sdbc error:
                            *Dynamic SQL Error
                            *SQL error code = -104
                            *Invalid usage of boolean expression
                            caused by
                            'isc_dsql_prepare'

In effect, in either edit mode it works correctly.
The saved query always fails.
However, when query is "Save As" it works correctly with newly named query.

Steps to Reproduce:
There seems to be something wrong in the saved query, which isn't shown
while editing the query.

For other users:
1. I have tested to execute the query.
2. Execution fails.
3. I opened the query in design-view.
4. I executed the query.
5. Execution works.
...
This is the problem, what nobody could understand ...

6. I changed something in the query (removed "Equipment"."Series" = 134
) and saved the query.
7. Closed the design-view.
8. Execution fails.
...
Then I opened the query, added the removed part again, saved ...
All the same.

...But when I open the query and save the query with a new name the
query will be saved with this new name and could be executed. So I
created, for example
"12 Amps to Volts-High by Series"
and it works.

Actual Results:

...But when I open the query and save the query with a new name the
query will be saved with this new name and could be executed. So I
created, for example
"12 Amps to Volts-High by Series"
and it works.

Expected Results:
Query "Saved" should work.


Reproducible: Always


User Profile Reset: No



Additional Info:
This was issue was originally raised on users@global.libreoffice.org
The information supplied is based on questions and answers there.