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.
There is of course a simple work around. When I enter the query and replace spaces with _ it works. Incidentially, the documentation I found still showed :param instead of ?. That gave me a lot of fun. Another aside, I had planned on improving my comparison by using Difference(). I had it all worked out when I found that Firebird doesn’t support the Difference function.
This is a trivial application of course. I’m a retired software engineer playing around to fight boredom.
Thank you,
Wayne