From c226d7ea151f7d41e3841a5a5b1b448cebbd8397 Mon Sep 17 00:00:00 2001 From: Lionel Elie Mamane Date: Tue, 18 Jan 2011 14:36:38 +0100 Subject: [PATCH] fdo#32960: alias derived table --- .../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); -- 1.7.2.3