[Libreoffice-bugs] [Bug 48807] New: AutoFilter in form uses field value as LIKE pattern

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Tue Apr 17 11:14:20 CEST 2012


https://bugs.freedesktop.org/show_bug.cgi?id=48807

             Bug #: 48807
           Summary: AutoFilter in form uses field value as LIKE pattern
    Classification: Unclassified
           Product: LibreOffice
           Version: LibO 3.3.4 release
          Platform: All
        OS/Version: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: lionel at mamane.lu
                CC: iplaw67 at yahoo.co.uk, lionel at mamane.lu,
                    sasha.libreoffice at gmail.com, zreizinger at hdsnet.hu
        Depends on: 42120


Test case: see attachment 52678 of bug 42120.

1) Add a record with fname='A*' and lname left blank (or any arbitrary value).
2) Position form on this record.
3) Click on AutoFilter button (Filters the records, based on the content of the
currently selected field)

Result is two records, namely "Alex Thurgood" and "A*". "Alex Thurgood" should
not be in the results, since the fname is not "A*", but is "Alex".

The problem is that the generated filter is "fname LIKE 'A*'" instead of "fname
= 'A*'". The "A*" in the fname field in the newly inserted record is a *value*
and should not silently be treated as a *pattern*.

Note that when doing AutoFilter on lname, the generated filter is "IS EMPTY" (a
synonym for "IS NULL"), not "LIKE NULL" or "LIKE ''". That is good.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list