Attachment 42160 Details for Bug 32960 – patch for "invalid SQL" issue

[patch] patch for "invalid SQL" issue

0001-fdo-32960-alias-derived-table.patch (text/plain), 1.53 KB, created by Lionel Elie Mamane on 2011-01-18 05:40:29 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Lionel Elie Mamane

Created: 2011-01-18 05:40:29 UTC

Size: 1.53 KB

patch

obsolete

>From c226d7ea151f7d41e3841a5a5b1b448cebbd8397 Mon Sep 17 00:00:00 2001
>From: Lionel Elie Mamane <lionel@mamane.lu>
>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
>

Actions: View

Attachments on bug 32960: 42160