<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Base Firebird: Query broken when "Save", but not with "Save As""
href="https://bugs.documentfoundation.org/show_bug.cgi?id=122811">122811</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Base Firebird: Query broken when "Save", but not with "Save As"
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>p_mirowsky@bentaxna.com
</td>
</tr></table>
<p>
<div>
<pre>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 <a href="mailto:users@global.libreoffice.org">users@global.libreoffice.org</a>
The information supplied is based on questions and answers there.</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>