Re: Mailing list archive advanced search sort-by applies filters to results

On 4/18/24 14:23, Sehrope Sarkuni wrote:
> On Thu, Apr 18, 2024 at 2:57 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> What is the email you are looking for?
>
>
> The most recent one.
>
> > Sorting by "Rank" gives three messages.
> > Sorting by "Date" gives four messages.
> > Sorting by "Reverse Date" gives one message.
> >
>
> I get:
>         3
>         2
>         2
>
>
> Trying it again I get the same 3, 2, 2. The set of results is different too.
>
> Here are the titles for the search results (note how they're all different):
>
> # Rank
> 1. JDBC FDW 0.3.1 release [1.20]
> 2. PostgreSQL JDBC 42.7.0 Released [1.00]
> 3. PostgreSQL JDBC 42.7.1 Released [1.00]
>
> # Date
> 1. PostgreSQL JDBC 42.7.3, 42.6.2, 42.5.6, 42.4.5, 42.3.10, 42.2.29
> Released [1.10]
> 2. JDBC FDW 0.4.0 release [1.10]
>
> # Reverse Date
> 1. WiltonDB 3.3 released [0.10]
> 2. PostgreSQL JDBC 42.7.2, 42.6.1, 42.5.5, 42.4.4, 42.3.9, 42.2.28, and
> 42.2.28.jre7 Security update for CVE-2024-1597 [1.10]
>
> In any event, something is weird / wrong if the number or total set of
> results changes based on sort order.
>
> Is the "Rank" data coming from somewhere else entirely that's not in
> sync with the rest of the messages? (e.g., a separate elastic search
> server?)

This above my pay grade, someone with more knowledge of the internals
will need to comment.

>
> Regards,
> -- Sehrope Sarkuni
> Founder & CEO | JackDB, Inc. | https://www.jackdb.com/
> <https://www.jackdb.com/>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com