[Libreoffice-qa] Bug 61166: Base since LO 4.0 unusable with correlating subqueries

[Dan Lewis]

On 02/21/2013 11:46 AM, Robert Großkopf wrote:
> Hi *,
>
> is there anybody, who could have a look at
> https://bugs.freedesktop.org/show_bug.cgi?id=61166 ?
> EDITING: Values in correlated subquery were not shown in queries.
>
> You only have to download a file and start two queries. With LO up to
> 3.6 you see values in the field "Balance", with 4.0 this part of the
> query is empty.
>
> For me its a greater problem of Base - no dataloss, but unusable forms,
> which worked since the beginning of LO.
>
> Regards,
>
> Robert
       The problem is how the Query Design dialog runs the query. What I 
discovered is that if I opened the query to edit it in Design view that 
I got an error message: "SQL syntax error". When I opened either query 
in SQL view and clicked the icon that has SQL in it ("Run SQL command 
directly"), I could run the query correctly. The Balance column then 
contained the same values as when I ran the query using LO 3.6.5.2.
      I also added comments similar to these in the bug report.

--Dan