diff options
| author | Julien Nabet <serval2412@yahoo.fr> | 2014-07-22 18:36:05 +0200 |
|---|---|---|
| committer | Julien Nabet <serval2412@yahoo.fr> | 2014-07-22 18:38:21 +0200 |
| commit | 568778874429595855b435792e5ebecd52956dae (patch) | |
| tree | ff4b7207b0b448629c20178f68b3579c0397ef76 /reportbuilder | |
| parent | 6296c64fb0ed8bce61eb6303920f952eda65de71 (diff) | |
Resolves fdo#81213: Wrong table-clause generated by reportbuilder
Oracle doesn't accept "AS" for making an alias from a table
See https://bugs.freedesktop.org/show_bug.cgi?id=81213#c2
https://bugs.freedesktop.org/show_bug.cgi?id=81213#c4
https://bugs.freedesktop.org/show_bug.cgi?id=81213#c5
for more information
(thank you Lionel)
Change-Id: I33c86d78b2590116d4af46ffd3e54c3c791268ea
Diffstat (limited to 'reportbuilder')
| -rw-r--r-- | reportbuilder/java/org/libreoffice/report/SDBCReportDataFactory.java | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/reportbuilder/java/org/libreoffice/report/SDBCReportDataFactory.java b/reportbuilder/java/org/libreoffice/report/SDBCReportDataFactory.java index 86ba838e4fd3..936c0db33c4b 100644 --- a/reportbuilder/java/org/libreoffice/report/SDBCReportDataFactory.java +++ b/reportbuilder/java/org/libreoffice/report/SDBCReportDataFactory.java @@ -556,13 +556,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 + ") AS \"__LibreOffice_report_result\""; + statement = "SELECT * FROM (" + queryCommand + ") \"__LibreOffice_report_result\""; } } else { - statement = "SELECT * FROM (" + command + ") AS \"__LibreOffice_report_result\""; + statement = "SELECT * FROM (" + command + ") \"__LibreOffice_report_result\""; } } rowSetProp.setPropertyValue(UNO_COMMAND, statement); |