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
