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

From: Sehrope Sarkuni <sehrope(at)jackdb(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: PostgreSQL WWW <pgsql-www(at)postgresql(dot)org>
Subject: Re: Mailing list archive advanced search sort-by applies filters to results
Date: 2024-04-18 21:23:01
Message-ID: CAH7T-aq=dW3khkL-DxUbzFDYObj_UXzRbeBg=XEp_kHU0uDCjw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

On Thu, Apr 18, 2024 at 2:57 PM Adrian Klaver <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?)

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

In response to

Responses

Browse pgsql-www by date

  From Date Subject
Next Message Adrian Klaver 2024-04-18 21:29:38 Re: Mailing list archive advanced search sort-by applies filters to results
Previous Message Adrian Klaver 2024-04-18 18:57:42 Re: Mailing list archive advanced search sort-by applies filters to results