https://bugs.freedesktop.org/show_bug.cgi?id=57985
pierre-yves samyn <pierre-yves.sa...@laposte.net> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pierre-yves.samyn@laposte.n | |et --- Comment #5 from pierre-yves samyn <pierre-yves.sa...@laposte.net> --- Hello Well, for me it is not a bug. (In reply to comment #0) > My issue is that I need a way to force > comparisons to be case-insensitive, and apparently specifying the column > type isn't sufficient... Yes it is : > The SQL statement > update "Text1" "T1" set "Target"=(select "Col2" from "Text2" "T2" where > T1."Col1"=T2."Col2") > works as expected Now, in a query, as you point out the order of comparison is crucial. With the SQL statement: > update "Text1" "T1" set "Target"=(select "Col2" from "Text2" "T2" where > T1."Col1"=left(T2."Col2",5)) T1."Col1" ignores case and "accepts" so uppercase or lowercase (result of left...) With the SQL statement: > update "Text1" "T1" set "Target"=(select "Col2" from "Text2" "T2" where > left(T2."Col2",5)=T1."Col1") The expression left(T2."Col2",5) is evaluated and compared with T1."Col1" T1."Col1" is defined as to ignore case, but not the result of expression left... IMHO This does not seem to me to be a bug, I would recommend then to close as NOTABUG (In reply to comment #1) If I understand this response, with all due respect, it seems inappropriate: the request is not here to be able to run update queries from the GUI. The Issue is not either a limitation of the engine version but a different result depending on how to write SQL. Best regards Pierre-Yves -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs