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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Mailing list archive advanced search sort-by applies filters to results
Дата
Msg-id 3a6ecb10-f243-46a4-b63f-192f9d485eb0@aklaver.com
обсуждение исходный текст
Ответ на Re: Mailing list archive advanced search sort-by applies filters to results  (Sehrope Sarkuni <sehrope@jackdb.com>)
Список pgsql-www
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




В списке pgsql-www по дате отправления:

Предыдущее
От: Sehrope Sarkuni
Дата:
Сообщение: Re: Mailing list archive advanced search sort-by applies filters to results
Следующее
От: Alexander Lakhin
Дата:
Сообщение: Wiki editor request