Bug #559: MACADDR type & 00:00:00:00:00:00

Michael Handler (handler(at)grendel(dot)net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
MACADDR type & 00:00:00:00:00:00

Long Description
postgresql version 7.1.3, compiled with gcc 2.95.2 on solaris 2.6, running on solaris 2.8.

provisioning=> \d enduser
Table "enduser"
Attribute | Type | Modifier
-----------------+-------------------+----------------------------
account | character varying | not null
active | boolean | not null default 't'::bool
isp_id | integer | not null
speed_plan_id | integer | not null
service_plan_id | integer | not null
node_id | integer | not null
cm_macaddr | macaddr | not null
Indices: enduser_cm_macaddr_key,
enduser_pkey

provisioning=> insert into enduser values ('2', 't', 1, 1, 1, 1, '00:00:00:00:00:00');
INSERT 20853 1
provisioning=> select account,cm_macaddr from enduser where account = '2';
account | cm_macaddr
---------+------------
2 |
(1 row)

provisioning=> select count(*) from enduser where cm_macaddr is null;
count
-------
0
(1 row)

it's not null, so shouldn't it be retrieving as '00:00:00:00:00:00'?
not that i ever expect to encounter that macaddress in the field, but
for consistency's sake...

i just tested 'ff:ff:ff:ff:ff:ff', and it works fine.

ps postgresql sends mysql running back home to mommy. you guys are my heroes.

Sample Code

No file was uploaded with this report