[Libreoffice-bugs] [Bug 123150] FIREBIRD: Query with 'LIKE' fails with error "malformed string", when index is set for the field of the condition of the query

[bugzilla-daemon at bugs.documentfoundation.org]

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

Xisco Faulí <xiscofauli at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |xiscofauli at libreoffice.org

--- Comment #27 from Xisco Faulí <xiscofauli at libreoffice.org> ---
(In reply to Gerhard Schaber from comment #16)
> You might be right. I tried with FB 3.0.4.
> 
> Fails with malformed string:
> select * from "table1" where "LastName" LIKE 'Ö%';
> 
> Works:
> select * from "table1" where "LastName" LIKE UPPER(_iso8859_1 'Ö%');

I do confirm this issue is fixed in

Version: 6.4.0.0.alpha0+
Build ID: ed2107f0488887528d8e49135d3270705f389ed5
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US
Calc: threaded

when selecting 'Show output"

-- 
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/20190715/59b4bfae/attachment.html>