[Issue 127825] New: Standard filter with option "No duplication" is losing results.

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127825

          Issue ID: 127825
        Issue Type: DEFECT
           Summary: Standard filter with option "No duplication" is losing
                    results.
           Product: Calc
           Version: 4.1.5
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: Normal
          Priority: P5 (lowest)
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: jag@psilosoph.de
  Target Milestone: ---

The standard filter offers the option to suppress repetitions. 
Applied to long data columns it returns less distinct items than actually
contained.  

From a few tests it seems that a maximum of 16384 distinct items can be
handled. Yes. That's a Strange number. We might expect a maximum of 2^15=32768
if an array with non-negative indices of type Integer (16 bit) was used. But
2^14?

The bug was found by a friend of mine. I reproduced it with an independent
example under AOO V4.1.5 (from PortableApps package). In both cases the error
occured as well when filtering in situ as when delivering the results to a
different range (option 'Copy results to...'). 

Occurring only with data sets of more than 16384 items, it's a poisonous bug,
because few users will look thoroughly enough on the results to notice it.

The attached demo needs a large file due to the nature of the bug. To open it
will take some time.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127825] Standard filter with option "No duplication" is losing results.

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127825

--- Comment #1 from Wolfgang Jäger <ja...@psilosoph.de> ---
the mentioned demo was rejected due to the file size. Therefor I uploaded the
file to my domain. The link is:
http://psilosoph.de/bugDemosAOO/FilterNoDublicatesBug16384atMost.ods

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127825] Standard filter with option "No duplication" is losing results.

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127825

Keith N. McKenna <kn...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |DUPLICATE
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |knmc@apache.org

--- Comment #3 from Keith N. McKenna <kn...@apache.org> ---
Closing as duplicate

*** This issue has been marked as a duplicate of issue 29844 ***

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127825] Standard filter with option "No duplication" is losing results.

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127825

Keith N. McKenna <kn...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 127825] Standard filter with option "No duplication" is losing results.

[bu...@apache.org]

https://bz.apache.org/ooo/show_bug.cgi?id=127825

jeffooo <je...@orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |jeffooo@orange.fr

--- Comment #2 from jeffooo <je...@orange.fr> ---
(In reply to Wolfgang Jäger from comment #0)
>it seems that a maximum of 16384 distinct items

Hello,

Possible duplicate issue of https://bz.apache.org/ooo/show_bug.cgi?id=29844
:
Issue 29844 - Filtering limited to 16384 row when No duplication checked

Regards

-- 
You are receiving this mail because:
You are the assignee for the issue.