[PATCH] [REVIEW:3-5] fdo#36824 embedded hsqldb; in view computed row without alias makes whole file unusable

Lionel Elie Mamane lionel at mamane.lu
Tue Jul 3 11:42:03 PDT 2012

hsqldb fails to properly escape column names it generates
automatically from an expression in the "script" file it uses to
recreate the database (in memory) on load/connect.

The net effect is that any .odb file where such a view has been
defined cannot be reopened, unless one manually fiddles with the
database/script file in the .odb file seen as a zip file.

This patch fixes that, by saying that *any* expression that is not
already a column name *should* be escaped (instead of *not* escaped)
when seen as a column name/alias.

I hope no bad side-effects, but I'm not intimate with HSQLDB internals,
so never can be really sure.

Please apply to libreoffice-3-5.

-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-fdo-36824-hsqldb-properly-escape-automatically-built.patch
Type: text/x-diff
Size: 1468 bytes
Desc: not available
URL: <http://lists.freedesktop.org/archives/libreoffice/attachments/20120703/26c7ec36/attachment.patch>

More information about the LibreOffice mailing list