[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 #13 from Drew Jensen <drewjensen.inbox at gmail.com> ---
Created attachment 144066
  --> https://bugs.documentfoundation.org/attachment.cgi?id=144066&action=edit
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.

After conversion to Firebird the problem kind of goes away because the query
which gives rise to it does not function the same under Firebird (in fact it is
down right odd) Run it, unchanged, in query designer and you get one result
that doesn't actually have the proper data in the last column (rather it
duplicates a column). Use the query as is in the first form and the displayed
values differ again and the last column is the correct column now, but
completely empty. Set run SQL direct on that bothersome query and the data is
displayed as it was with HSQLdb but now of course the resultset is not live
(can not be updated) and the filter settings GUI controls do not activate
therefore.

Anwyay, it is certainly still there for HSQL and I've uploaded the converted
Firebird file if anyone wants to see if they duplicate the bug by re-working
the problem query.

-- 
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/58a0c554/attachment-0001.html>