Обсуждение: Mailing list archive advanced search sort-by applies filters to results
Was using the mailing list archive search to find a mail that I know exists (I have it in my inbox but wanted a link to it).
I started using the "Advanced Search" link that goes here: https://www.postgresql.org/search/?m=1&ln=pgsql-announce
However, searching for "jdbc" with the default filters (i.e. "within the last year") did not find the message. Changing the "Sort By" to "Date" (from the default of "Rank") and the message appears. Nothing else was different, just the intended sort order.
Sorting by "Rank" gives three messages.
Sorting by "Date" gives four messages.
Sorting by "Reverse Date" gives one message.
That doesn't seem correct. The sort should only change the order of the filtered messages right?
On 4/18/24 11:12, Sehrope Sarkuni wrote: > Was using the mailing list archive search to find a mail that I know > exists (I have it in my inbox but wanted a link to it). > > I started using the "Advanced Search" link that goes here: > https://www.postgresql.org/search/?m=1&ln=pgsql-announce > <https://www.postgresql.org/search/?m=1&ln=pgsql-announce> > > However, searching for "jdbc" with the default filters (i.e. "within the > last year") did not find the message. Changing the "Sort By" to "Date" > (from the default of "Rank") and the message appears. Nothing else was > different, just the intended sort order. What is the email you are looking for? > > Sorting by "Rank" gives three messages. > Sorting by "Date" gives four messages. > Sorting by "Reverse Date" gives one message. > I get: 3 2 2 Did you do a hard reload on the page? > That doesn't seem correct. The sort should only change the order of the > filtered messages right? > > Regards, > -- Sehrope Sarkuni > Founder & CEO | JackDB, Inc. | https://www.jackdb.com/ > <https://www.jackdb.com/> > -- Adrian Klaver adrian.klaver@aklaver.com
Re: Mailing list archive advanced search sort-by applies filters to results
От
Sehrope Sarkuni
Дата:
On Thu, Apr 18, 2024 at 2:57 PM Adrian Klaver <adrian.klaver@aklaver.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]
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?)
On 4/18/24 14:23, Sehrope Sarkuni wrote: > On Thu, Apr 18, 2024 at 2:57 PM Adrian Klaver <adrian.klaver@aklaver.com > <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com