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@lists.freedesktop.org
Reporter: cwayneda...@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._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
