[Libreoffice-bugs] [Bug 48567] New: [LO Base] "The data content cannot be loaded" on SQL SELECT when it is called from GUI

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=48567

             Bug #: 48567
           Summary: [LO Base] "The data content cannot be loaded" on SQL
                    SELECT when it is called from GUI
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO Master
          Platform: PowerPC
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: dougmencken at gmail.com


Created attachment 59812
  --> https://bugs.freedesktop.org/attachment.cgi?id=59812
done.log

I'm getting "The data content cannot be loaded" (HY000, i.e. SQL_GENERAL_ERROR)
in the following cases:
- An attempt to open any Table (via Base's GUI);
- An attempt to open any Query;
- An attempt to execute StarBasic Base-related macro in any Form.

In the case of Reports, I'm getting "The document "Report_Title" could not be
opened" error and the trace:

----------
SEVERE: ReportProcessing failed
com.sun.star.report.ReportExecutionException: Syntax error in SQL expression
    at
com.sun.star.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:386)
    at
com.sun.star.report.pentaho.SOReportJobFactory$_SOReportJobFactory.execute(SOReportJobFactory.java:223)
Caused by: org.jfree.report.ReportDataFactoryException: Syntax error in SQL
expression
    at
com.sun.star.report.pentaho.StarReportDataFactory.queryData(StarReportDataFactory.java:81)
    at org.jfree.report.data.CachingReportDataFactory.queryData(Unknown Source)
    at org.jfree.report.data.ReportDataRow.createDataRow(Unknown Source)
    at org.jfree.report.flow.DefaultFlowController.performQuery(Unknown Source)
    at
org.jfree.report.flow.layoutprocessor.ReportLayoutController.startData(Unknown
Source)
    at
org.jfree.report.flow.layoutprocessor.ElementLayoutController.startElement(Unknown
Source)
    at
org.jfree.report.flow.layoutprocessor.ElementLayoutController.advance(Unknown
Source)
    at org.jfree.report.flow.AbstractReportProcessor.processReportRun(Unknown
Source)
    at org.jfree.report.flow.SinglePassReportProcessor.processReport(Unknown
Source)
    at
com.sun.star.report.pentaho.PentahoReportJob.execute(PentahoReportJob.java:374)
    ... 1 more
----------

GUI lists of available Tables, Queries, Forms and Reports are correct.

Direct execution of SQL commands (via Tools -> SQL...) does work.

The following bug report looks like describing the same problem (but on ARMEL
architecture and for OOo 3.2):
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=585829

I also did make check and got that I'm failing at 
----------
...
[ build JCS ] JunitTest/configmgr_unoapi
[ build JUT ] configmgr_unoapi
[ build SCK ] configmgr
[ build JCS ] JunitTest/dbaccess_complex
Note: Some input files use unchecked or unsafe operations.
Note: Recompile with -Xlint:unchecked for details.
[ build JUT ] dbaccess_complex
JUnit version 4.10
E
...
.testing the basics
.checking PropertySetAccess via sequences
.checking proper dynamic of the set
...
Time: 14.26
There was 1 failure:
1) testBeamer(complex.dbaccess.Beamer)
java.lang.AssertionError: count1 = 0 count2 = 1
    at complex.dbaccess.Beamer.testBeamer(Beamer.java:144)

FAILURES!!!
Tests run: 4,  Failures: 1

see full error log at
/root/libra/git/workdir/unxlngppc.pro/JunitTest/dbaccess_complex/done.log
----------

`done.log' is attached.

I added some simple System.out.printlns to
./dbaccess/qa/complex/dbaccess/Beamer.java (System.out.println("[DEBUG]
enumeration: " + enumeration), System.out.println("[DEBUG] nextElement: " +
enumeration.nextElement()) and System.out.println("[DEBUG] count = " + count +
", count2 = " + count2)), and got:

----------
[DEBUG] enumeration:
[Proxy:16564840,10fefd40;gcc3[0];26e7c7f42875476ca3a4bfaadf583d1b,Type[com.sun.star.container.XEnumeration]]
[DEBUG] nextElement: Any[Type[com.sun.star.frame.XModel],
[Proxy:4146069,10c075d8;gcc3[0];26e7c7f42875476ca3a4bfaadf583d1b,Type[com.sun.star.frame.XModel]]]
[DEBUG] enumeration:
[Proxy:589927,10b900b8;gcc3[0];26e7c7f42875476ca3a4bfaadf583d1b,Type[com.sun.star.container.XEnumeration]]
[DEBUG] nextElement: Any[Type[com.sun.star.frame.XModel],
[Proxy:16356945,110bd2f0;gcc3[0];26e7c7f42875476ca3a4bfaadf583d1b,Type[com.sun.star.frame.XModel]]]
[DEBUG] count = 0, count2 = 1
----------

So yes, `count' is not equal to `count2', and Beamer.java's assert fails on my
side.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.