[Libreoffice-bugs] [Bug 58586] EDITING : Autofilter complete ignored, when content is defined by a Subselect

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=58586

--- Comment #14 from robert at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180809/c36c1975/attachment.html>