diff options
| author | Lionel Elie Mamane <lionel@mamane.lu> | 2011-01-20 11:54:23 +0200 |
|---|---|---|
| committer | Tor Lillqvist <tlillqvist@novell.com> | 2011-01-20 11:55:28 +0200 |
| commit | abb7d3d29f3e7a010acb1713e38643825835b8c6 (patch) | |
| tree | c2d6bd330808bbf4b51871610a6564f5c9903faf | |
| parent | e7b77db21bc2070d5fcde95747035ae73ed6d805 (diff) | |
Use more reliable SQL syntax
Give a derived table (subquery) an alias (name). From fdo#32960.
Signed-off-by: Tor Lillqvist <tlillqvist@novell.com>
| -rw-r--r-- | reportbuilder/java/com/sun/star/report/SDBCReportDataFactory.java | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/reportbuilder/java/com/sun/star/report/SDBCReportDataFactory.java b/reportbuilder/java/com/sun/star/report/SDBCReportDataFactory.java index d3f7017..fd22393 100644 --- a/reportbuilder/java/com/sun/star/report/SDBCReportDataFactory.java +++ b/reportbuilder/java/com/sun/star/report/SDBCReportDataFactory.java @@ -573,13 +573,13 @@ public class SDBCReportDataFactory implements DataSourceFactory final Boolean escape = (Boolean) prop.getPropertyValue(ESCAPEPROCESSING); rowSetProp.setPropertyValue(ESCAPEPROCESSING, escape); final String queryCommand = (String) prop.getPropertyValue(UNO_COMMAND); - statement = "SELECT * FROM (" + queryCommand + ")"; + statement = "SELECT * FROM (" + queryCommand + ") AS \"__LibreOffice_report_result\""; } } else { - statement = "SELECT * FROM (" + command + ")"; + statement = "SELECT * FROM (" + command + ") AS \"__LibreOffice_report_result\""; } } rowSetProp.setPropertyValue(UNO_COMMAND, statement); |