BUG #7575: "between" does not work properly with inet/cidr addresses

Поиск
Список
Период
Сортировка
От mr.dash.four@googlemail.com
Тема BUG #7575: "between" does not work properly with inet/cidr addresses
Дата
Msg-id E1THijW-00022e-9T@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #7575: "between" does not work properly with inet/cidr addresses  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7575
Logged by:          Mr-4
Email address:      mr.dash.four@googlemail.com
PostgreSQL version: 9.1.4
Operating system:   Linux (kernel 3.5)
Description:        =


1. select '10.1.1.0/24'::inet between '10.1.1.0'::inet and
'10.1.1.255'::inet gives me FALSE.

2. select '10.1.0.0/24'::inet between '10.1.0.0'::inet and
'10.1.255.255'::inet also produces FALSE.

To my understanding, 10.1.1.0/24 covers the range 10.1.1.0-10.1.1.255, so
the first statement above should produce TRUE, not FALSE. It is similar to
"select 1 between 1 and 1" which, quite rightly, produces TRUE.

Same goes for the second statement above: 10.1.0.0/24 covers the range
10.1.0.0-10.1.0.255, which falls fully within the 10.1.0.0-10.1.255.255
(10.1.0.0/16) range.

Am I missing something obvious?

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

Предыдущее
От: Mikael Kjellström
Дата:
Сообщение: Re: Corrupt view in PostgreSQL 9.0.9
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #7575: "between" does not work properly with inet/cidr addresses