Re: [PATCH] Add tests for Bitmapset

Поиск
Список
Период
Сортировка
От Greg Burd
Тема Re: [PATCH] Add tests for Bitmapset
Дата
Msg-id 76DBEF5D-EA47-4C30-8D28-97B3B88E2E2D@greg.burd.me
обсуждение исходный текст
Ответ на Re: [PATCH] Add tests for Bitmapset  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: [PATCH] Add tests for Bitmapset
Список pgsql-hackers
On Sep 30 2025, at 6:29 am, David Rowley <dgrowleyml@gmail.com> wrote:

> On Tue, 30 Sept 2025 at 22:30, Greg Burd <greg@burd.me> wrote:
>> Thank you both, patch attached.
> 
> Patch looks good to me.
> 
> Just while reviewing, I was confused at the following code in
> test_bms_add_range().
> 
>    /* Check for invalid range */
>    if (upper < lower)
>    {
>        bms_free(bms);
>        PG_RETURN_NULL();
>    }
> 
> That seems wrong. You should just return the input set in that case,
> not NULL.

Agreed, I should have caught this inconsistency earlier on.

> This results in:
> 
> postgres=# select test_bms_add_range('(b 1)', 2, 5); -- ok.
> test_bms_add_range
> --------------------
> (b 1 2 3 4 5)
> (1 row)
> 
> postgres=# select test_bms_add_range('(b 1)', 5, 2); -- wrong results
> test_bms_add_range
> --------------------
> 
> (1 row)
> 
> I'd expect the last one to return '(b 1)', effectively the input set unmodified.
> 
> If I remove the code quoted above, I also see something else unexpected:
> 
> postgres=# select test_bms_add_range('(b)', 5, 2);
> test_bms_add_range
> --------------------
> <>
> (1 row)
> 
> Now, you might blame me for that as I see you've done things like:
> 
>    if (bms_is_empty(bms))
>       PG_RETURN_NULL();
> 
> in other places, but it's not very consistent as I can get the <> in
> other locations:
> 
> postgres=# select test_bms_add_members('(b)', '(b)');
> test_bms_add_members
> ----------------------
> <>
> (1 row)
> 
> It seems to me that you could save some code and all this
> inconsistency by just making <> the standard way to represent an empty
> Bitmapset. Or if you really want to keep the SQL NULLs, you could make
> a helper macro that handles that consistently.

nodeToString() will turn NULL into '<>' because it has no way to know
that we're referring to a NULL/empty Bitmapset, but that's not what we'd
ideally like to return in those cases because NULL Bitmapsets are in
fact a thing.  The standard/consistent representation for a NULL
Bitmapset encoded by nodeToString() is '(b)' so I'll update to be more
consistent across tests.

> For me, I think stripping as much logic out of the test functions as
> possible is a good way of doing things. I expect you really want to
> witness the behaviour of bitmapset.c, not some anomaly of
> test_bitmapset.c.

You are 100% correct, I've stripped away as much as possible so as to
push the responsibility for results down to the bitmapset.c code as it
should be.
 
> David

v2 attached.

best.

-greg

Вложения

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