[Libreoffice-bugs] [Bug 120187] New: Error message handling checkbox criterion building Query in Design View

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 120187
           Summary: Error message handling checkbox criterion building
                    Query in Design View
           Product: LibreOffice
           Version: 6.1.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: zoomer1 at gmx.com

Description:
I want to emphasize that this works in Ubuntu, but not in Windows 8.1 x64.
Say I have a checkbox field in my table called Cancelled.  I want the query to
list all the cancelled items.  I put a "1" or "=1" in the criterion in the
Cancelled column.
I get the following error message:
 The data content could not be loaded

firebird_sdbc error:
*Dynamic SQL Error
*SQL error code = -104
*Invalid usage of boolean expression
caused by
'isc_dsql_prepare'
Yet it works in Ubuntu.  I have no idea what the error message means.

Steps to Reproduce:
1.Set up query in design mode.
2.Put "1" 0r "=1" in Criterion for Cancelled (Boolean) field.
3.Run Query.

Actual Results:
I got the error message listed above.

Expected Results:
I expected the query to run and give me a list of cancelled items.
It does this in the Ubuntu version.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 6.1.2.1 (x64)
Build ID: 65905a128db06ba48db947242809d14d3f9a93fe
CPU threads: 8; OS: Windows 6.3; UI render: default; 
Locale: en-CA (en_CA); Calc: CL

-- 
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/20180928/fcc5ee3d/attachment.html>