https://bugs.freedesktop.org/show_bug.cgi?id=57985
--- Comment #6 from rob...@familiegrosskopf.de --- > > 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... In SQL it has to be the same result when linking a = b or b = a. When this doesn't work it is a bug. Try in the example-database: SELECT "Col2" FROM "Text2" WHERE 'pqrst' = "Col2" Response is Col2 with 'pqRst'. > > > (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 comment has nothing to do with an update-query from the GUI. The problem of this bug is, that nobody from the Libre-Office developers could change something at this position. It's a direct SQL-input. Somebody, who has installed a newer version of HSQLDB, could try the command. Could be, that it works in the way the reporter of the bug thinks it should work. I can confirm the bug, but I would say: it is not our bug. -- 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