https://bugs.documentfoundation.org/show_bug.cgi?id=58586
--- Comment #14 from rob...@familiegrosskopf.de ---
(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
--
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
