[Libreoffice-bugs] [Bug 122811] New: Base Firebird: Query broken when "Save", but not with "Save As"

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122811
           Summary: Base Firebird: Query broken when "Save", but not with
                    "Save As"
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: p_mirowsky at bentaxna.com

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 at global.libreoffice.org
The information supplied is based on questions and answers there.

-- 
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/20190118/41e2f318/attachment-0001.html>