Re: [HACKERS] Bug

It appears this bug still exists.

> 
> ---------- Forwarded message ----------
> Date: Fri, 17 Sep 1999 17:52:44 +0400 (MSD)
> From: Artem Chuprina <ran@pirit.com>
> 
> ran=> create table test_source (src text);
> CREATE
> ran=> insert into test_source values('First distinct');
> INSERT 235913 1
> ran=> insert into test_source values('First distinct');
> INSERT 235914 1
> ran=> insert into test_source values('Second distinct');
> INSERT 235915 1
> ran=> insert into test_source values('Second distinct');
> INSERT 235916 1
> ran=> select src from test_source;
> src            
> ---------------
> First distinct 
> First distinct 
> Second distinct
> Second distinct
> (4 rows)
> 
> ran=> select distinct src from test_source;
> src            
> ---------------
> First distinct 
> Second distinct
> (2 rows)
> 
> ran=> create sequence seq_test;
> CREATE
> ran=> create table test1 (n int default nextval('seq_test'), t text);
> CREATE
> ran=> create table test2 (n int, t text);
> CREATE
> ran=> insert into test2 ("t") select distinct src from test_source;
> INSERT 0 2
> ran=> insert into test1 ("t") select distinct src from test_source;
> INSERT 0 4
>          
> Look here^
> 
> ran=> select * from test2;
> n|t              
> -+---------------
>  |First distinct 
>  |Second distinct
> (2 rows)
> 
> ran=> select * from test1;
> n|t              
> -+---------------
> 1|First distinct 
> 2|First distinct 
> 3|Second distinct
> 4|Second distinct
> (4 rows)
> 
> PostgreSQL 6.4.2, PostgreSQL 6.5.1.
> 
> -- 
> Artem Chuprina                             E-mail: ran@pirit.com
> Network Administrator                        FIDO: 2:5020/371.32
> PIRIT Corp.                              Phone: +7(095) 115-7101
> 
> 
> 
> ************
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@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