[Libreoffice-commits] .: reportbuilder/java

[Tor Lillqvist]

 reportbuilder/java/com/sun/star/report/SDBCReportDataFactory.java |    4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

New commits:
commit abb7d3d29f3e7a010acb1713e38643825835b8c6
Author: Lionel Elie Mamane <lionel at mamane.lu>
Date:   Thu Jan 20 11:54:23 2011 +0200

    Use more reliable SQL syntax
    
    Give a derived table (subquery) an alias (name). From fdo#32960.
    
    Signed-off-by: Tor Lillqvist <tlillqvist at novell.com>

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);