Doc #81692 [Ver->Dup]: array_unique bug with mixed scalar values

[email protected] Wed, 16 Mar 2022 09:54:33 +0000
Newsgroups php.doc.bugs
Message-ID <[email protected]>
Edit report at https://bugs.php.net/bug.php?id=81692&edit=1

 ID:                 81692
 Updated by:         [email protected]
 Reported by:        stanislav dot eismont at gmail dot com
 Summary:            array_unique bug with mixed scalar values
-Status:             Verified
+Status:             Duplicate
 Type:               Documentation Problem
 Package:            Arrays related
 Operating System:   ubuntu 20.04
 PHP Version:        7.4.26
-Assigned To:        
+Assigned To:        cmb
 Block user comment: N
 Private report:     N

 New Comment:

Closing as duplicate of <https://github.com/php/doc-en/issues/1463>.


Previous Comments:
------------------------------------------------------------------------
[2021-12-31 01:00:45] a at b dot c dot de

Maybe I'm bikeshedding, but could the current more performant algorithm be attempted, but set a flag if a problematic potentially-incomparable mix of types is encountered. Then if the flag ends up set, take the "partially-uniquified" array that has already been built (don't want to throw away the work that has already been done) and make a second pass with a slower algorithm that doesn't rely on sort order making sense.

That would at least avoid bad performance on homogeneously-typed arrays.

(I thought of sort|uniq each type separately and then combine the results, but now I'm overthinking.)

------------------------------------------------------------------------
[2021-12-06 07:10:03] stanislav dot eismont at gmail dot com

Hmm, okay, thanks for the explanation. Now I realize that despite the possibility to fix array_unique(), for example, by choosing a different algorithm, the problem will still exist in sort() with the SORT_REGULAR flag. Unfortunately, I don't know what to do about it.

------------------------------------------------------------------------
[2021-12-03 15:58:57] [email protected]

> If you change this array somehow,

Changing the array will change the exact sequence of comparison operations that PHP performs in order to sort the array (which it needs to achieve the O(log n) efficiency that @cmb mentioned). The change may result in the two "red"s sorting consecutively, allowing array_unique to correctly deduplicate them, or it may not.

The problem is in how SORT_REGULAR works - but it's also behaving as intended. The solution is to not use SORT_REGULAR when you have arrays containing mixed scalars.

------------------------------------------------------------------------
[2021-12-03 15:47:50] stanislav dot eismont at gmail dot com

To me it isn't look like a doc related problem. I gave such a big array as an example for a reason. If you change this array somehow, let's say remove last element, then there will be one "red" value printed https://3v4l.org/tpjMt.

------------------------------------------------------------------------
[2021-12-03 15:30:54] [email protected]

> Isn't this just a result of inconsistent comparisons during
> sorting?

Right, although PHP 5 produced the required results[1].

Anyhow, SORT_REGULAR has a fundamental flaw when working on
arbitrarly mixed scalar types, namely that the result is not
necessarily in monotonic order, i.e. the sort has arbitrary
results (depending on the sorting algorithm).  E.g. consider ['2',
'a', 1]; the following holds prior to PHP 8.0.0:

    '2' < 'a'
    'a' < 1
    '2' > 1

As of PHP 8.0.0, this is no longer the case for the given example
(thanks to the saner string to number comparisons), but consider
another example: ['!', '0', true]; the following holds:

    '!' < '0'
    '0' < true
    '!' == true

That still doesn't work.

So the current O(log n) algorithm of array_unique(), would need to
be changed to an O(n²) algorithm, or the sorting algorithm would
need to be changed back to what we had in PHP 5.  Neither option
is desireable, and I think we should just document this
limitation.  (And we also should fix the note in the description
section, which only applies for SORT_STRING.)

[1] <https://3v4l.org/RfFJr>

------------------------------------------------------------------------


The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at

    https://bugs.php.net/bug.php?id=81692


--
Edit this bug report at https://bugs.php.net/bug.php?id=81692&edit=1