postgres_fdw: possible overlooked NAMEDATALEN comparison in stats import

Поиск
Список
Период
Сортировка
Искать
От
Chao Li
Тема
postgres_fdw: possible overlooked NAMEDATALEN comparison in stats import
Дата
в 11:50:28
Msg-id
81D981EB-ECC1-495D-8EAC-5CFB67B2CF77@gmail.com
Список
Дерево обсуждения
postgres_fdw: possible overlooked NAMEDATALEN comparison in stats import Chao Li <li.evan.chao@gmail.com>
Re: postgres_fdw: possible overlooked NAMEDATALEN comparison in stats import Etsuro Fujita <etsuro.fujita@gmail.com>
Re: postgres_fdw: possible overlooked NAMEDATALEN comparison in stats import Etsuro Fujita <etsuro.fujita@gmail.com>
Hi,

I’m testing "[28972b6fc] Add support for importing statistics from remote servers". Functionally, so far so good. I just found a piece of suspicious code that might be an oversight in the follow-up commit aa1f93a3387:
```
/*
 * Compare two RemoteAttributeMappings for sorting.
 */
static int
remattrmap_cmp(const void *v1, const void *v2)
{
	const RemoteAttributeMapping *r1 = v1;
	const RemoteAttributeMapping *r2 = v2;

	return strncmp(r1->remote_attname, r2->remote_attname, NAMEDATALEN);
}
```  

This function compares remote attribute names only up to NAMEDATALEN. But aa1f93a3387 changed remote_attname from a NAMEDATALEN-byte array to a char pointer, and its commit message explicitly says "the remote column name in particular could be longer than NAMEDATALEN - 1". In that case, remattrmap_cmp() could treat two distinct remote column names as equal for sorting, while match_attrmap() later compares the full strings.

Also, aa1f93a3387’s commit message mentions match_attrmap(), and that function uses strcmp(). So I guess remattrmap_cmp() should also use strcmp().

I don’t have a repro that triggers a bad result. I just want to report and confirm whether that code should be changed. I made a local change as the attached diff, and no test is broken with the change.

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/




В списке pgsql-hackers по дате отправления
От: Ewan Young
Дата:
От: solai v
Дата:
FAQ