[Libreoffice-bugs] [Bug 127299] New: base crashes if like query has blank in parameter

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 127299
           Summary: base crashes if like query has blank in parameter
           Product: LibreOffice
           Version: 6.3.0.4 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cwaynedavis at gmail.com

Description:
I'm getting a crash whenever the parameter to a query has a space in it. A
simplified version of the query is:

SELECT * FROM "My_Table" WHERE ( UPPER ( "Title" ) LIKE UPPER ( '%' || ? || '%'
) )

This works fine if the parameter has no spaces but with spaces there's about a
45 second hang followed by a crash. I looked for debug log options but couldn't
find any. Also couldn't see the crash report when I chose to send one. Also
couldn't append any info to the crash report so doubt that it's useful to
developers without knowing what triggered the crash. The Windows application
log just showed that soffice.bin crashed.

The table is very simple, one key integer ID field with autovalues and 6
varchar text fields. There are currently only 540 records in the table. The
"Title" field used in the simplified query has no null entries and no non ascii
characters that I know of.

Steps to Reproduce:
1.  Use any test table with a varchar field (not verified against any other
table).
2. Create query similar to "SELECT * FROM "My_Table" WHERE ( UPPER ( "Title" )
LIKE UPPER ( '%' || ? || '%' ) )" where "Title" field is varchar.
2.  Run query, entering parameter with spaces, ex. "xxx yyy" without the
quotes. Bug will not happen if parameter is in quotes or if blanks are replaced
with _.

Actual Results:
Do it.

Expected Results:
~45 second freeze followed by crash.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Returned query results.

Version: 6.3.0.4 (x64)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

-- 
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/20190902/bc3b2aef/attachment-0001.html>