Thread: select distinct inet bug
I've already post a similar messages but i don't see it into the mailing list so ...
Look at the following :
test=> create table ip_table (addr inet);
CREATE
test=> insert into ip_table values ('10.10.10.10');
INSERT 1403913 1
test=> insert into ip_table values ('10.10.10.11');
INSERT 1403914 1
test=> select distinct addr from ip_table ;
addr
-----------
10.10.10.10
10.10.10.11
(2 rows)
test=> insert into ip_table values ('10.10.10.10');
INSERT 1403915 1
test=> select distinct addr from ip_table ;
addr
-----------
10.10.10.10
10.10.10.10
10.10.10.11
(3 rows)
???? I've read there was some bugs with inet type but i have not see it .
It seems to appear when i insert a value , after a select distinct and not if i insert without look at the result .
Is anybody could help me ? (Postgresql 6.5.2 on a Debian )
Loic
loic@ext.cri74.org
Fixed in PostgreSQL 7.0, which was just released. > Hie all , > > I've already post a similar messages but i don't see it into the > mailing list so ... > Look at the following : > > test=> create table ip_table (addr inet); > CREATE > test=> insert into ip_table values ('10.10.10.10'); > INSERT 1403913 1 > test=> insert into ip_table values ('10.10.10.11'); > INSERT 1403914 1 > test=> select distinct addr from ip_table ; > addr > ----------- > 10.10.10.10 > 10.10.10.11 > (2 rows) > > test=> insert into ip_table values ('10.10.10.10'); > INSERT 1403915 1 > test=> select distinct addr from ip_table ; > addr > ----------- > 10.10.10.10 > 10.10.10.10 > 10.10.10.11 > (3 rows) > > > ???? I've read there was some bugs with inet type but i have not see it > . > > It seems to appear when i insert a value , after a select distinct and > not if i insert without look at the result . > > Is anybody could help me ? (Postgresql 6.5.2 on a Debian ) > > > Loic > > > > loic@ext.cri74.org -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026