https://bugs.documentfoundation.org/show_bug.cgi?id=58586
--- Comment #15 from Drew Jensen <drewjensen.in...@gmail.com> ---
it probably makes sense to run a test using the API calls into the
singlequery(In reply to robert from comment #14)
> (In reply to Drew Jensen from comment #13)
> > Created attachment 144066 [details]
> > bug report file after migration to Firebird db
> >
> > Using Ubuntu 18.04 and Libo 6.1 RC3 the problem continues to exhibit when
> > using HSQLdb embedded Base files.
> >
> This is the query, which will work under Firebird also:
> SELECT "T_User".*, "T_Year"."LastSubscription" FROM "T_User" LEFT OUTER JOIN
> ( SELECT "UserId", MAX( "Year" ) AS "LastSubscription" FROM "T_Subscription"
> GROUP BY "UserId" ) AS "T_Year" ON "T_User"."UserId" = "T_Year"."UserId"
>
> ... and if I will filter "LastSubscription" it doesn't work, too.
>
> The query should have named the table if there is asked for all fields (*).
>
> Tested with LO 6.1.0.3, OpenSUSE 15, 64bit rpm Linux
Yup that does it for the change to the query.
Firebird and HSQL still act differently (between the original query in HSQL and
the changed query in Firebird) in that under HSQL you get an empty grid while
under firedbird it generates an error box and does not change the actual grid.
The error displayed, with FB engine, under 6.1 RC3 here is "Syntax error in SQL
statement".
That would be generated I suppose by either the SingleSelectQueryComposer or
SingleSelectQueryAnalyzer service when the filter parameter is set - it could
be worth a little time to check this with a script working against the service
provider, setting the filter parameters, via the API. Might be able to narrow
down which of those (the analyzer or composer) is throwing the error. I don't
mind working at that this evening.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
