BUG #13488: Wrong netmask calculation

From: stn(at)inbox(dot)ru
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #13488: Wrong netmask calculation
Date: 2015-07-06 08:48:21
Message-ID: 20150706084821.1201.77035@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 13488
Logged by: Taras
Email address: stn(at)inbox(dot)ru
PostgreSQL version: 9.4.4
Operating system: CentOS 6.5
Description:

database=# select inet(routedest), inet(routemask) from iprouteinterface
group by routedest, routemask order by routedest limit 3;
inet | inet
-----------+-------------
0.0.0.0 | 0.0.0.0
10.1.0.0 | 255.255.0.0
10.10.0.0 | 255.255.0.0
(3 rows)

database=# select inet(routedest), cidr(routemask) from iprouteinterface
group by routedest, routemask order by routedest limit 3;
inet | cidr
-----------+----------------
0.0.0.0 | 0.0.0.0/32
10.1.0.0 | 255.255.0.0/32
10.10.0.0 | 255.255.0.0/32
(3 rows)
database=# select routedest, network(inet(routemask)) from iprouteinterface
group by routedest, routemask order by routedest limit 3;
routedest | network
-----------+----------------
0.0.0.0 | 0.0.0.0/32
10.1.0.0 | 255.255.0.0/32
10.10.0.0 | 255.255.0.0/32
(3 rows)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Kroon 2015-07-06 10:06:49 Re: dblink max per function
Previous Message Fabien COELHO 2015-07-06 05:36:53 Re: BUG #12379: pgbench should hint to pgbench -i