Ethernet MAC addresses (macaddr type) are not compared correctly for equality.  The lobits macro is wrong and extracts the wrong set of bits out of the structure.
Ethernet MAC addresses (macaddr type) are not compared correctly for
equality.  The lobits macro is wrong and extracts the wrong set of
bits out of the structure.

To exhibit the problem:

select '000000:000000'::macaddr = '000000:110000'::macaddr ;
?column?
--------
t
(1 row)

Daniel Boyd

ashwinstar/gpdb,royc1/gpdb,snaga/postgres-xl,yuanzhao/gpdb,greenplum-db/gpdb,rubikloud/gpdb,0x0FFF/gpdb,atris/gpdb,tpostgres-projects/tPostgres,jmcatamney/gpdb,lintzc/gpdb,0x0FFF/gpdb,atris/gpdb,tangp3/gpdb,0x0FFF/gpdb,snaga/postgres-xl,Postgres-XL/Postgres-XL,oberstet/postgres-xl,50wu/gpdb,kaknikhil/gpdb,randomtask1155/gpdb,Chibin/gpdb,lisakowen/gpdb,50wu/gpdb,randomtask1155/gpdb,zaksoup/gpdb,edespino/gpdb,Postgres-XL/Postgres-XL,pavanvd/postgres-xl,CraigHarris/gpdb,lpetrov-pivotal/gpdb,edespino/gpdb,oberstet/postgres-xl,janebeckman/gpdb,edespino/gpdb,randomtask1155/gpdb,ovr/postgres-xl,cjcjameson/gpdb,ahachete/gpdb,Postgres-XL/Postgres-XL,foyzur/gpdb,atris/gpdb,jmcatamney/gpdb,jmcatamney/gpdb,janebeckman/gpdb,xuegang/gpdb,xinzweb/gpdb,janebeckman/gpdb,arcivanov/postgres-xl,xinzweb/gpdb,ashwinstar/gpdb,kaknikhil/gpdb,CraigHarris/gpdb,chrishajas/gpdb,adam8157/gpdb,cjcjameson/gpdb,janebeckman/gpdb,xuegang/gpdb,Quikling/gpdb,yuanzhao/gpdb,zeroae/postgres-xl,snaga/postgres-xl,randomtask1155/gpdb,lisakowen/gpdb,yuanzhao/gpdb,greenplum-db/gpdb,xuegang/gpdb,Postgres-XL/Postgres-XL,lisakowen/gpdb,tangp3/gpdb,lisakowen/gpdb,50wu/gpdb,greenplum-db/gpdb,rubikloud/gpdb,yuanzhao/gpdb,oberstet/postgres-xl,tangp3/gpdb,kaknikhil/gpdb,randomtask1155/gpdb,lintzc/gpdb,lisakowen/gpdb,ahachete/gpdb,ashwinstar/gpdb,Quikling/gpdb,chrishajas/gpdb,zaksoup/gpdb,xinzweb/gpdb,rubikloud/gpdb,chrishajas/gpdb,yazun/postgres-xl,yazun/postgres-xl,kaknikhil/gpdb,edespino/gpdb,techdragon/Postgres-XL,janebeckman/gpdb,rvs/gpdb,jmcatamney/gpdb,yuanzhao/gpdb,pavanvd/postgres-xl,postmind-net/postgres-xl,pavanvd/postgres-xl,royc1/gpdb,0x0FFF/gpdb,edespino/gpdb,Chibin/gpdb,lisakowen/gpdb,Chibin/gpdb,rubikloud/gpdb,kmjungersen/PostgresXL,zaksoup/gpdb,techdragon/Postgres-XL,arcivanov/postgres-xl,50wu/gpdb,rubikloud/gpdb,adam8157/gpdb,50wu/gpdb,greenplum-db/gpdb,kaknikhil/gpdb,zeroae/postgres-xl,Chibin/gpdb,ahachete/gpdb,snaga/postgres-xl,ovr/postgres-xl,royc1/gpdb,ovr/postgres-xl,techdragon/Postgres-XL,chrishajas/gpdb,Quikling/gpdb,kaknikhil/gpdb,tangp3/gpdb,xinzweb/gpdb,xinzweb/gpdb,royc1/gpdb,rubikloud/gpdb,foyzur/gpdb,yazun/postgres-xl,ahachete/gpdb,zaksoup/gpdb,randomtask1155/gpdb,kmjungersen/PostgresXL,ahachete/gpdb,xuegang/gpdb,janebeckman/gpdb,tpostgres-projects/tPostgres,postmind-net/postgres-xl,zaksoup/gpdb,xinzweb/gpdb,CraigHarris/gpdb,ahachete/gpdb,tpostgres-projects/tPostgres,arcivanov/postgres-xl,oberstet/postgres-xl,adam8157/gpdb,greenplum-db/gpdb,foyzur/gpdb,tpostgres-projects/tPostgres,CraigHarris/gpdb,yuanzhao/gpdb,xinzweb/gpdb,rubikloud/gpdb,50wu/gpdb,rubikloud/gpdb,0x0FFF/gpdb,ovr/postgres-xl,janebeckman/gpdb,Quikling/gpdb,yazun/postgres-xl,0x0FFF/gpdb,janebeckman/gpdb,Chibin/gpdb,arcivanov/postgres-xl,jmcatamney/gpdb,edespino/gpdb,ashwinstar/gpdb,Postgres-XL/Postgres-XL,randomtask1155/gpdb,Quikling/gpdb,0x0FFF/gpdb,janebeckman/gpdb,kaknikhil/gpdb,lpetrov-pivotal/gpdb,yuanzhao/gpdb,kmjungersen/PostgresXL,kaknikhil/gpdb,snaga/postgres-xl,rvs/gpdb,rvs/gpdb,zeroae/postgres-xl,rvs/gpdb,lintzc/gpdb,lintzc/gpdb,randomtask1155/gpdb,lpetrov-pivotal/gpdb,xuegang/gpdb,lisakowen/gpdb,lintzc/gpdb,Quikling/gpdb,cjcjameson/gpdb,jmcatamney/gpdb,CraigHarris/gpdb,lintzc/gpdb,atris/gpdb,postmind-net/postgres-xl,rvs/gpdb,xinzweb/gpdb,xuegang/gpdb,greenplum-db/gpdb,chrishajas/gpdb,edespino/gpdb,ashwinstar/gpdb,rvs/gpdb,Chibin/gpdb,edespino/gpdb,xuegang/gpdb,foyzur/gpdb,lpetrov-pivotal/gpdb,adam8157/gpdb,jmcatamney/gpdb,greenplum-db/gpdb,foyzur/gpdb,tangp3/gpdb,yuanzhao/gpdb,lpetrov-pivotal/gpdb,ahachete/gpdb,arcivanov/postgres-xl,atris/gpdb,kmjungersen/PostgresXL,CraigHarris/gpdb,arcivanov/postgres-xl,lpetrov-pivotal/gpdb,royc1/gpdb,rvs/gpdb,cjcjameson/gpdb,kmjungersen/PostgresXL,janebeckman/gpdb,adam8157/gpdb,50wu/gpdb,rvs/gpdb,tangp3/gpdb,pavanvd/postgres-xl,yazun/postgres-xl,ashwinstar/gpdb,jmcatamney/gpdb,cjcjameson/gpdb,adam8157/gpdb,ashwinstar/gpdb,royc1/gpdb,cjcjameson/gpdb,chrishajas/gpdb,lpetrov-pivotal/gpdb,zaksoup/gpdb,atris/gpdb,xuegang/gpdb,zaksoup/gpdb,lintzc/gpdb,edespino/gpdb,0x0FFF/gpdb,lpetrov-pivotal/gpdb,Quikling/gpdb,cjcjameson/gpdb,lisakowen/gpdb,xuegang/gpdb,royc1/gpdb,atris/gpdb,Quikling/gpdb,CraigHarris/gpdb,chrishajas/gpdb,cjcjameson/gpdb,kaknikhil/gpdb,foyzur/gpdb,tangp3/gpdb,ahachete/gpdb,lintzc/gpdb,greenplum-db/gpdb,chrishajas/gpdb,edespino/gpdb,yuanzhao/gpdb,royc1/gpdb,techdragon/Postgres-XL,yuanzhao/gpdb,lintzc/gpdb,Chibin/gpdb,Quikling/gpdb,adam8157/gpdb,ashwinstar/gpdb,foyzur/gpdb,rvs/gpdb,Quikling/gpdb,zeroae/postgres-xl,CraigHarris/gpdb,atris/gpdb,oberstet/postgres-xl,adam8157/gpdb,cjcjameson/gpdb,zeroae/postgres-xl,foyzur/gpdb,CraigHarris/gpdb,pavanvd/postgres-xl,tangp3/gpdb,postmind-net/postgres-xl,rvs/gpdb,50wu/gpdb,Chibin/gpdb,kaknikhil/gpdb,zaksoup/gpdb,ovr/postgres-xl,tpostgres-projects/tPostgres,Chibin/gpdb,postmind-net/postgres-xl,techdragon/Postgres-XL,cjcjameson/gpdb,Chibin/gpdb